Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Awaiting Feedback Missing table during upgrade

Discussion in 'AMS Bug Reports' started by KatherineA, Feb 27, 2019.

  1. KatherineA

    KatherineA New Member AMS Premium

    XenForo Version String: XenForo 2.1.0
    Addon Version String: AMS 1.6.0 -> 2.1.1
    Stack Trace:
    XF\Db\Exception: MySQL statement prepare error [1146]: Table 'shannondale_shannond_sdalexf.xf_xa_ams_category' doesn't exist in src/XF/Db/AbstractStatement.php at line 217
    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
    XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
    XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/AMS/Permission/CategoryPermissions.php at line 34
    XenAddons\AMS\Permission\CategoryPermissions->getContentTree() in src/XF/Permission/TreeContentPermissions.php at line 23
    XF\Permission\TreeContentPermissions->setupBuildTypeData() in src/XF/Permission/AbstractContentPermissions.php at line 48
    XF\Permission\AbstractContentPermissions->setupBuildData() in src/XF/Permission/AbstractContentPermissions.php at line 21
    XF\Permission\AbstractContentPermissions->__construct() in src/XF/Permission/Builder.php at line 114
    XF\Permission\Builder->getContentHandler() in src/XF/Permission/Builder.php at line 83
    XF\Permission\Builder->getContentHandlers() in src/XF/Permission/Builder.php at line 146
    XF\Permission\Builder->rebuildCombinationContent() in src/XF/Permission/Builder.php at line 140
    XF\Permission\Builder->rebuildCombination() in src/XF/Job/PermissionRebuild.php at line 58
    XF\Job\PermissionRebuild->run() in src/XF/Job/Manager.php at line 253
    XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 195
    XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 111
    XF\Job\Manager->runByIds() in src/XF/Admin/Controller/Tools.php at line 120
    XF\Admin\Controller\Tools->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 321
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    XF\App->run() in src/XF.php at line 390
    XF::runApp() in admin.php at line 13
    Can you reproduce it here? No, during upgrade only

    The addon was working as expected on XF1 but I get this error on XF 2.
  2. Bob

    Bob Developer Staff Member

    When exactly did this error get thrown? Was this thrown while attempting to upgrade AMS?

    The first step of the upgrade from AMS 1.x to AMS 2.x is renaming tables (the old category table name is 'xa_nflj_ams_category' where as the new category table name is 'xf_xa_ams_category') so step 1 of the AMS 2.0.0 alpha 1 hasn't even been run yet (since the tables have not yet been renamed).

    Its almost as if you had uploaded the AMS 2.x files BEFORE upgrading XF itself to XF2 (which could really screw things up) or that you've uploaded the AMS 2.x files and not yet run the AMS upgrade yet. Just saying, that is how its ACTING, which is why I need some clarification on what steps were taken (and the order).

    Can you post me a screen shot of the status of AMS on the Addon Listing in the Admin CP?
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.