Upgrade from RC4 to Gold wasn't smooth

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TransAmDan
    Member
    • Oct 2009
    • 81

    Upgrade from RC4 to Gold wasn't smooth

    During the upgrade from RC4 to gold it wanted to greate fields in table cms_nodeinfo > RatingNum and a few other fields, but was already in the database, so this created an error.
    What I then done was a clean install and then strapped in my original data into the database. I've uploaded all new PHP files. However now have "Version 4.0.0 Release Candidate 2" at the footer of the forum? Is the release version stored in the database?
    Last edited by TransAmDan; Tue 22 Dec '09, 5:16am.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    So after having an unsuccessful upgrade, you then imported a backup database into the new vB4 database? You cannot just do that and have it run correctly. You need to run the upgrade script on the database you imported.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • TransAmDan
      Member
      • Oct 2009
      • 81

      #3
      Upgrade script on database from backup returns a few errors.

      Database error in vBulletin 4.0.0:
      Invalid SQL:
      ALTER TABLE cms_nodeinfo ADD ratingnum INT UNSIGNED NOT NULL DEFAULT '0';
      MySQL Error : Duplicate column name


      Database error in vBulletin 4.0.0:
      Invalid SQL:
      INSERT INTO action (routeid, packageid, controller, useraction, classaction) VALUES (1, 3, 'Content', 'rate', 'Rate');
      MySQL Error : Duplicate entry '1-rate' for key 2


      So it seems to be complaining about items that were already created in the upgrade from RC2 to RC4. There are many more errors similar to this. Which is the best way to move forward on this? I'm tempted to install a clean database and then copy data across table by table ensuring the table structure is exact. However 231 tables could take some time, although not all contain data at this point.

      Comment

      • TransAmDan
        Member
        • Oct 2009
        • 81

        #4
        Upgrade all done and working fine, funalupgrade step 6 creates the problem shown above, so I skipped that step by editing the URL to end in 7.

        Comment

        • mjp
          Member
          • Nov 2003
          • 72

          #5
          Originally posted by TransAmDan
          I skipped that step by editing the URL to end in 7.
          That is awe-inspiring! You might appreciate this site . . .

          Comment

          • TransAmDan
            Member
            • Oct 2009
            • 81

            #6
            Originally posted by mjp
            That is awe-inspiring! You might appreciate this site . . .
            Thanks for the compliments on my achievements.
            It wasn't my first thing I tried. This step was adding fields to the database that were already there. I installed a fresh database and compared all table structures from my original database with the fresh one. Took some time to do, but now have V4 working. Had some troubles with previous upgrades to, so its not the first time I've had to manipulate the tables in the database.

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24325
              • 5.7.X

              #7
              When you restored your backup, did you drop all tables or just use the script created when you backed up to do this for you?
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              Related Topics

              Collapse

              Working...