vb.org Archive - Can't delete style - style table problem? no auto

Hi, when I try deleting a style "vB3 Mobile Skin" I get following error on vbulletin 3.8.7 pl5.

Could not find style with styleid = 0.

I think the problem might involve my style table not having 'styleid' set to auto_increment.. it appears most other vbulletin tables have that.

Code:

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)

Info from style table:

Code:



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)

If needed, I can pay someone for help fixing this via paypal.

Any idea what is wrong and how to fix?

--------------- Added [DATE]1424146913[/DATE] at [TIME]1424146913[/TIME] ---------------

update:

I ran the following query (safely against a test backup):

ALTER TABLE `style` CHANGE `styleid` `styleid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;

After that I am able to delete vb3 mobile skin which previously had the styleid=0

Everything appears to work after that . no database errors or anything

Is this a complete fix or do I also need to modify other tables?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00992 seconds Memory Usage 1,711KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: