Quantcast WoWInterface - View Single Post - Search results bigger than 1 page
View Single Post
10-16-12, 03:00 PM   #5
Fishing Trainer
Seerah's Avatar
WoWInterface Super Mod
Join Date: Oct 2006
Posts: 10,467
Thank you for the detailed instructions, zohar101. This does, indeed, happen to me as well. However, my database error page also states what the error actually was:

Database error in vBulletin 3.6.8:

Invalid SQL:
 SELECT f.id, f.settings, f.uploadusername, f.uploaderid, f.ftitle, f.version, f.description, f.date, f.lastmodifydate, f.hits, f.edited, f.wgp, f.compatibility, c.id, c.title 
		FROM s_download_files f INNER JOIN s_download_categories c ON (f.catid = c.id) 
		WHERE (f.ftitle LIKE '%spam%' OR f.description LIKE '%spam%')  AND compatibility IN ()  
		GROUP BY f.id
				  ORDER BY f.date DESC
				  LIMIT 25,25;

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 ')  
		GROUP BY f.id
				  ORDER BY f.date DESC
				  LIMIT 25,25' at line 3
Error Number : 1064
Date         : Tuesday, October 16th 2012 @ 03:58:24 PM
Script       : http://www.wowinterface.com/downloads/search.php?search=spam&patch=13&title&description&sb=date&so=desc&page=2
Referrer     : 1
IP Address   :
Username     : Seerah
Classname    : vB_Database
Dolby should be able to find the problem and put in a fix now.
"You'd be surprised how many people violate this simple principle every day of their lives and try to fit square pegs into round holes, ignoring the clear reality that Things Are As They Are." -Benjamin Hoff, The Tao of Pooh

  Reply With Quote