The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Unknown column in 'where clause'
Hello,
From this afternoon, whenever somebody reply post, edit post, create new thread, they got error messges: Unknown column 'hipgirl' in 'where clause'. Other thing are OK--search, PM etc. Please help. Below are several error messges: 1. Database error in vBulletin 3.8.3: Invalid SQL: SELECT post.postid FROM post AS post WHERE post.threadid = 63499 AND post.visible = 1 AND post.userid NOT IN (hipgirl) ORDER BY post.dateline LIMIT 0, 10; MySQL Error : Unknown column 'hipgirl' in 'where clause' Error Number : 1054 Request Date : Sunday, October 3rd 2010 @ 06:44:15 PM Error Date : Sunday, October 3rd 2010 @ 06:44:15 PM Script : http://hipgirlclips.com/forums/showthread.php?t=63499 Referrer : http://hipgirlclips.com/forums/searc...archid=3016201 2. SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1286164593 AND open <> 10, 1, 0)) AS newthread FROM thread AS thread WHERE forumid = 60 AND sticky = 0 AND visible = 1 AND postuserid NOT IN (hipgirl); MySQL Error : Unknown column 'hipgirl' in 'where clause' Error Number : 1054 Request Date : Sunday, October 3rd 2010 @ 11:23:30 PM Error Date : Sunday, October 3rd 2010 @ 11:23:30 PM Script : http://hipgirlclips.com/forums/forumdisplay.php?f=60 Referrer : http://hipgirlclips.com/forums/ 3. SELECT MIN(postid) AS postid FROM post WHERE threadid = 61493 AND visible = 1 AND dateline > 1286131396 AND userid NOT IN (hipgirl) LIMIT 1; MySQL Error : Unknown column 'hipgirl' in 'where clause' Error Number : 1054 Request Date : Sunday, October 3rd 2010 @ 08:40:27 PM Error Date : Sunday, October 3rd 2010 @ 08:40:27 PM Script : http://hipgirlclips.com/forums/showt...3&goto=newpost Referrer : 4. SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1286152929 AND open <> 10, 1, 0)) AS newthread FROM thread AS thread WHERE forumid = 27 AND sticky = 0 AND visible = 1 AND postuserid NOT IN (hipgirl); MySQL Error : Unknown column 'hipgirl' in 'where clause' Error Number : 1054 Request Date : Sunday, October 3rd 2010 @ 08:40:37 PM Error Date : Sunday, October 3rd 2010 @ 08:40:37 PM Script : http://hipgirlclips.com/forums/forumdisplay.php?f=27 Referrer : http://hipgirlclips.com/forums/ Thanks. Michelle |
#2
|
|||
|
|||
I think in vBulletin Options > User Banning Options > Tachy Goes to Coventry, someone has entered "hipgirl" when the field is supposed to be "a list of userid numbers".
|
#3
|
|||
|
|||
That's it!
Thank you sooooooooooo much. Michelle |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|