Several errors in database while upgrading

[robertorg]

Hi,

I'm haveing several problems upgrading my vbulletin board, I get several errors while ALTERing tables like that:

Database error in vBulletin 3.0.10:

Invalid SQL:
ALTER TABLE post_parsed ADD styleid_code INT NOT NULL DEFAULT '-1';

MySQL Error : Duplicate column name 'styleid_code'
Error Number : 1060
Date : Monday, November 21st 2005 @ 12:14:41 PM
Script : http://beta.xxx.com/foro/install/upg...0b1.php?step=2
Referrer : http://beta.xxx.com/foro/install/upg...0b1.php?step=2
IP Address : 192.168.3.3
Username :
Classname : vb_database

I'm getting lucky, because I have to have opened a MySQLcc trying to repare the errors, What can I do? (My forum is stopped and that shouldn't happened for a long time, please is urgent)

[George L]

did you refresh the page/step in your browser as that is saying the column styleid_code already exists

[robertorg]

Yes, I refresh and I tried to make correct the errors that it's giveing to me, manually and when I pass one error, other success, I'm getting all the morning to to something that it's easy, I have just tried editing the first line of the upgrade_350b1.php for skip errors, but MySQL database give me errors and the process stopped:

The change I done is:

error_reporting(E_ALL & ~E_NOTICE);

change for

error_reporting(0);

But nothing success.

[robertorg]

I skip the step in URL and all is fine, but now, I had a mod_rewrite modification installed in my old style, and now any URL works. How can I restore a default style ?

Thanks !!

[George L]

I skip the step in URL and all is fine, but now, I had a mod_rewrite modification installed in my old style, and now any URL works. How can I restore a default style ?

Thanks !!

just revert your templates which were modded... or easy was is disable the style from being selected by unchecking the check box in style manager