Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.



    Attached Files
    Last edited by m0rgulvale; Mon 16th Feb '15, 6:34am.

  • #2
    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?

    Comment


    • #3
      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
      Vote for:

      - *Admin Settable Paid Subscription Reminder Timeframe*
      -
      *PM - Add ability to reply to originator only*
      - Add Admin ability to auto-subscribe users to specific channel(s)
      - Highlight the correct navigation tab when you are on a custom page
      - "Quick Route" Interface...
      - Allow to use custom icons for individual forums

      Comment


      • #4
        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
        Last edited by m0rgulvale; Tue 17th Feb '15, 7:33am.

        Comment


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

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools <- awesome site for html/css help

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X