| Andrew |
09-18-2005 11:17 PM |
MySQL Error on 3.0.9 Installation
A clients site I frequently work on is getting the following error when trying to access the CMPS:
Code:
Database error in vBulletin 3.0.9:
Invalid SQL:
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
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb_thread as thread
LEFT JOIN vb_icon USING (iconid)
LEFT JOIN vb_forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN( ) AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
mysql error number: 1064
Date: Sunday 18th of September 2005 09:14:43 PM
Script: http://vincebaby.com/index.php
Referer:
Username: ShellR
The forums and all other hacks are working fine - Any ideas what could be causing this ? |
More Information