No announcement yet.

error after delete a member

  • Filter
  • Time
  • Show
Clear All
new posts

  • error after delete a member

    after i delete all threads and posts of member zzzlan then i delete this member. after that when i open some posts and theads in forum to read or click on Rebuild Forum Information in admincp maintenance i receive the following error ...
    p.s: i have already made counter update in admincp after deletion.

    Database error in vBulletin 3.5.1:
    Invalid SQL:
    SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
    ,post.pagetext AS preview
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    FROM thread AS thread
    INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
    LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
    LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
    WHERE thread.threadid IN (23, 222, 128, 100, 225) AND thread.visible = 1

    AND thread.postuserid NOT IN (zzzlan)
    ORDER BY lastpost DESC;
    MySQL Error : Unknown column 'zzzlan' in 'where clause'
    Error Number : 1054
    Date : Friday, December 16th 2005 @ 06:10:41 PM
    Last edited by quachvu; Fri 16 Dec '05, 9:58am.

  • #2
    To fix this, remove 'zzzlan' from the Tachy Goes to Coventry setting here:

    Admin CP -> vBulletin Options -> User Banning Options -> Tachy Goes to Coventry
    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.


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