Upgrade error - 360b1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lowcarbscoop
    New Member
    • Mar 2005
    • 5
    • 3.0.7

    Upgrade error - 360b1

    I was running the scripts to upgrade all the way from 3.0.8 and made it all the way to this point and received an error. Board is now down. Help please. I dropped the table and rebuilt it, and it is ok, until I re-run that step, then PHPMYADMIN says it need repaired again.

    Database error in vBulletin 3.5.5:

    Invalid SQL:
    ALTER TABLE attachmenttype CHANGE extension extension VARCHAR(20) BINARY NOT NULL DEFAULT '';

    MySQL Error : Incorrect key file for table 'attachmenttype'; try to repair it
    Error Number : 1034
    Date : Monday, January 7th 2008 @ 03:08:25 AM
    Script : http://www.domain removed.com/lcsbb/install/upgrade_360b1.php?step=10
    Referrer : http://www.domain removed.com/lcsbb/install/upgrade_360b1.php?step=9
    IP Address : 76.121.126.170
    Username :
    Classname : vB_Database
    Last edited by lowcarbscoop; Mon 7 Jan '08, 12:31am. Reason: aadditional info
  • etterra
    New Member
    • May 2005
    • 22

    #2
    I just run into the exact same error while upgrading from 3.5.4 to 3.6.8

    Comment

    • lowcarbscoop
      New Member
      • Mar 2005
      • 5
      • 3.0.7

      #3
      I hope we can both get this fixed!

      Comment

      • etterra
        New Member
        • May 2005
        • 22

        #4
        yes... I'm trying to get it solved... but somehow this problem has never occured before.

        Comment

        • etterra
          New Member
          • May 2005
          • 22

          #5
          I have solved it.

          1. Go to phpMyAdmin

          2. Delete table: attachementtype (Dorp table)

          3. Then recreate it with the following sql :
          Code:
          CREATE TABLE attachmenttype (
           extension CHAR(20) NOT NULL DEFAULT '',
           mimetype VARCHAR(255) NOT NULL DEFAULT '',
           size INT UNSIGNED NOT NULL DEFAULT '0',
           width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
           height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
           enabled SMALLINT UNSIGNED NOT NULL DEFAULT '1',
           display SMALLINT UNSIGNED NOT NULL DEFAULT '0',
           thumbnail SMALLINT UNSIGNED NOT NULL DEFAULT '0',
           newwindow SMALLINT UNSIGNED NOT NULL DEFAULT '0',
           PRIMARY KEY (extension)
          )
          4. Insert blank values:
          Code:
          INSERT INTO attachmenttype (extension, mimetype, size, width, height, enabled, display) VALUES
          ('gif', '', '20000', '620', '280', '1', '0'),
          ('jpeg', '', '20000', '620', '280', '1', '0'),
          ('jpg', '', '100000', '0', '0', '1', '0'),
          ('jpe', '', '20000', '620', '280', '1', '0'),
          ('txt', '', '20000', '0', '0', '1', '2'),
          ('png', '', '20000', '620', '280', '1', '0'),
          ('doc', '', '20000', '0', '0', '1', '0'),
          ('pdf', '', '20000', '0', '0', '1', '0'),
          ('bmp', '', '20000', '620', '280', '1', '0'),
          ('psd', '', '20000', '0', '0', '1', '0'),
          ('zip', '', '100000', '0', '0', '1', '0')
          5. Rerun step 10

          Now it should work.. but you have to reenter the values after the installation.

          Comment

          • lowcarbscoop
            New Member
            • Mar 2005
            • 5
            • 3.0.7

            #6
            Very nice - I've been searching forever to find something like that. Looks like it worked. I can just reinsert all my original values into the table afterwards?

            THANKS

            Comment

            Related Topics

            Collapse

            Working...