Problem with Database after upgrade

[vitoreis]

Hi,

I've just upgraded vBadvanced to the latest version (3.0 RC1) and now I got this error in index.php (cmps_index.php):

Database error in vBulletin 3.6.2:

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.forumid
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as 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(Array)

ORDER BY lastpost DESC
LIMIT 5;

MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Classname : vb_database

Any idea what this could be please?

Thanks for the help.
Vitor Reis

[Brian]

Do you perhaps have any copies of the Recent Threads module that are not using the default recentthreads.php (formeraly latesttopics.php) file? If so, I would recommend changing them to use include recenttopics.php instead. Otherwise, try editing any recent threads module you have, make sure you have the forum(s) selected that you would like to pull your threads from, and then save the module to be sure that the settings are updated and see if that helps.

[1996 328ti]

Cool. This was the error I had also.
I have a 2nd recent threads module that is used as a for sale section.
Now it's working again.