Vbulletin 3.8.7 pl5 - cannot delete style. Error = Could not find style with styleid = 0.

[m0rgulvale]

Hi, I have 4 styles installed (see attached)

When I attempt to delete vb3 mobile skin I get the error:

Could not find style with styleid = 0.


Here is the description of my "style" table:

mysql> describe style;
+---------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+----------------------+------+-----+---------+-------+
| styleid | smallint(5) unsigned | NO | PRI | 0 | |
| title | varchar(250) | NO | | | |
| parentid | smallint(6) | NO | | 0 | |
| parentlist | varchar(250) | NO | | | |
| templatelist | mediumtext | YES | | NULL | |
| csscolors | mediumtext | YES | | NULL | |
| css | mediumtext | YES | | NULL | |
| stylevars | mediumtext | YES | | NULL | |
| replacements | mediumtext | YES | | NULL | |
| editorstyles | mediumtext | YES | | NULL | |
| userselect | smallint(5) unsigned | NO | | 1 | |
| displayorder | smallint(5) unsigned | NO | | 0 | |
| importstyleid | bigint(20) | NO | | 0 | |
+---------------+----------------------+------+-----+---------+-------+
13 rows in set (0.00 sec)



Some data from style table:


mysql> select styleid, title,parentlist from style;
+---------+------------------------+------------+
| styleid | title | parentlist |
+---------+------------------------+------------+
| 1 | Default Style | 1,-1 |
| 5 | Skilltest - No Sidebar | 5,-1 |
| 13 | DarkShadows V5 | 13,-1 |
| 0 | vB3 Mobile Skin | 0,-1 |
+---------+------------------------+------------+
4 rows in set (0.00 sec)



Any idea how to fix this issue? Should styleid be set to auto_increment?

Thanks a ton.

[m0rgulvale]

on a backup i tested running ALTER TABLE `style` CHANGE `styleid` `styleid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; allows me to successfully delete the skin which had styleid=0


after that things appear to work. however, i'm wondering if any other tables also need updating / changes

should anything else be done or is the above all that was needed?

[Trevor Hannant]

Re-run the upgrade script so that the Master Style templates are re-imported into the database. Sounds like something went wrong with those at some point as they should be numbered Style ID 0

[m0rgulvale]

Thanks for the reply, Trevor.

Just to verify, you mean only run /install/upgrade.php PHP from Browser? And I don't need to run that alter table query above? Please verify this is correct.

I tried doing the above on a backup, but I still have the same problem. The style table doesn't have AUTO_INCREMENT for styleid. I can't delete the style with styleid=0. Error is the same : Could not find style with styleid = 0.


Any idea what else to try?



Someone else had this problem, and Zachery from vbulletin seemed to think related to bug in Vbulletin mobile API:

http://www.vbulletin.com/forum/forum...style-template

I don't have mobile API anymore, but I used to

Another user with similar issue:

http://www.vbulletin.com/forum/forum...le-table-error


Please advise

Thanks for the help

[Lynne]

The styleid field should be AUTO_INCREMENT. I would change that and then see if you still get the same error.