No announcement yet.

upgrade from vb4 to 5 - Users can't be found and a MySQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • upgrade from vb4 to 5 - Users can't be found and a MySQL error

    I have 2 major issues that I am currently encountering:
    1) Users can log in but when they click on UserCP or Profiles of users prior to the upgrade, they get the following message:
    " A System Error has occured.

    The software is experiencing a systems error.

    You should attempt to repeat your last action. If this error occurs again, please contact the site administrator."

    When I go to the Users > Search Users > Show All users in the Admin CP they show up, but when I click on "View/Edit User" I get the following:
    An unexpected error was returned: 'Can't find class vB_Api_Profile'

    I tried General Update Tools and Fix Broken User Profiles, and repairing my database and still have the same issue. This is also causing my Tapatalk to not work, showing my forums as "blank" because my tapatalk manager isn't my "admin" account.

    2) I got a MySQL error email, not sure if it's related:
    Database error in vBulletin 5.5.4:

    Invalid SQL:

    SELECT languageid,
    phrasegroup_global AS phrasegroup_global,
    phrasegroup_activitystream AS phrasegroup_activitystream,
    phrasegroup_holiday AS phrasegroup_holiday,
    phrasegroupinfo AS lang_phrasegroupinfo,
    options AS lang_options,
    languagecode AS lang_code,
    charset AS lang_charset,
    locale AS lang_locale,
    imagesoverride AS lang_imagesoverride,
    dateoverride AS lang_dateoverride,
    timeoverride AS lang_timeoverride,
    registereddateoverride AS lang_registereddateoverride,
    calformat1override AS lang_calformat1override,
    calformat2override AS lang_calformat2override,
    logdateoverride AS lang_logdateoverride,
    decimalsep AS lang_decimalsep,
    thousandsep AS lang_thousandsep
    FROM language
    WHERE languageid = 1;

    MySQL Error : Unknown column 'imagesoverride' in 'field list'
    Error Number : 1054
    Request Date : Thursday, October 31st 2019 @ 05:49:06 PM
    Error Date : Thursday, October 31st 2019 @ 05:49:06 PM
    Script : http://www./forums-vb4-old/
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version :
    Server :
    User Agent :

    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 505
    #2 vB_Database->query_first() called in [path]/includes/class_core.php on line 536
    #3 vB_Database->query_first_slave() called in [path]/includes/class_core.php on line 4075
    #4 vB_Session->fetch_userinfo() called in [path]/includes/init.php on line 660
    #5 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
    #6 vB_Bootstrap->init() called in [path]/includes/class_bootstrap.php on line 72
    #7 vB_Bootstrap->bootstrap() called in [path]/global.php on line 26
    #8 require_once([path]/global.php) called in [path]/forum.php on line 67
    #9 require([path]/forum.php) called in [path]/index.php on line 43

  • #2
    Actually, I may have resolved these issues with another upgrade to vb5.5.5.


    • #3
      The imagesoverride field was removed in 5.5.2. vBulletin 5.5.X simply doesn't use images for buttons.

      When did the error occur?

      Need to check and make sure a query wasn't overlooked somewhere.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API


      Related Topics