Tweet
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.
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
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
Comment