MySQL Errors After Upgrade

[Pirate45]

I upgraded my site yesterday from 3.5.4 to 3.6.2 and everything seemed to go well. It was my first upgrade and I took my time and followed the instructions...

Also, forgive me if I am asking a common question please.

I am now getting these errors by e-mail:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT thread.pollid, open, threadid, replycount, forumid, question,
poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters,
public
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)

WHERE open <> 10 AND visible = 1 AND active = 1




ORDER BY;

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 '' at line
10
Error Number : 1064

Date : Sunday, October 8th 2006 @ 12:24:09 AM

---


Thanks in advance for any help.

[Paul M]

Can you post the whole message so we can see what script was in use.

[Pirate45]

Sure,

Sorry about that:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT thread.pollid, open, threadid, replycount, forumid, question,
poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters,
public
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)

WHERE open <> 10 AND visible = 1 AND active = 1




ORDER BY;

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 '' at line
10
Error Number : 1064
Date : Sunday, October 8th 2006 @ 12:24:09 AM
Script : http://www.*******.com/index.php
Referrer :
IP Address : 72.30.61.82
Username : Unregistered
Classname : vb_database

[Paul M]

That's not in vb's index.php (infact, that index.php doesn't appear to be in your forum root folder) do you have cmps or something similar installed ?

[Pirate45]

Yes but it was broken after I upgraded so I disabled it.

Is that the problem?

[Mythotical]

I suggest upgrading your cmps or reinstalling it. Which CMPS are you using? If your using vBadvanced CMPS for 3.5.4 then you need to upgrade it to the version released for 3.6

[Pirate45]

Yeah, and I did but something is wrong and I can't figure it out.

I will look later when my brain can withstand it.

[Mythotical]

Ok, just post back if you need further assistance.