[Suite] upgrade failure during upgrade to 4.1.0 PL2

[dhagerty]

I got this error during the XML updates. This has completely taken my site down.

AND DO NOT ASK ME TO DISABLE ANYTHING IN ADMIN CONTROL PANEL! I do not have a control panel!

Database error in vBulletin 4.1.0

Invalid SQL: UPDATE template SET styleid = -10 WHERE styleid = -1 AND (product = 'vbulletin' OR product = '');
MySQL Error : Duplicate entry 'page--10-template' for key 'title'
Error Number : 1062
Request Date : Monday, December 13th 2010 @ 04:41:44 AM
Error Date : Monday, December 13th 2010 @ 04:41:46 AM
Script : http://www.xxxxxxxxxx.com/forum/install/upgrade.php
Referrer : http://www.xxxxxxxxxxx.com/forum/install/upgrade.php
Classname : vB_Database
MySQL Version : 5.1.51

This aborts the final upgrade every time!

I NEED HELP

[Trevor Hannant]

Try running this in phpMyAdmin (make sure you backup your database first!):

DELETE FROM template WHERE styleid = -10

[dhagerty]

thanks.

that took care of the problem!