Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2010, 04:49 AM
hipgirl hipgirl is offline
 
Join Date: Sep 2007
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 10-04-2010, 11:36 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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".
Reply With Quote
  #3  
Old 10-05-2010, 01:59 AM
hipgirl hipgirl is offline
 
Join Date: Sep 2007
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's it!

Thank you sooooooooooo much.

Michelle
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:25 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03965 seconds
  • Memory Usage 2,179KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete