Need help -> Upgrade to 4.2.5 via SSH: MySQL error error at end of upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • djbaxter
    Senior Member
    • Aug 2006
    • 1418
    • 4.2.5

    [Forum] Need help -> Upgrade to 4.2.5 via SSH: MySQL error error at end of upgrade

    Upgrade from 4.2.0 PL1 to 4.2.5 with large database.

    The site in question is http://www.politics.ie and it does have vBSEO installed although the intention is to remove that eventually.


    At present, your forum has more than 12,078,974 posts. If you encounter timeouts during the install process, there is a console version of the upgrade available to you. In order to perform a console upgrade, perform the following steps:

    Login to your server via SSH
    Change your directory to the install directory of your forums, example:
    cd /forums/install
    Execute the upgrade script, example:
    php -f upgrade.php

    Contact vBulletin Customer Support if you are still unsure of how to continue.
    I ran the upgrade via SSH.


    See error at Step 7 of Upgrading to 4.2.5 Beta 2:
    Code:
    [B]Step 7 - Upgrade Aborted : Unable to find Type : vBForum_IPAddress  <<< Note error here but upgrade continued[/B]
    Then:

    Code:
    [B]Upgrading to 4.2.5
    ----------------------------------
    Upgrade Complete[/B]

    So it appears that the main forum upgrade completed.

    But then it attempts to update the blog ((not actually being used; disabled):

    Code:
    [B]Step 18 - Database error in vBulletin 4.2.5:[/B]
    
    Invalid SQL:
    
                            SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
                            FROM blog_text bt
                            JOIN blog bl USING (blogid)
                            LEFT JOIN ipdata ip ON (
                                    bt.ipaddress = ip.ipid AND bt.blogtextid  = ip.contentid
                                    AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
                            )
                            WHERE ipid IS NULL;
    
    MySQL Error   : You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to use near ' )
                            )
                            WHERE ipid IS NULL' at line 6
    Error Number  : 1064
    Request Date  : Tuesday, September 11th 2018 @ 03:04:31 PM
    Error Date    : Tuesday, September 11th 2018 @ 04:48:57 PM
    Script        : http://
    Referrer      :
    IP Address    : IPADDRESS
    Username      :
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.6.40
    Server        :
    User Agent    :
    >>>> So I'm guessing the CMS (which is being used) did not get upgraded?




    Full output of Upgrade


    Code:
    Upgrading to 4.2.4 Beta 1
    ----------------------------------
    Step 6 - Altering post Table (1 of 1)
    Upgrade Complete
    
    Upgrading to 4.2.4 Beta 2
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.4 Beta 3
    ----------------------------------
    Step 1 - Altering moderator Table (1 of 1)
    Step 2 - Altering passwordhistory Table (1 of 2)
             Altering passwordhistory Table (2 of 2)
    Step 3 - Altering user Table (1 of 4)
             Altering user Table (2 of 4)
    Step 4 - Altering user Table (3 of 4)
             Altering user Table (4 of 4)
    Step 5 - Disable or Remove Old Products
    Upgrade Complete
    
    Upgrading to 4.2.4 Release Candidate 1
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.4 Release Candidate 2
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.4 Release Candidate 3
    ----------------------------------
    Step 1 - Updating Read Marking Option
    Upgrade Complete
    
    Upgrading to 4.2.4
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Alpha 1
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Alpha 2
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Alpha 3
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Beta 1
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Beta 2
    ----------------------------------
    Step 1 - Altering session Table (1 of 1)
    Step 2 - Altering threadrate Table (1 of 1)
    Step 3 - Altering apiclient Table (1 of 1)
    Step 4 - Altering apilog Table (1 of 1)
    Step 5 - Altering searchlog Table (1 of 1)
    Step 6 - Updating contenttype table (1 of 1)
    [B]Step 7 - Upgrade Aborted : Unable to find Type : vBForum_IPAddress  <<< Note error here but upgrade continued[/B]
    Step 8 - Altering ipdata Table (1 of 2)
             Altering ipdata Table (2 of 2)
    Step 9 - Updating postlog table
             Altering postlog table
             Altering postlog table
    Step 10 - ^C
    [root@vm2 install]# php -f upgrad.php
    Could not open input file: upgrad.php
    [root@vm2 install]# php -f upgrade.php
    
    Upgrading to 4.2.5 Beta 2
    ----------------------------------
    Step 10 - Altering searchcore Table (1 of 2)
              Altering searchcore Table (2 of 2)
    Step 11 - Updating adminmessage table
    Step 12 - Skipping step, not needed
    Step 13 - Updating groupmessage table
    Step 14 - Updating picturecomment table
    Step 15 - Updating visitormessage table
    Step 16 - Skipping step, not needed
    Upgrade Complete
    
    Upgrading to 4.2.5 Beta 3
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Beta 4
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Release Candidate 1
    ----------------------------------
    Upgrade Complete
    
    Upgrading to 4.2.5 Release Candidate 2
    ----------------------------------
    Upgrade Complete
    
    [B]Upgrading to 4.2.5
    ----------------------------------
    Upgrade Complete[/B]

    Code:
    Processing Blog
    ----------------------------------
    Step 1 - Skipping step, not needed
    Step 2 - Skipping step, not needed
    Step 3 - Skipping step, not needed
    Step 4 - Skipping step, not needed
    Step 5 - Skipping step, not needed
    Step 6 - Skipping step, not needed
    Step 7 - Skipping step, not needed
    Step 8 - Skipping step, not needed
    Step 9 - Skipping step, not needed
    Step 10 - Skipping step, not needed
    Step 11 - Skipping step, not needed
    Step 12 - Skipping step, not needed
    Step 13 - Skipping step, not needed
    Step 14 - Skipping step, not needed
    Step 15 - Skipping step, not needed
    Step 16 - Skipping step, not needed
    Step 17 - Skipping step, not needed
    
    [B]Step 18 - Database error in vBulletin 4.2.5:[/B]
    
    Invalid SQL:
    
                            SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
                            FROM blog_text bt
                            JOIN blog bl USING (blogid)
                            LEFT JOIN ipdata ip ON (
                                    bt.ipaddress = ip.ipid AND bt.blogtextid  = ip.contentid
                                    AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
                            )
                            WHERE ipid IS NULL;
    
    MySQL Error   : You have an error in your SQL syntax; check the manual that correspondsto your MySQL server version for the right syntax to use near ' )
                            )
                            WHERE ipid IS NULL' at line 6
    Error Number  : 1064
    Request Date  : Tuesday, September 11th 2018 @ 03:04:31 PM
    Error Date    : Tuesday, September 11th 2018 @ 04:48:57 PM
    Script        : http://
    Referrer      :
    IP Address    : IPADDRESS
    Username      :
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.6.40
    Server        :
    User Agent    :
    [root@vm2 install]#
    Last edited by djbaxter; Tue 11 Sep '18, 9:25am.
    Psychlinks Web Services Affordable Web Design & Site Management
    Specializing in Small Businesses and vBulletin/Xenforo Forums
  • djbaxter
    Senior Member
    • Aug 2006
    • 1418
    • 4.2.5

    #2
    So two questions here:

    1. why the error in updating the blog and what do I do about it?

    2. if my assumption that the CMS did not get upgraded, what do I do about that at this point? Can I upgrade that separately, bypassing the blog error?
    Psychlinks Web Services Affordable Web Design & Site Management
    Specializing in Small Businesses and vBulletin/Xenforo Forums

    Comment

    • Mark.B
      vBulletin Support
      • Feb 2004
      • 24286
      • 6.0.X

      #3
      The starting point is that the blog product needs to be enabled before the upgrade is run.
      MARK.B
      vBulletin Support
      ------------
      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

      Comment

      • djbaxter
        Senior Member
        • Aug 2006
        • 1418
        • 4.2.5

        #4
        Can I do that and then start over at that point? If I re-run upgrade, will it skip quickly through the already completed stages and then proceed with blog and CMS?
        Psychlinks Web Services Affordable Web Design & Site Management
        Specializing in Small Businesses and vBulletin/Xenforo Forums

        Comment

        • djbaxter
          Senior Member
          • Aug 2006
          • 1418
          • 4.2.5

          #5
          Answer: I started the upgrade again after enabling the blog and it went straight to the blog update and then continued with the CMS upgrade.
          Psychlinks Web Services Affordable Web Design & Site Management
          Specializing in Small Businesses and vBulletin/Xenforo Forums

          Comment

          Related Topics

          Collapse

          Working...