Bug Error after install of Shop and Credits

[scarecr0w12]

I am installing the plugins on a test server while i rebuild my site, and i get the following error:

An exception occurred: Mysqli prepare error: Table 'empire_xenforo2.xf_xf_user' doesn't exist in /home/empire/test.theegn.com/library/Zend/Db/Statement/Mysqli.php on line 77

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 446
XenForo_Model_User->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Application/Core.php at line 535
DBTech\Shop\Application\Core->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Helper/Purchase.php at line 19
DBTech\Shop\Helper\Purchase::verifyPurchases() in DBTech/Shop/XenForo/Template/Helper/Core.php at line 276
DBTech_Shop_XenForo_Template_Helper_Core::helperRichThreadbit()
call_user_func_array() in XenForo/Template/Helper/Core.php at line 853
XenForo_Template_Helper_Core::callHelper() in /home/empire/test.theegn.com/internal_data/templates/S.1,L.1,EWRwidget_Threads.php at line 174
include() in XenForo/Template/Abstract.php at line 270
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/Template/Abstract.php at line 542
XenForo_Template_Abstract->__toString() in /home/empire/test.theegn.com/internal_data/templates/S.1,L.1,forum_list.php at line 92
include() in XenForo/Template/Abstract.php at line 270
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 662
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 176
XenForo_FrontController->run() in /home/empire/test.theegn.com/index.php at line 13
An exception occurred: Mysqli prepare error: Table 'empire_xenforo2.xf_xf_xf_user' doesn't exist in /home/empire/test.theegn.com/library/Zend/Db/Statement/Mysqli.php on line 77

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 446
XenForo_Model_User->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Application/Core.php at line 535
DBTech\Shop\Application\Core->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Helper/Purchase.php at line 19
DBTech\Shop\Helper\Purchase::verifyPurchases() in DBTech/Shop/XenForo/Template/Helper/Core.php at line 129
DBTech_Shop_XenForo_Template_Helper_Core::helperUserTitle()
call_user_func_array() in XenForo/Template/Helper/Core.php at line 853
XenForo_Template_Helper_Core::callHelper() in /home/empire/test.theegn.com/internal_data/templates/S.1,L.1,EWRwidget_UsersOnline.php at line 26
include() in XenForo/Template/Abstract.php at line 270
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/Template/Abstract.php at line 542
XenForo_Template_Abstract->__toString() in /home/empire/test.theegn.com/internal_data/templates/S.1,L.1,forum_list.php at line 380
include() in XenForo/Template/Abstract.php at line 270
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 124
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 662
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 176
XenForo_FrontController->run() in /home/empire/test.theegn.com/index.php at line 13
An exception occurred: Mysqli prepare error: Table 'empire_xenforo2.xf_xf_xf_xf_user' doesn't exist in /home/empire/test.theegn.com/library/Zend/Db/Statement/Mysqli.php on line 77

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 446
XenForo_Model_User->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Application/Core.php at line 535
DBTech\Shop\Application\Core->getUserById() in /home/empire/test.theegn.com/src/addons/DBTech/Shop/Helper/Purchase.php at line 19
DBTech\Shop\Helper\Purchase::verifyPurchases() in DBTech/Shop/XenForo/Template/Helper/Core.php at line 129
DBTech_Shop_XenForo_Template_Helper_Core::helperUserTitle()
call_user_func_array() in XenForo/Template/Helper/Core.php at line 853
XenForo_Template_Helper_Core::callHelper() in /home/empire/test.theegn.com/internal_data/templates/S.1,L.1,PAGE_CONTAINER.php at line 1479
include() in XenForo/Template/Abstract.php at line 270
XenForo_Template_Abstract->_renderInternal() in XenForo/Template/Abstract.php at line 201
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 140
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 662
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 176
XenForo_FrontController->run() in /home/empire/test.theegn.com/index.php at line 13

I had originally tried installing on my live site, but i got hte same error, so i thought it was the site itself. I am not trying on a blank site, and error still occurs.

 

[Fillip H.]

I don't think this is a bug in our mod, since we call the built in XenForo code for this.

That being said, someone else reported a similar issue so I'd like to investigate. Can you please PM me with an FTP and AdminCP account?

 

[scarecr0w12]

Sure let me set you up onto the testing site that currently has the error. give me a few moments and i'll message over.

 

[scarecr0w12]

Info sent over

 

[scarecr0w12]

I've been doing some playing around, and you may be correct in that its not this plugin specifically, but rather a conflict with another plugin, i just disabled a all but my "Installation and upgrade" addon and the shop + credits addon from you.

Looks to be working correctly in front end now. I'm gonna enable 1 addon at a time see what the conflict is. But i am betting its the Redis cache plugin i have installed.

 

[scarecr0w12]

So i have now reenabled all plugins i had installed, and the error is not coming back. I've done no changes to anything except for disabling and reenabling plugins (Leaving the Shop and Credits plugin enabled the entire time)

 

[scarecr0w12]

After more testing, now this error comes up in any forum when the shop and credits addon are enabled:

Server Error
Mysqli prepare error: Table 'empire_xenforo2.xf_xf_user' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Thread.php at line 563
XenForo_Model_Thread->getThreads() in XenForo/Model/Thread.php at line 659
XenForo_Model_Thread->getStickyThreadsInForum() in XenForo/ControllerPublic/Forum.php at line 235
XenForo_ControllerPublic_Forum->actionForum() in Audentio/UIX/ControllerPublic/Forum.php at line 23
Audentio_UIX_ControllerPublic_Forum->actionForum() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in /home/empire/test.theegn.com/index.php at line 13

 

[scarecr0w12]

And after a little more testing, it looks to be specifically the credits plugin causing the error, no error when its just the shop plugin.

 

[Fillip H.]

I couldn't explain to you why this happened even if you held a gun to my head, but I worked around it regardless. I'll hotfix the XF1 versions of Credits and Shop now.

If you wait about 15-30 minutes then re-download the latest Beta versions, it should be fixed.

 

[scarecr0w12]

Awesome, i was able to stump a developer thanks for the work around, i'll let you know if any other issues occur.

 

[DragonByte Technologies]

Hello scarecr0w12,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!