PDA

View Full Version : Database Error when searching individual user's posts


WitchyT
08-29-2004, 02:49 PM
Anyone have an idea how to fix this? I tried searching through this forum for an answer, but no such luck. Thanks.

Database error in vBulletin 2.3.5:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
LEFT JOIN thread ON thread.threadid=post.threadid WHERE post.visible=1 AND post.threadid= AND 1=1 AND NOT (thread.forumid='8' OR thread.forumid='9' OR thread.forumid='10' OR thread.forumid='12' OR thread.forumid='145' OR thread.forumid='150' OR thread.forumid='13' OR thread.forumid='14' OR thread.forumid='15' OR thread.forumid='151' OR thread.forumid='16' OR thread.forumid='17' OR thread.forumid='18' OR thread.forumid='19' OR thread.forumid='20' OR thread.forumid='21' OR thread.forumid='22' OR thread.forumid='23' OR thread.forumid='24' OR thread.forumid='25' OR thread.forumid='26' OR thread.forumid='27' OR thread.forumid='28' OR thread.forumid='29' OR thread.forumid='144' OR thread.forumid='146' OR thread.forumid='147' OR thread.forumid='157' OR thread.forumid='158' OR thread.forumid='159' OR thread.forumid='160') AND post.userid='44'
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 'AND 1=1 AND NOT (thread.forumid='8' OR thread.forumid='9' OR t

mysql error number: 1064

Date: Sunday 29th of August 2004 11:39:51 AM
Script: http://elemental.nexcess.net/search.php?action=showresults&searchid=3444
Referer:
Repair Report: This type of error cannot be automatically repaired.

Dean C
08-29-2004, 03:04 PM
Have you installed any modifications?

WitchyT
08-29-2004, 03:09 PM
Well, the last hack or mod I tried installing, was TECK's vbmicrostats. That didn't work out, so I had to uninstall it.

The only hacks or mods that I installed relating to search.php are the search thread and who posted (view individual posts by user in thread) hacks. They seemed to be working fine. We also transferred (db) to a different host, so I'm not sure if it's moreover relating to our new host. Never had this problem with the old host/vb.

Dean C
08-29-2004, 03:13 PM
The only hacks or mods that I installed relating to search.php are the search (view individual posts by user in thread) thread and who posted hacks.


Uninstall this and see if it fixes it.

WitchyT
08-29-2004, 03:17 PM
It worked. Thanks! Guess I'll just go about and reinstall those hacks, and see what I did wrong or what not.