Bug Unknown column

[Bijou]

Hello there. I'm very excited to use this addon, it looksk amazing. However on install I have been unable to make a new currency or edit the original. Instead I get errors.

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'user.vouchers_vouchers' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace #0 /var/www/html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT user...')
#1 /var/www/html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT user...')
#2 /var/www/html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT user...')
#3 /var/www/html/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT user...', true)
#4 /var/www/html/library/XenForo/Model/User.php(446): Zend_Db_Adapter_Abstract->fetchRow('\n\t\t\tSELECT user...', true)
#5 /var/www/html/src/addons/DBTech/Credits/Application/Core.php(536): XenForo_Model_User->getUserById(true)
#6 /var/www/html/src/addons/DBTech/Credits/Application/Entity.php(1724): DBTech\Credits\Application\Core->getUserById(true)
#7 /var/www/html/src/addons/DBTech/Credits/Application/Entity.php(1664): DBTech\Credits\Application\Entity->verifyUserId(true, 'userid', Array)
#8 /var/www/html/src/addons/DBTech/Credits/Application/Entity.php(1290): DBTech\Credits\Application\Entity->_verifyFieldValue(true, Array, 'userid')
#9 /var/www/html/src/addons/DBTech/Credits/Application/Entity.php(418): DBTech\Credits\Application\Entity->_isFieldValueValid(true, 'userid', 65541, Array)
#10 /var/www/html/src/addons/DBTech/Credits/Application/Entity.php(326): DBTech\Credits\Application\Entity->set('userid', '1', Array)
#11 /var/www/html/src/addons/DBTech/Credits/ActionAdmin/Currency.php(231): DBTech\Credits\Application\Entity->bulkSet(Array)
#12 /var/www/html/src/addons/DBTech/Credits/Application/Core.php(173): DBTech\Credits\ActionAdmin\Currency->actionUpdate()
#13 /var/www/html/library/DBTech/Credits/XenForo/ControllerAdmin/Credits.php(25): DBTech\Credits\Application\Core->runAction('currency')
#14 /var/www/html/library/XenForo/FrontController.php(351): DBTech_Credits_XenForo_ControllerAdmin_Credits->actionIndex()
#15 /var/www/html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /var/www/html/admin.php(13): XenForo_FrontController->run()
#17 {main}
Request State array(3) {
["url"] => string(62) "https://starlightacademy.net/admin.php?dbtech-credits/currency"
["_GET"] => array(3) {
["dbtech-credits/currency"] => string(0) ""
["do"] => string(8) "currency"
["id"] => int(0)
}
["_POST"] => array(9) {
["currency"] => array(21) {
["title"] => string(8) "Vouchers"
["description"] => string(40) "Classic DragonByte Credits points field."
["active"] => string(1) "1"
["displayorder"] => string(2) "10"
["table"] => string(4) "user"
["column"] => string(17) "vouchers_vouchers"
["decimals"] => string(1) "0"
["negative"] => string(1) "2"
["privacy"] => string(1) "2"
["prefix"] => string(0) ""
["suffix"] => string(0) ""
["displaycurrency"] => string(1) "0"
["sidebar"] => string(1) "0"
["useprefix"] => string(1) "1"
["userid"] => string(1) "1"
["usercol"] => string(7) "user_id"
["earnmax"] => string(1) "0"
["maxtime"] => string(1) "0"
["value"] => string(1) "1"
["inbound"] => string(1) "1"
["outbound"] => string(1) "1"
}
["action"] => string(6) "update"
["currencyid"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(61) "/admin.php?dbtech-credits/currency&action=modify&currencyid=1"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
["do"] => string(8) "currency"
["id"] => int(0)
}
}

I have no other addons enabled and it still gives me errors.

Thanks in advance for your help, I look forward to hearing back.

 

[Fillip H.]

ALTER TABLE xf_user ADD vouchers_vouchers DOUBLE NOT NULL DEFAULT '0'

 

[Bijou]

ALTER TABLE xf_user ADD vouchers_vouchers DOUBLE NOT NULL DEFAULT '0'

Thank you so much! However, now it says this when I attempt to make or edit a currency:

The following error occurred:
The requested user could not be found.

and also my site now has this server error and can't load, i had to use a backup file to fix :'(

Server Error
Mysqli prepare error: Unknown column 'user.dbtech_credits_credits' in 'field list'

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
5. Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 446
6. XenForo_Model_User->getUserById() in XenForo/Model/User.php at line 959
7. XenForo_Model_User->getVisitingUserById() in XenForo/Visitor.php at line 415
8. XenForo_Visitor::setup() in XenForo/Session.php at line 420
9. XenForo_Session::startAdminSession() in XenForo/ControllerAdmin/Abstract.php at line 48
10. XenForo_ControllerAdmin_Abstract->_setupSession() in XenForo/Controller.php at line 306
11. XenForo_Controller->preDispatch() in XenForo/FrontController.php at line 350
12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
13. XenForo_FrontController->run() in /var/www/html/admin.php at line 13

 

[Fillip H.]

Try this also: ALTER TABLE xf_user ADD dbtech_credits_credits DOUBLE NOT NULL DEFAULT '0'

 

[Bijou]

Try this also: ALTER TABLE xf_user ADD dbtech_credits_credits DOUBLE NOT NULL DEFAULT '0'

Thank you for taking the time to reply I am still getting the same error unfortunately.

 

[Fillip H.]

In that case I will need you to PM me with an FTP and AdminCP account in order to look into this further.

 

[Bijou]

Just as an update, I did a completely fresh install of Xenforo and am having the same issue.

 

[Fillip H.]

I've resolved the issue, for some reason your OS is case insensitive so the wrong verification function was being ran when saving currencies.

It appears to work fine now, let me know if there's any further issues

 

[Bijou]

I've resolved the issue, for some reason your OS is case insensitive so the wrong verification function was being ran when saving currencies.

It appears to work fine now, let me know if there's any further issues

Thank you so much for your help!

 

[DragonByte Technologies]

Hello @Bijou,

We hope your ticket regarding DragonByte Credits has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.