upgrade from 4.1.10 to 4.2.2 return DB error
 

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

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).

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