Log in

View Full Version : MySQL Error After Upgrade

theArchitect
09-28-2005, 09:57 AM
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
09-28-2005, 10:04 AM
vBulletin Updates wipe vBulletin Settings that are volatile=1 and not attached to other products.
So this is most likely empty causing the Error:

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


Hmm ... but didn't I make a product XML?
theArchitect
09-28-2005, 11:16 AM
vBulletin Updates wipe vBulletin Settings that are volatile=1 and not attached to other products.
So this is most likely empty causing the Error:

$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
09-28-2005, 11:31 AM
You'll have to re-add the settings in the vBulletion Options. The upgrade wiped them out.
theArchitect
09-28-2005, 11:37 AM
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.