upgrade to v4 bug

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sushubh
    Senior Member
    • Apr 2007
    • 194
    • 5.0.0

    [Suite] upgrade to v4 bug

    the first bug was related to some sitemap scheduled setting.

    MySQL Error : Duplicate entry 'sitemap' for key 2
    i got rid of that.

    cannot get this new bug...

    Invalid SQL:
    INSERT INTO forum_tagcontent
    (tagid, contenttypeid, contentid, userid, dateline)
    SELECT tagid, 2, threadid, userid, dateline
    FROM forum_tagthread;

    MySQL Error : Duplicate entry '1-2-26053' for key 1
    Error Number : 1062
    Request Date : Monday, December 21st 2009 @ 02:22:14 PM
    Error Date : Monday, December 21st 2009 @ 02:22:15 PM
    Script : http://broadbandforum.in/install/upg...0a1.php?step=3
    Referrer : http://broadbandforum.in/install/upg...0a1.php?step=3
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    What version are you upgrading from?

    Comment

    • Sushubh
      Senior Member
      • Apr 2007
      • 194
      • 5.0.0

      #3
      Version 3.8.4 P1

      i guess it is related to some tag related plugin. i used to use zoint at one point of time. but stopped using it when VB added native tag support.

      i have disabled all plugins before i started installing.

      basically. i have never really cared about removing database table content added by third party plugins. could this be the reason?

      is there a way to remove all the unofficial tables in the database related to VB now that i would have to start fresh with plugins?

      Comment

      • steven s
        Senior Member
        • Jul 2004
        • 3722
        • 3.8.x

        #4
        I don't think there really is any reason to remove third party plugin tables if they don't uninstall automatically.
        ...steven
        www.318ti.org (vB3.8) | www.nccbmwcca.org (vB4.2)
        bmwcca.org/forum | m135i.net
        "I tried to clean this up but this thread is beyond redemption." - Steve Machol

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          This is actually an entry in cron.php it looks like. Did you have a vbseo sitemap installed.

          Comment

          • Sushubh
            Senior Member
            • Apr 2007
            • 194
            • 5.0.0

            #6
            so i guess tagcontent is an official vbulletin related table in the database?

            the sitemap problem i got initially was related to the scheduled setting made by vbseo plugin. disabling plugin just 'stopped' the scheduled task but it still existed in the table.

            i have that installed. but i disabled it before trying the upgrade. in fact i had to uninstall vbseo sitemap to get rid of the scheduled task entry. the current problem is related to the tag table i guess.

            define('DISABLE_HOOKS', true);
            would it help in my case? i did disable all the plugins manually.

            Comment

            • Sushubh
              Senior Member
              • Apr 2007
              • 194
              • 5.0.0

              #7
              if i empty the tagcontent table from the database using phpmyadmin... would it affect anything?

              Comment

              • icarusforde
                Senior Member
                • Feb 2009
                • 1594
                • 3.8.x

                #8
                You can try....

                Backup first though.

                Comment

                • Sushubh
                  Senior Member
                  • Apr 2007
                  • 194
                  • 5.0.0

                  #9
                  oh yeah. i disabled the forum. then made a complete backup. have been experimenting with the update script only after that.

                  already have had to restore the backup 2 times. coz installer failed on both the attempts.

                  Comment

                  • RadioErewan
                    Senior Member
                    • Feb 2008
                    • 821
                    • 3.8.x

                    #10
                    I had simillar problems with cron.php. Sitemap (had vBSEO sitemap plugin) is conflicting with something new from Vanilla install. Even uninstalling vBSEO Sitemap Generator leaves this entry in database and every fresh dev upgrade I have to remove it manually.

                    Comment

                    • icarusforde
                      Senior Member
                      • Feb 2009
                      • 1594
                      • 3.8.x

                      #11
                      The installer shouldnt foul up your database though...

                      Comment

                      • Sushubh
                        Senior Member
                        • Apr 2007
                        • 194
                        • 5.0.0

                        #12
                        great. a new error...

                        Database error in vBulletin 3.8.4:

                        Invalid SQL:

                        ALTER TABLE xxx_thread
                        ADD lastposterid INT UNSIGNED NOT NULL DEFAULT 0;

                        MySQL Error : Duplicate column name 'lastposterid'
                        Error Number : -1
                        Request Date : Monday, December 21st 2009 @ 03:25:53 PM
                        Error Date : Monday, December 21st 2009 @ 03:25:54 PM
                        Script : http://broadbandforum.in/install/upg...0a1.php?step=2
                        Referrer : http://broadbandforum.in/install/upg...0a1.php?step=1
                        IP Address : 122.163.175.49
                        Username :
                        Classname : vB_Database
                        MySQL Version :
                        i dont think i would try cleaning the lastposterid column from the thread table!

                        any suggestions?

                        i was trying with the cms edition. i am going to try it out with the forum edition. let's see if that works out. i doubt so. any professionals here on the forum who can help me upgrade for a small fee?
                        Last edited by Sushubh; Mon 21 Dec '09, 1:33pm.

                        Comment

                        • Zachery
                          Former vBulletin Support
                          • Jul 2002
                          • 59097

                          #13
                          Did you take a backup before you began running the installer?

                          Comment

                          • Sushubh
                            Senior Member
                            • Apr 2007
                            • 194
                            • 5.0.0

                            #14
                            yeap. i have a backup of the last working state of forum. been restoring after every failed attempt.

                            Comment

                            • Zachery
                              Former vBulletin Support
                              • Jul 2002
                              • 59097

                              #15
                              Make sure you're not restoring it to the same database. Try restoring to a new database, make a note to uninstall the vbseo site map addon.

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...