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
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