MySQL Error After Upgrade

[theArchitect]

I have a hack on my home page which displays the Top 10 Threads. But since I have upgraded from RC2 to RC3 I have been getting this error message:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

		SELECT
			threadid, thread.title, thread.lastpost, thread.forumid, postusername, thread.lastposter, postuserid, views, thread.replycount, forum.title AS forumtitle
		FROM thread AS thread
		LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
		WHERE visible = 1 AND thread.forumid IN (, )
		ORDER BY thread.lastpost DESC;

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 ' )
		ORDER BY thread.lastpost DESC' at line 5
Error Number : 1064

So I have removed the plug-in.

However, this is one of the most popular of my boards modifications and my members would like it back.

The hacks author is on extended leave and I can't contact him, KirbyDE kindly ported it over from 3.0 for me and I don't want to impose on him again.

So if someone could assist it would be apprecaited.

The plug-in is attached.

[Andreas]

vBulletin Updates wipe vBulletin Settings that are volatile=1 and not attached to other products.
So this is most likely empty causing the Error:

PHP Code:

$id1last = $vbulletin->options['id1last'];
$id2last = $vbulletin->options['id2last']; 


Hmm ... but didn't I make a product XML?

[theArchitect]

Originally Posted by KirbyDE

vBulletin Updates wipe vBulletin Settings that are volatile=1 and not attached to other products.
So this is most likely empty causing the Error:

PHP Code:

$id1last = $vbulletin->options['id1last'];
$id2last = $vbulletin->options['id2last']; 


Hmm ... but didn't I make a product XML?

You are right that it wasn't a product, but a plug-in.

So, should I clear the vBulletin settins and start again with the same plug-in?

[Boofo]

You'll have to re-add the settings in the vBulletion Options. The upgrade wiped them out.

[theArchitect]

Originally Posted by Boofo

You'll have to re-add the settings in the vBulletion Options. The upgrade wiped them out.

I see. I am off to fix them.

Thanks, I didn't know vB did that.

Edit:

Fixed and working brilliantly.

Many thanks for your help.