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

Status
Not open for further replies.

Nirjonadda

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

Code:
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"
  }
}
 
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.
 
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.
 
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.
 
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,624
Customer rating
5.00 star(s) 5 ratings
Back
Top