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
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
Comment