Question How to fix this?

[Charizard]

We moved from BD Bank to DB Credits. BD Bank has been uninstalled but we kept the table to use with DB Credits.

Getting this error when trying to merge a thread:

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'bdbank_money' at row 1 src/XF/Db/AbstractStatement.php:228

Stack trace
                    UPDATE xf_user
SET bdbank_money = bdbank_money + ?
WHERE user_id = ?

------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Credits/Entity/Transaction.php(157): XF\Db\AbstractAdapter->query('
UPDATE xf...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1219): DBTech\Credits\Entity\Transaction->_postSave()
#5 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(625): XF\Mvc\Entity\Entity->save(true, false)
#6 src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php(431): DBTech\Credits\EventTrigger\AbstractHandler->trigger(Object(XFRM\XF\Entity\User), 31924, true, Object(ArrayObject))
#7 src/addons/DBTech/Credits/XF/Entity/Thread.php(264): DBTech\Credits\EventTrigger\AbstractHandler->undo(31924, Array, Object(XFRM\XF\Entity\User))
#8 src/XF/Mvc/Entity/Entity.php(1595): DBTech\Credits\XF\Entity\Thread->_postDelete()
#9 src/XF/Service/Post/Mover.php(239): XF\Mvc\Entity\Entity->delete()
#10 src/XF/Service/Post/Mover.php(145): XF\Service\Post\Mover->updateSourceData()
#11 src/XF/InlineMod/Post/Move.php(39): XF\Service\Post\Mover->move(Array)
#12 src/XF/InlineMod/AbstractAction.php(80): XF\InlineMod\Post\Move->applyInternal(Object(XF\Mvc\Entity\ArrayCollection), Array)
#13 src/XF/Pub/Controller/InlineMod.php(131): XF\InlineMod\AbstractAction->apply(Object(XF\Mvc\Entity\ArrayCollection), Array)
#14 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\InlineMod->actionPerform(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(261): XF\Mvc\Dispatcher->dispatchClass('XF:InlineMod', 'Perform', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\InlineMod), Object(XF\Mvc\Reply\Reroute))
#16 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\InlineMod), Object(XF\Mvc\Reply\Reroute))
#17 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#19 src/XF.php(391): XF\App->run()
#20 index.php(20): XF::runApp('XF\\Pub\\App')
#21 {main}

 

[Fillip H.]

You would need to change the column definition to match that of the other Credits columns. It should be a signed DOUBLE.

 

[Charizard]

You would need to change the column definition to match that of the other Credits columns. It should be a signed DOUBLE.

Is there an SQL query I can run?

 

[Fillip H.]

Please back up your database before running any SQL queries.

Try this:

ALTER TABLE `xf_user` MODIFY `bdbank_money` DOUBLE NOT NULL DEFAULT '0'

 

[DragonByte Technologies]

Hello @Charizard,

We hope your ticket regarding DragonByte Credits has been addressed to your satisfaction. This ticket has now been scheduled to be 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.

 

[DragonByte Technologies]

Hello @Charizard,

As we have not heard back from you, your ticket regarding DragonByte Credits has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.