After a month of use, I experienced these errors:
Quote:
Invalid SQL:
SELECT * from vb9_user_troll WHERE userid = '0' AND realip = 'xxx' ORDER BY timestamp DESC LIMIT 1;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
|
Quote:
Invalid SQL:
SELECT COUNT(*) AS trolledlinks FROM vb9_user_troll WHERE userlink = '0';
MySQL Error : Server shutdown in progress
Error Number : 1053
|
Quote:
Invalid SQL:
UPDATE vb9_user_troll SET userlink = '3423' WHERE idx = '153' LIMIT 1;
MySQL Error : Server shutdown in progress
Error Number : 1053
|
Quote:
Invalid SQL:
UPDATE vb9_user_troll SET timestamp = 1153908011, date = '%2006-%07-%26', username = 'Unregistered', userid = '0', time = '%11:%Jul:%th', opm = '0' WHERE idx = '37650' LIMIT 1;
MySQL Error : Server shutdown in progress
Error Number : 1053
|
Quote:
Invalid SQL:
SELECT userid,realip,timestamp from vb9_user_troll WHERE userid > 0 AND realip = 'xxx' ORDER by timestamp DESC, userid ASC LIMIT 1;
MySQL Error : Server shutdown in progress
Error Number : 1053
|
Quote:
Invalid SQL:
UPDATE vb9_user_troll SET timestamp = 1152565757, date = '%2006-%07-%10', username = 'Jack's Seratonin', userid = '0', time = '%22:%Jul:%th', opm = '0' WHERE idx = '21475' LIMIT 1;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Seratonin', userid = '0', time = '%22:%Jul:%th', opm = '0' WHE
Error Number : 1064
|
Note that the username was jack's serotonine. This error occurs many times where usernames include this symbol:
'
I've got many more, but they are variations on the same.