upgrade from 4.1.10 to 4.2.2 return DB error

[itayKinnrot]

hi,

im in the middle of vbulletin upgrade from 3.8.7 to 4.2.2 and in the middle of upgrade when it get to version 4.1.10 it return DB error:

Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>

Invalid SQL:

INSERT INTO style
(title, parentid, userselect, displayorder, type)
VALUES
('Default Mobile Style',
-2, 1, 1, 'mobile');

Duplicate entry '0' for key 1]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.1.10</p>
<p>Invalid SQL:

INSERT INTO style
(title, parentid, userselect, displayorder, type)
VALUES
('Default Mobile Style',
-2, 1, 1, 'mobile');<p>
<p>
<strong>MySQL Error</strong> : Duplicate entry '0' for key 1<br />
<strong>Error Number</strong> : 1062<br />
<strong>Request Date</strong> : Saturday, August 16th 2014 @ 12:07:36 AM<br />
<strong>Error Date</strong> : Saturday, August 16th 2014 @ 12:07:37 AM<br />
<strong>Script</strong> : http://www.iphones.co.il/vbdev1/forum/install/upgrade.php<br />
<strong>Referrer</strong> : http://www.iphones.co.il/vbdev1/forum/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.0.91-community<br />
</p>]]></error_html>
</errors>

please assist.

thanks,
Dooby

[Paul M]

Have you ever installed the vB3 MAPI (for mobile) plugin ?

That had a bug at one point that broke the style table in such a way that it would cause the above;

If you run the SQL below, it should fix it.
Before you do, back-up your styles, as you may lose one of them (the last one you created).

DELETE FROM style WHERE styleid = 0;
ALTER TABLE style CHANGE styleid styleid SMALLINT NOT NULL AUTO_INCREMENT;

(Note, if you use a table prefix, you will need to change the table name above to match).