PDA

View Full Version : Unknown column in 'where clause'


hipgirl
10-04-2010, 04:49 AM
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/search.php?searchid=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/showthread.php?t=61493&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

kh99
10-04-2010, 11:36 AM
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".

hipgirl
10-05-2010, 01:59 AM
That's it!

Thank you sooooooooooo much.

Michelle