PDA

View Full Version : vB 3.5.5 to 3.6.1 Error


Fury Three
Fri 29th Sep '06, 4:11am
I received the following error at 3.6.0b1, step 7:

"Database error in vBulletin 3.5.5:

Invalid SQL:
ALTER TABLE post_parsed RENAME postparsed;

MySQL Error : Table 'postparsed' already exists
Error Number : 1050"

No option to proceed past this step. How can I fix this?

Boxy
Fri 29th Sep '06, 6:52am
It would suggest that part or all of step 7 has already been run. I would recommend rerunning step 7 without the postparse alter query.

Edit the install/upgrade_360b1.php file and find:

// 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
);


remove or comment this block of code, save the file and rerun step 7.

Fury Three
Fri 29th Sep '06, 11:55am
Problem solved! Thank you very much.