Update Failure - Help?

[fowler1416]

Update:

I have tried to move to version 5.0.5 from 4.2.2, and have found and fixed the SMTP issue previously identified.

Here's the problem, but I'm not sure how to fix it. I get this following SQL error once the upgrade.php starts. It seems to be flagging on a userid from table "forum", but I'm not sure what exactly I need to fix. Help?

<?xml version="1.0" encoding="windows-1252"?>

Database error in vBulletin 4.2.2:

Invalid SQL:
/*** now forums top level ***/
SELECT f.title, f.title_clean, f.description, f.forumid, f.displayorder, f.options,
IF(isnull(lp.userid),0,lp.userid) AS lastauthorid,
IF(isnull(lp.username),'',lp.username) AS lastcontentauthor
FROM forum AS f
LEFT JOIN post AS lp ON lp.postid = f.lastpostid
LEFT JOIN node AS existing ON existing.oldid = f.forumid AND existing.oldcontenttypeid =
WHERE f.parentid < 1 AND existing.nodeid IS NULL;

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 'WHERE f.parentid < 1 AND existing.nodeid IS NULL' at line 8
Error Number : 1064
Request Date : Tuesday, May 6th 2014 @ 03:26:44 PM
Error Date : Tuesday, May 6th 2014 @ 03:26:44 PM
Script : http:///forum/core/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vB_Database_MySQL
MySQL Version : 5.5.36-cll

[Zachery]

You're missing ID's in that query. I'd suggest restoring a backup, and upgrading to 5.1.0, and not 5.0.5.

[fowler1416]

We tried restoring form a backup and upgrading to 5.1 as you suggested and still get the exact same error that is shown above. Please help. We are way way behind schedule on this upgrade.

[Mark.B]

Did your 4.2.2 installation have the CMS installed?

[fowler1416]

We finally got things to work. Thanks for all the help.