Announcement

Collapse
No announcement yet.

upgrade: problem at step 5

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

  • upgrade: problem at step 5

    hi everybody,

    my upgrading stopped at step 5/ post. I refreshed my browser, but it doesn't go further. I have about 400.000 messages.
    Any ideas?

  • #2
    i deleted this line from the file

    Code:
        $query[] = "ALTER TABLE " . TABLE_PREFIX . "post CHANGE username username VARCHAR (100) NOT NULL";
        $explain[] = sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1);
    then the upgrading went on. Will I have any problems without that line?

    Comment


    • #3
      it stucked again at upgrade_350rc3.php?step=3

      I deleted this line:

      Code:
      // Post Alter
      if ($vbulletin->GPC['step'] == 3)
      {
          $query[]['hideerror'] = "ALTER TABLE " . TABLE_PREFIX . "post DROP INDEX iconid";
          $explain[] = sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1);
      
          exec_queries();
      }

      and now it works...

      Comment


      • #4
        I would like to know too, if these changes have any bad side-effects?

        Comment


        • #5
          bump

          Comment


          • #6
            They definitely have bad side effects, those queries must be run, and successfully in order to upgrade 100% - vBulletin will probably not function correctly otherwise we would not run those queries during upgrade. If you skip them you can run them manually from the shell.

            Comment


            • #7
              if I run the script from the shell how should I change this code to let it work in MySQL?

              Code:
              // Post Alter
              if ($vbulletin->GPC['step'] == 3)
              {
                  $query[]['hideerror'] = "ALTER TABLE " . TABLE_PREFIX . "post DROP INDEX iconid";
                  $explain[] = sprintf($upgrade_phrases['upgrade_300b3.php']['altering_x_table'], 'post', 1, 1);
              
                  exec_queries();
              }
              Last edited by diretur; Wed 12 Oct '05, 6:00am.

              Comment


              • #8
                I mean, I need following parameters:
                "alter table" . TABLE_PREFIX . "post drop index iconid"

                thanks

                Comment


                • #9
                  The table prefix is set in the config.php file, if you haven't set one you can remove it:

                  ALTER TABLE post DROP INDEX iconid

                  with a prefix like vb3_

                  ALTER TABLE vb3_post DROP INDEX iconid


                  make backups before you do anything of course.
                  And don't forget to remove the query from the script so it won't attempt to run it twice.

                  Comment


                  • #10
                    thank you very much, everything worked fine

                    Comment

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