Announcement

Collapse
No announcement yet.

4.0.5 to 4.1.1, total failure

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [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

  • #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


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

      Comment


      • #4
        Running for 3h30 now...

        Comment


        • #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


          • #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


            • #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


              • #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


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

                  Comment


                  • #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


                    • #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


                      • #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


                        • #13
                          where is that?

                          Comment


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

                            Comment


                            • #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...
                              X