4.0.5 to 4.1.1, total failure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • krustyx
    Member
    • Jul 2007
    • 85

    [Suite] 4.0.5 to 4.1.1, total failure

    Uploaded everthing.

    went to ./install/upgrade.php

    started, but from 4.0.7 to 4.0.8 its stuck at step #2

    SQL process running forever (running for 80 minutes)
    283 4281 Sending data ### vBulletin Database Alter ### DELETE searchcore_text FROM searchcore_text LEFT JOIN search

    receiving email errors

    Database error in vBulletin 4.0.7:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
    VALUES
    ('4e182b17dad46fcf5c5e991df97bd217', 0, '67.195.115.109', '275a8199bb5f62a2602bca23ef1bb205', 1295120060, '/forum/showthread.php?175013-Gros-spcial-chip-Dyno-Unitronic-V-A-G-Motorsport/page3', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)', 0, 0, 0, '');

    MySQL Error : Unknown column 'apiclientid' in 'field list'
    Error Number : 1054

    need help, nothing is working
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Those db errors are because tour database is still 4.0.7 and the files are 4.1.1. Depending on the size of the database and the specs of your server, that step may take a long time.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • krustyx
      Member
      • Jul 2007
      • 85

      #3
      So you are saying that i need to let it go?

      Comment

      • krustyx
        Member
        • Jul 2007
        • 85

        #4
        Running for 3h30 now...

        Comment

        • krustyx
          Member
          • Jul 2007
          • 85

          #5
          Ok, its over (the process is not there anymore), but the webpage was not doing anything, so i refreshed and it started all over again :|

          Comment

          • krustyx
            Member
            • Jul 2007
            • 85

            #6
            seriously, it doesnt work, this commands takes forever... so long, that the DB is crashing all the time

            I guess ill be stuck with 4.0.7 all my life... wow

            Comment

            • wda2015
              Senior Member
              • May 2001
              • 1135

              #7
              have you a backup of your old site?.. restore it and try again uploading the new files and running the upgrade.
              Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

              Comment

              • krustyx
                Member
                • Jul 2007
                • 85

                #8
                Yup, i repaired/optimized the database to make sure everything was OK.

                Uploaded the backup, site was fine and everything.

                Re-Uploaded the 4.1.1 files, runned the upgrade again

                stuck on Step 14 - Updating searchgroup_text table / Status: Processing 4.0.8, Step 15 of 16

                This is the size of my tables

                searchcore ~1 193 772 InnoDB latin1_swedish_ci 251,0 Mio -
                searchcore_text 1 199 447 MyISAM latin1_swedish_ci 608,8 Mio -
                searchgroup ~128 714 InnoDB latin1_swedish_ci 18,1 Mio -
                searchgroup_text 128 406 MyISAM latin1_swedish_ci 11,9 Mio -


                And the SQL process running is Sending data ### vBulletin Database Alter ### DELETE searchcore_text FROM searchcore_text LEFT JOIN search


                Restarted it 10 minutes ago

                ------ Query Status ------
                Time Elapsed: 00:09:14, State: Sending data, Query: DELETE searchcore_text FROM searchcore_text LEFT JOIN searchcore ON (searchcore.searchcoreid = searchcore_text.searchcoreid) WHERE searchcore.searchcoreid IS NULL


                receiving tons of VBulletin Datase Error! emails

                Database error in vBulletin 4.0.7:

                Invalid SQL:

                INSERT IGNORE INTO session
                (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
                VALUES
                ('cedb924defbbdbd62f7187b336e87e81', 0, '207.46.195.228', 'a40781954205daa42f7dd679e98837e1', 1295177056, '/forum/showthread.php?293964-changement-pièce', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)', 0, 0, 0, '');

                MySQL Error : Unknown column 'apiclientid' in 'field list'
                Error Number : 1054
                Request Date : Sunday, January 16th 2011 @ 06:24:16 AM
                Error Date : Sunday, January 16th 2011 @ 06:24:16 AM

                Comment

                • krustyx
                  Member
                  • Jul 2007
                  • 85

                  #9
                  It just doesnt work, left it the whole night and everything ends up by crashing...

                  Comment

                  • wda2015
                    Senior Member
                    • May 2001
                    • 1135

                    #10
                    have you got hacks/addons added to your site?, if so then try disable or uninstall/remove them..
                    Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

                    Comment

                    • krustyx
                      Member
                      • Jul 2007
                      • 85

                      #11
                      Yes of course, but website is down while im doing this.

                      Theres something wrong with the database...

                      MySQL Error : Unknown column 'apiclientid' in 'field list'... how can i solve this? Can i creat it manually? i dont know, thats not normal

                      Comment

                      • wda2015
                        Senior Member
                        • May 2001
                        • 1135

                        #12
                        Did you setup vBulletin API in admincp? i think the error is something there by the look of the database error you posted.

                        I don't know if you can disable that and try again. i never used it in the past myself but it does say..

                        Once a key is generated, you can't change it in future.
                        Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

                        Comment

                        • krustyx
                          Member
                          • Jul 2007
                          • 85

                          #13
                          where is that?

                          Comment

                          • krustyx
                            Member
                            • Jul 2007
                            • 85

                            #14
                            Anyway, after spending 36h on this thing, i quit... seriously, im pissed

                            Comment

                            • wda2015
                              Senior Member
                              • May 2001
                              • 1135

                              #15
                              I sent PM
                              Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

                              Comment

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