Little help please - Data Base error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • apeman350
    New Member
    • Jan 2009
    • 25
    • 3.8.x

    [Forum] Little help please - Data Base error

    Hello VB world

    I am kinda new to Vb admin.

    I started getting this error after I pruned ALL of a users threads and post.

    There are multiple issues with this error. It seems that NONE of my other users are able to view any threads (so in a sense) my board is down

    My ADMIN account (the admin account that pruned the threads) does function for the most part.

    Here is the error :

    Database error in vBulletin 4.0.6:

    Invalid SQL:

    SELECT MIN(postid) AS postid
    FROM post
    WHERE threadid = 417
    AND visible = 1
    AND dateline > 1300042964
    AND userid NOT IN (Waydaynab)
    LIMIT 1;

    MySQL Error : Unknown column 'Waydaynab' in 'where clause'
    Error Number : 1054
    Request Date : Sunday, March 13th 2011 @ 12:05:33 PM
    Error Date : Sunday, March 13th 2011 @ 12:05:33 PM
    Script : http://internetsweepstakesforum.com/...!&goto=newpost
    Referrer : http://internetsweepstakesforum.com/forum.php
    IP Address : 75.181.44.153
    Username : admin
    Classname : vB_Database
    MySQL Version : 5.0.91-log
    "Lift the self by the self
    Never let the self droop down.
    Because the self is the self's only enemy
    The self is the self's only friend"
    Bhagavad-Gita
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    To fix this, remove 'Waydaynab' from the global ignore option here:

    Admin CP -> Settings -> Options -> User Banning Options -> Global Ignore
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...