Hi,
I'm unable to use the credits addon cause each transaction I get the following error:
Any idea about how to solve this?
Thanks in advance
I'm unable to use the credits addon cause each transaction I get the following error:
Code:
XF\Db\Exception: Job XF:ApprovalQueueProcess: MySQL query error [1292]: Truncated incorrect INTEGER value: '-10.00000000' src/XF/Db/AbstractStatement.php:228
UPDATE xf_user
SET dbtech_credits_credits = GREATEST(0, CAST(dbtech_credits_credits AS SIGNED) + ?)
WHERE user_id = ?
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1292, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1292, '22007')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Credits/Entity/Transaction.php(199): XF\Db\AbstractAdapter->query('
UPDATE xf...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1266): DBTech\Credits\Entity\Transaction->_postSave()
#5 src/addons/DBTech/Credits/Service/Transaction/Approve.php(101): XF\Mvc\Entity\Entity->save()
#6 src/addons/DBTech/Credits/ApprovalQueue/Transaction.php(98): DBTech\Credits\Service\Transaction\Approve->approve()
#7 [internal function]: DBTech\Credits\ApprovalQueue\Transaction->actionApprove(Object(DBTech\Credits\Entity\Transaction))
#8 src/XF/ApprovalQueue/AbstractHandler.php(120): call_user_func_array(Array, Array)
#9 src/XF/Job/ApprovalQueueProcess.php(67): XF\ApprovalQueue\AbstractHandler->performAction('approve', Object(DBTech\Credits\Entity\Transaction))
#10 src/XF.php(589): XF\Job\ApprovalQueueProcess->XF\Job\{closure}()
#11 src/XF/Job/ApprovalQueueProcess.php(68): XF::asVisitor(Object(MMO\Hide\XF\Entity\User), Object(Closure))
#12 src/XF/Job/Manager.php(258): XF\Job\ApprovalQueueProcess->run(8)
#13 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal(Array, 8)
#14 src/XF/Job/Manager.php(116): XF\Job\Manager->runJobEntry(Array, 8)
#15 job.php(22): XF\Job\Manager->runByIds(Array, 8)
#16 {main}
Any idea about how to solve this?
Thanks in advance
Last edited: