finch
08-18-2004, 07:11 PM
an unregistered friend of mine was viewing the "reviews" page of my vBa, and he gets this error.
SELECT
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(2,3,6) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 5
i checked in the post for vBa on vB.org, and couldnt find anything except to repair and optimise the mysql, so i did. no luck.
i'm allowing unregistered users to view all pages, just that one gives that error.
any ideas?
(i had vBindex installed, but i deleted the files. is there any database modifications that it does when you install it that i missed?)
SELECT
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(2,3,6) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 5
i checked in the post for vBa on vB.org, and couldnt find anything except to repair and optimise the mysql, so i did. no luck.
i'm allowing unregistered users to view all pages, just that one gives that error.
any ideas?
(i had vBindex installed, but i deleted the files. is there any database modifications that it does when you install it that i missed?)