Bug Server error log MySQL query error [1264]: Out of range value for column 'dbtech_credits_credits' at row 1

[Nirjonadda]

I am getting server error log about MySQL query error [1264]: Out of range value for column 'dbtech_credits_credits' at row 1

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

Generated by: prinanad Apr 26, 2018 at 9:32 AM

Stack trace

                    UPDATE xf_user
                    SET dbtech_credits_credits = -5.02
                    WHERE user_id = 1069
------------

#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(79): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Credits/Application/Db.php(785): XF\Db\AbstractAdapter->query('\n\t\t\t\t\tUPDATE xf...')
#4 src/addons/DBTech/Credits/Model/Event/AbstractEvent.php(649): DBTech\Credits\Application\Db->query('\n\t\t\t\t\tUPDATE xf...')
#5 src/addons/DBTech/Credits/Model/Event/AbstractEvent.php(598): DBTech\Credits\Model\Event\AbstractEvent->_commit(Array, Array, true)
#6 src/addons/DBTech/Credits/Model/Event/Thread.php(27): DBTech\Credits\Model\Event\AbstractEvent->trigger('thread', 1069, 2912, true, NULL)
#7 src/addons/DBTech/Credits/XF/Entity/Thread.php(260): DBTech\Credits\Model\Event\Thread->undo(1069, 92, 'Fy', 2912)
#8 src/addons/ThemeHouse/Bookmarks/XF/Entity/Thread.php(11): DBTech\Credits\XF\Entity\Thread->_postDelete()
#9 src/XF/Mvc/Entity/Entity.php(1517): ThemeHouse\Bookmarks\XF\Entity\Thread->_postDelete()
#10 src/XF/Service/Thread/Deleter.php(71): XF\Mvc\Entity\Entity->delete()
#11 src/XF/InlineMod/Thread/Delete.php(33): XF\Service\Thread\Deleter->delete('hard', '')
#12 src/XF/InlineMod/AbstractAction.php(87): XF\InlineMod\Thread\Delete->applyToEntity(Object(TickTackk\ChangeContentOwner\XF\Entity\Thread), Array)
#13 src/XF/InlineMod/AbstractAction.php(80): XF\InlineMod\AbstractAction->applyInternal(Object(XF\Mvc\Entity\ArrayCollection), Array)
#14 src/XF/Pub/Controller/InlineMod.php(131): XF\InlineMod\AbstractAction->apply(Object(XF\Mvc\Entity\ArrayCollection), Array)
#15 src/addons/Siropu/AdsManager/XF/Pub/Controller/InlineMod.php(54): XF\Pub\Controller\InlineMod->actionPerform()
#16 src/XF/Mvc/Dispatcher.php(249): Siropu\AdsManager\XF\Pub\Controller\InlineMod->actionPerform(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:InlineMod', 'Perform', 'json', Object(XF\Mvc\ParameterBag), '', Object(TickTackk\ChangeContentOwner\XF\Pub\Controller\InlineMod), Object(XF\Mvc\Reply\Reroute))
#18 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(1891): XF\Mvc\Dispatcher->run()
#20 src/XF.php(328): XF\App->run()
#21 index.php(13): XF::runApp('XF\\Pub\\App')
#22 {main}

Request state

array(4) {
  ["url"] => string(12) "/inline-mod/"
  ["referrer"] => string(46) "/search/3978/?mod=thread"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(10) {
    ["hard_delete"] => string(1) "1"
    ["ids"] => array(1) {
      [0] => string(4) "2912"
    }
    ["type"] => string(6) "thread"
    ["action"] => string(6) "delete"
    ["confirmed"] => string(1) "1"
    ["_xfRedirect"] => string(46) "/search/3978/?mod=thread"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(24) "/search/3978/?mod=thread"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Fillip H.]

Change the column to unsigned, that'll take care of it.

 

[Nirjonadda]

Change the column to unsigned, that'll take care of it.

How and where? Does not fix with update?

 

[Fillip H.]

Sorry, I meant change it to signed. You'll need to go into phpMyAdmin, in the user table, and change it in the column extras there.

 

[Nirjonadda]

Sorry, I meant change it to signed. You'll need to go into phpMyAdmin, in the user table, and change it in the column extras there.

Can not fix with update and what the problem with this table? Manually changing database are not good option.

 

[Fillip H.]

No, I can't. Not everyone is still using the default column, so the upgrader would cause errors instead. It has been fixed for new installs going forward.

 

[Nirjonadda]

No, I can't. Not everyone is still using the default column, so the upgrader would cause errors instead. It has been fixed for new installs going forward.

I can not find out for signed changing. Please let me know that what steps you are used?

 

[Fillip H.]

Choose the blank option.

 

[DragonByte Technologies]

Hello @Nirjonadda,

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.