Announcement

Collapse
No announcement yet.

Update Failure - Help?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Update Failure - Help?

    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

  • #2
    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.

    Comment


    • #3
      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.

      Comment


      • #4
        Did your 4.2.2 installation have the CMS installed?
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.2 Demo
        AdminAmmo - My Cloud Demo

        Comment


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

          Comment

          Related Topics

          Collapse

          Working...
          X