install problem

[sifuhall]

I'm still running vb 3.0.3

I installed VB CMPS today and my forum is working fine, however on my cmps_index.php page I get:

Database error in vBulletin 3.0.3:

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 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')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid IN (9,11,37,12,13,14,15,16,36,88,60,10,17,87,47,19,) AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10

mysql error: You have an error in your SQL syntax near ') AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10
' at line 15

mysql error number: 1064

Date: Wednesday 05th of January 2005 12:00:15 PM
Script: http://www.dragonslist.com/cmps_index.php
Referer:
Username: webmaster
IP Address: xxx.xxx.xxx.xxx

[sifuhall]

Duh, found it.

My bad.

Shhhhh.... don't tell anyone I'm a DBA and didn't spot my problem right away.

[ConqSoft]

AND thread.forumid IN (9,11,37,12,13,14,15,16,36,88,60,10,17,87,47,19,)

Extra comma at the end of the forumid list.

[ConqSoft]

Originally Posted by sifuhall

Duh, found it.

My bad.

Shhhhh.... don't tell anyone I'm a DBA and didn't spot my problem right away.

Too late, I was already replying. :P