Announcement

Collapse
No announcement yet.

Error message after running Remove Orphan Stylevars function after upgrade

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

  • Error message after running Remove Orphan Stylevars function after upgrade

    Just finished upgrading my live site. I ran the Remove Orphan Stylevars function after upgrade and got this error message.

    Anybody know what it means and does this error message tell me that the script ran successfully or not?


    Database error in vBulletin 5.5.2:

    Invalid SQL:
    UPDATE vbstylevardfn SET `styleid`=-10
    WHERE (`product` NOT IN ('vbulletin','forumrunner','nativo','viglink','googlelogin','twitterlogin'))
    /**stylevardfn**/;

    MySQL Error : Duplicate entry 'vbblog_bloglist_avatar_width--10' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Wednesday, May 29th 2019 @ 01:22:32 PM
    Error Date : Wednesday, May 29th 2019 @ 01:22:32 PM
    Script : https://mysite.com/admincp/misc.php?do=removeorphanstylevars
    Referrer : https://mysite.com/admincp/misc.php?do=chooser&
    IP Address : Mysitesipaddress
    Username : Myname
    Classname : vB_Database_MySQLi
    MySQL Version : 10.1.38-MariaDB-cll-lve


    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557
    #3 vB_Database->query_write() called in [path]/vb/db/query/update.php on line 116
    #4 vB_dB_Query_Update->doUpdates() called in [path]/vb/db/query/update.php on line 101
    #5 vB_dB_Query_Update->execSQL() called in [path]/vb/db/assertor.php on line 301
    #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 538
    #7 vB_dB_Assertor->update() called in [path]/vb/library/style.php on line 333
    #8 vB_Library_Style->deleteOrphanStylevars() called in [path]/admincp/misc.php on line 1575
    #9 require_once([path]/admincp/misc.php) called in /home/mysite.com/public_html/includes/api/interface/collapsed.php on line 142
    #10 Api_Interface_Collapsed->relay() called in /home/mysite.com/public_html/includes/vb5/frontend/controller/relay.php on line 33
    #11 vB5_Frontend_Controller_Relay->admincp() called in /home/mysite.com/public_html/index.php on line 74

  • #2
    It tells you that you have two entries in the database for the vbblog_bloglist_avatar_width on the master style -10.

    Uninstall your unusable vBulletin 4 styles and try again. Otherwise, you'll need to manually delete those entries. vBulletin 5 does not use vbblog style variables.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      It tells you that you have two entries in the database for the vbblog_bloglist_avatar_width on the master style -10.

      Uninstall your unusable vBulletin 4 styles and try again. Otherwise, you'll need to manually delete those entries. vBulletin 5 does not use vbblog style variables.
      So presumably the error message means that the script did run successfully then.

      Comment


      • #4
        Fatal Errors rarely mean the script finishes properly.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        I am not currently available for vB Messenger Chats.

        Comment

        Related Topics

        Collapse

        Working...
        X