Please help!mysql error number: 1060

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • emuchina
    New Member
    • Apr 2003
    • 12
    • 3.0.0 'Gold'

    Please help!mysql error number: 1060

    When I upgrade vbb 3.00 to 3.06,in step 2,we got a CGI timeout error,after I refresh that page,I got this error:

    Step 2) Miscellaneous table alterations 2/4

    Adding thumbnail size field to attachment table


    There seems to have been a slight problem with the RomShare Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Database error in vBulletin 3.0.1:

    Invalid SQL: ALTER TABLE attachment ADD thumbnail_filesize INT UNSIGNED NOT NULL
    mysql error: Duplicate column name 'thumbnail_filesize'

    mysql error number: 1060

    Date: Saturday 05th of February 2005 10:17:10 PM
    Script: http://www.xxxx.net/install/upgrade13.php?step=2
    Referer:
    Username: webmaster
    IP Address: xxxxxxx

    Please help!
  • emuchina
    New Member
    • Apr 2003
    • 12
    • 3.0.0 'Gold'

    #2
    The table "thumbnail filesize " already created,can I modifly the upgrade13.php , and delete this step,and continue?
    Thanks

    // Add thumbnail filesize so we know what it is when thumbnails are in the FS
    $query[] = "ALTER TABLE " . TABLE_PREFIX . "attachment ADD thumbnail_filesize INT UNSIGNED NOT NULL";
    $explain[] = $upgrade_phrases['upgrade13.php']['add_thumbnail_filesize'];

    Comment

    • Deaths
      Member
      • Jan 2005
      • 60
      • 3.0.7

      #3
      You can also just delete the tables/fields which have been created in your PHPMYADMIN

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎