Announcement

Collapse
No announcement yet.

Site hosed during upgrade

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

  • Site hosed during upgrade

    I was upgrading an old board from v2.3.x to 3.6.x per direction from this site. During the upgrade it found a table in the database that was not standard (faq) and it error'd out.

    I deleted this table and now when I run it of course it's crashing on it's own newly created table from the first upgrade run.

    Database error in vBulletin :

    Invalid SQL:

    CREATE TABLE calendar (
    calendarid int unsigned NOT NULL auto_increment,
    title varchar(255) NOT NULL DEFAULT '',
    description varchar(100) NOT NULL DEFAULT '',
    displayorder smallint NOT NULL DEFAULT '0',
    neweventemail varchar(255) NOT NULL DEFAULT '',
    moderatenew smallint NOT NULL DEFAULT '0',
    startofweek smallint NOT NULL DEFAULT '0',
    options int unsigned NOT NULL DEFAULT '0',
    cutoff smallint unsigned NOT NULL DEFAULT '0',
    eventcount smallint unsigned NOT NULL DEFAULT '0',
    birthdaycount smallint unsigned NOT NULL DEFAULT '0',
    startyear smallint unsigned NOT NULL DEFAULT '2000',
    endyear smallint unsigned NOT NULL DEFAULT '2006',
    PRIMARY KEY (calendarid),
    KEY displayorder (displayorder)
    );

    MySQL Error : Table 'calendar' already exists
    Error Number : 1050
    Date : Saturday, July 18th 2009 @ 02:42:51 PM
    Script : http://www.domain.com/forums/install/upgrade_300b3.php?step=1
    Referrer : http://www.domain.com/forums/install/upgrade_300b3.php
    IP Address : xx.xxx.xx.xxx
    Username :
    Classname : vb_database
    So how do I get it to keep going now???

    Also, isn't there a database compatibility tool to check your database prior to upgrade if it's compatible? I seem to remember such a tool but I can't find it.

    Please help, site is live and broken.

  • #2
    You need to restore the backup of the database you made prior to this upgrade attempt then try again.
    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
      That's what I did which is how I destroyed my avatars that you were trying to help me with earlier.

      Comment


      • #4
        I'm sorry that happened but the bad backup and restore was not my fault. FWIW that is caused by an incompatibility between versions of MySQL from when the backup was made and when it was restored. In most cases this doesn't occur because the server and versions are the same in both cases.
        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


        • #5
          I need to clarify. I do not blame or hold Steve Machol responsible for this db corruption at all. I was simply pointing out that the backup/restore suggestion is the method that led to the problem I am now facing.

          Comment

          Related Topics

          Collapse

          Working...
          X