Database error in vBulletin 3.5.4:

[General_General]

Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE post_parsed RENAME postparsed;
MySQL Error : Table 'postparsed' already exists
Error Number : 1050
Date : Thursday, July 6th 2006 @ 01:29:00 PM
Script : http://www.xxx.com/forum2/install/upgrade_360b1.php?step=7 (http://www.xxx.com/forum2/install/upgrade_360b1.php?step=7)
Referrer : http://www.xxxx.com/forum2/install/upgrade_360b1.php?step=6 (http://www.xxxx.com/forum2/install/upgrade_360b1.php?step=6)
IP Address : x1.2x4.51.1x9
Username :
Classname : vb_database


What Can I DO?....

[General_General]

Step 7) Signature Permissions

EROR!!!!

Creating sigpic table
Altering usergroup Table (1 of 9)
Altering usergroup Table (2 of 9)
Altering usergroup Table (3 of 9)
Altering usergroup Table (4 of 9)
Altering usergroup Table (5 of 9)
Altering usergroup Table (6 of 9)
Altering usergroup Table (7 of 9)
Altering usergroup Table (8 of 9)
Altering usergroup Table (9 of 9)
Altering user Table (1 of 1)
Creating sigparsed table
Altering setting Table (1 of 1)
Renaming post_parsed table to postparsed EROR!!! data baste EROR!

[Colin F]

Try reloading the page.

[General_General]

Try reloading the page.

an other way?...

[Derekclarke03]

I have the exact same issue.

I have gone through and discovered that some of the files in the includes and install folder were not their.

Re upload all files from both folders and replace all current files.

all Worked perfect after this.

Derek

[General_General]

oke... thank you... ı have no promlem with this...

[spinzone]

i have the same problem too

upgrading from 3.5.4 to 3.6

Step 7) Signature Permissions

Creating sigpic table
Altering usergroup Table (1 of 9)
Altering usergroup Table (2 of 9)
Altering usergroup Table (3 of 9)
Altering usergroup Table (4 of 9)
Altering usergroup Table (5 of 9)
Altering usergroup Table (6 of 9)
Altering usergroup Table (7 of 9)
Altering usergroup Table (8 of 9)
Altering usergroup Table (9 of 9)
Altering user Table (1 of 1)
Creating sigparsed table
Altering usergroup Table (1 of 1)
Altering setting Table (1 of 1)
Renaming post_parsed table to postparsed http://www.****.net/forums/image.php?type=dberrorDatabase errorThe ***** Forums database has encountered a problem.Please try the following:

Load the page again by clicking the Rfresh button in your web browser.
Open the www.********.net (http://www.********.net) home page, then try to open another page.
Click the Back button to try another link.The www.******.net (http://www.******.net) forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE post_parsed RENAME postparsed;
MySQL Error : Table 'postparsed' already exists
Error Number : 1050
Date : Saturday, July 15th 2006 @ 08:29:38 AM
Script : http://www.******************step=7 (http://www.******************step=7/)
Referrer : http://www.**********/forums/install...0b1.php?step=6 (http://www.**********/forums/install/upgrade_360b1.php?step=6)
IP Address : *************
Username :
Classname : vb_database


any help please or is it ok if i delete the table 'postparsed'
thanks

[Marco van Herwaarden]

You have probably tried the upgrade before and after that restored a backup?

[spinzone]

You have probably tried the upgrade before and after that restored a backup?
yes that is true what i am backing up my current database the restore it on my test site and try to upgrade to see if everything will go smoothly.
as i cannot take a chance on live database.
can you please give me a solution.
thanks

[Marco van Herwaarden]

What happens is that the backup don't delete new tables.

Explanation:
- You start with a forum with the post_parsed table. You make a backup from this database.
- You run the upgrade and post_parsed gets renamed to postparsed. You now only have the postparsed table.
- Now you restore your backup, and the post_parsed from the backup is loaded into your database again.

At this time you have botrh the previously renamed postparsed table and the just restored post_parsed table, and your upgrade will fail.

Solution:
Make sure you have a good full backup. Clear your database, and then restore.

To protect against a corrupt backup it would be best to create a new database to restore your backup into, and after you verify it is complete, switch the config.php to use the new database and delete the old database and run the upgrade on the new restored database.

Alternative would be to rename the postparsed table back to post_parsed before restoring the backup, and rerunning the upgrade.

[spinzone]

upgrading from 3.5.4 to 3.6.0 RC2

looking at my current database i see that i have both tables "post_parsed" and "postparsed" i have removed all the plugins and any extra hacks installed on the forums.
can i remove "postparsed" table and then run the upgrade.
thanks

[Colin F]

Yes, that should work.

[Paul M]

Perhaps the upgrade script should actually check if the change has already been done, as I thought it was designed to be re-runable ?

[hmmmbop]

Would it work to add this:

//attempt to merge already upgraded databases
$upgrade->run_query(
$upgrade_phrases['upgrade_360b1.php']['rename_post_parsed'],
"DROP TABLE IF EXISTS " . TABLE_PREFIX . "postparsed"
);

above this...

// rename the post_parsed table so none of our tables have underscores
$upgrade->run_query(
$upgrade_phrases['upgrade_360b1.php']['rename_post_parsed'],
"ALTER TABLE " . TABLE_PREFIX . "post_parsed RENAME " . TABLE_PREFIX . "postparsed",
MYSQL_ERROR_TABLE_MISSING
);

in upgrade_360b1.php ? Of course the upgrade phrases will display the same line twice, but I couldn't be bothered to change another line somewhere else;)

Sorry for bumping an old thread - it just so happens that I encountered this problem today when restoring a backup.