Received a random mySQL error, figured I'd throw it out there --
Looks like a user was searching all pages that someone had registered with a specific username. They searched yahoo for "allenprot" and my site was at the bottom of the third page --
http://search.yahoo.com/search?p=all...&pstart=1&b=21
The link that Yahoo uses to get to my site:
http://rds.yahoo.com/_ylt=A0geu9Q_W5.../topXstats.php
Returns:
Database error in vBulletin 3.6.6:
Invalid SQL:
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM user ORDER BY posts DESC LIMIT 0,;
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 '' at line 1
Error Number : 1064
Date : Monday, January 21st 2008 @ 09:58:53 PM
Script :
http://www.mifbody.com/vbulletin/topXstats.php
Referrer :
http://search.yahoo.com/search?p=all...&pstart=1&b=21
IP Address : 71.227.110.73
Username : meissen (in my case -- the original error said unregistered, so it happens for members and non-members)
Classname : vb_database