Bug Issue with adjusting any credits both in Credits and Shop system

Status
Not open for further replies.

scarecr0w12

Customer
Issue occurs in the admin side of things. when i try to make any adjustments to credits both in the Credits plugin and the integrated shop plugin, i get the following error:

Code:
Error Info
Mysqli prepare error: Unknown column 'display' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace
#0 /home/empire/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO xf_...')
#1 /home/empire/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO xf_...')
#2 /home/empire/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO xf_...')
#3 /home/empire/public_html/src/addons/DBTech/Credits/Application/Db.php(780): Zend_Db_Adapter_Abstract->query('INSERT INTO xf_...')
#4 /home/empire/public_html/src/addons/DBTech/Credits/Application/Db.php(403): DBTech\Credits\Application\Db->query('INSERT INTO xf_...', Array, 'query_write')
#5 /home/empire/public_html/src/addons/DBTech/Credits/Application/Entity.php(1009): DBTech\Credits\Application\Db->insert('dbtech_credits_...', Array, Array)
#6 /home/empire/public_html/src/addons/DBTech/Credits/Application/Entity.php(939): DBTech\Credits\Application\Entity->_save()
#7 /home/empire/public_html/src/addons/DBTech/Credits/Entity/Currency.php(250): DBTech\Credits\Application\Entity->save()
#8 /home/empire/public_html/src/addons/DBTech/Credits/ActionAdmin/Users.php(62): DBTech\Credits\Entity\Currency->verifyAdjustEvent()
#9 /home/empire/public_html/src/addons/DBTech/Credits/Application/Core.php(173): DBTech\Credits\ActionAdmin\Users->actionIndex()
#10 /home/empire/public_html/library/DBTech/Credits/XenForo/ControllerAdmin/Credits.php(25): DBTech\Credits\Application\Core->runAction('DBTech\\Credits\\...')
#11 /home/empire/public_html/library/XenForo/FrontController.php(369): DBTech_Credits_XenForo_ControllerAdmin_Credits->actionIndex()
#12 /home/empire/public_html/library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/empire/public_html/admin.php(13): XenForo_FrontController->run()
#14 {main}

Request State
Array
(
    [url] => https://www.theegn.com/admin.php?dbtech-credits/users
    [_GET] => Array
        (
            [dbtech-credits/users] => 
            [do] => users
            [id] => 0
        )

    [_POST] => Array
        (
            [do] => users
            [id] => 0
        )

)
 
I just installed this yesterday, You had actually helped me out with this when i was getting it on my test site. We've moved it to the main site now, but when i got to save things, i get the error.

I tried to do a reinstall, but no luck
 
I can't understand how that is, but in either case, you can resolve it by running these queries:

Code:
			ALTER TABLE `xf_dbtech_credits_event`
				ADD `title` VARCHAR(255) NOT NULL DEFAULT ''
				AFTER `eventid`

Code:
			ALTER TABLE `xf_dbtech_credits_event`
				ADD `display` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1'
				AFTER `alert`
 
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!
 
Status
Not open for further replies.

DragonByte Credits

XenForo 1.5.3+ XenForo 2.0.x XenForo 2.1.x XenForo 2.2.x XenForo 2.3.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
4,885
Customer rating
5.00 star(s) 5 ratings
Back
Top