Hello,
The last few weeks I recieve SQL error messages. Now I wonder if this is an error, or a hack attempt. Could you please help me?
Thanks,
Robert
Database error in vBulletin 4.2.3:
Invalid SQL:
SELECT userid, username, email, usergroupid, FROM_UNIXTIME(lastvisit) lastvisit, FROM_UNIXTIME(lastactivity) lastactivity, CASE WHEN lastpost = 0 THEN '' ELSE FROM_UNIXTIME(lastpost) END AS lastpost, CASE WHEN rmEmailDate = 0 THEN '' ELSE FROM_UNIXTIME(rmEmailDate) END AS lastreminder, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastvisit, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastactivity, CASE WHEN lastpost = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastpost), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastpost, CASE WHEN rmEmailDate = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastemail, rmoptout FROM user WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 90 AND usergroupid IN ('9') AND options & 16 AND rmoptout = 0 AND userid NOT IN ('22') LIMIT 0, 10;;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, January 2nd 2017 @ 01:40:01 AM
Error Date : Monday, January 2nd 2017 @ 01:40:33 AM
Script : http://www.mysite.com/forum/cron.php?rand=1483317599
Referrer : http://www.www.mysite.com/forum/forum.php
IP Address : 68.173.73.101
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
The last few weeks I recieve SQL error messages. Now I wonder if this is an error, or a hack attempt. Could you please help me?
Thanks,
Robert
Database error in vBulletin 4.2.3:
Invalid SQL:
SELECT userid, username, email, usergroupid, FROM_UNIXTIME(lastvisit) lastvisit, FROM_UNIXTIME(lastactivity) lastactivity, CASE WHEN lastpost = 0 THEN '' ELSE FROM_UNIXTIME(lastpost) END AS lastpost, CASE WHEN rmEmailDate = 0 THEN '' ELSE FROM_UNIXTIME(rmEmailDate) END AS lastreminder, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastvisit, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastactivity, CASE WHEN lastpost = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastpost), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastpost, CASE WHEN rmEmailDate = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastemail, rmoptout FROM user WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 90 AND usergroupid IN ('9') AND options & 16 AND rmoptout = 0 AND userid NOT IN ('22') LIMIT 0, 10;;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, January 2nd 2017 @ 01:40:01 AM
Error Date : Monday, January 2nd 2017 @ 01:40:33 AM
Script : http://www.mysite.com/forum/cron.php?rand=1483317599
Referrer : http://www.www.mysite.com/forum/forum.php
IP Address : 68.173.73.101
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Comment