No announcement yet.

error after delete a member

  • Filter
  • Time
  • Show
Clear All
new posts

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

    Admin CP -> vBulletin Options -> User Banning Options -> Tachy Goes to Coventry

    Leave a comment:

  • quachvu
    started a topic error after delete a member

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.