Database error (unknown column) during upgrade from 4.2.2 to 5.1.9

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ndoktoruser
    Member
    • Aug 2015
    • 69
    • 5.1.x

    Database error (unknown column) during upgrade from 4.2.2 to 5.1.9

    Hello!

    I got an error in one of the steps of the upgrade from 4.2.2 to 5.1.9

    Database error in vBulletin 5.0.0 Alpha 27:

    Invalid SQL:
    INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)

    VALUES('2ceea9450c8375d9030083a3c5e5ff20',0,'10.0.2.2','58e6fef706f97092a606fa4cb78f55c7', 1442427660,'',21,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0',0,0,0,'',0)
    /**session**/;
    Investigating the files vb4/install/mysql-schema.php (this file does not exist in the repository during the upgrade process, I only checked it to understand how the table is created) and vb5/core/install/mysql-schema.php, I see that the table created in the version 4 doesn't have the column emailstamp, whereas the version 5 has emailstamp (but maybe the create table sql isn't performed, once the table already exists).

    Note: even though the upgrade process stops, if I reopen the upgrade page and continue the process, I can finish the upgrade and the table session will contain field emailstamp.

    As far as I read, at the first error, I should stop the upgrade process.
    What should I do? Should I simply alter my table before the upgrade to 5.1.9?

    Thanks in advance!
    Last edited by ndoktoruser; Thu 17 Sep '15, 1:59am.
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    Does the upgrade complete if you refresh it?
    If so, then I would not be concerned unless you run into any actual errors while using the forum.
    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

    • ndoktoruser
      Member
      • Aug 2015
      • 69
      • 5.1.x

      #3
      Hello!

      Yes, the upgrade completes if I refresh the upgrade page.
      And, so far, I did not find any actual error browsing the upgraded forum.

      Thanks for the answer!

      Comment

      Related Topics

      Collapse

      Working...