Bastty
Customer
Server error log
Stack trace
Request state
Got this error when I try to to set an address (from admincp>> DragonByte eCommerce>> Addresses), like default.
My address was set before from Settings, but it was like a testing address. Thank you.
Code:
XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: '' for column 'is_default' at row 1 src/XF/Db/AbstractStatement.php:228
Generated by: Bastty Feb 17, 2020 at 12:36 AM
Stack trace
Code:
INSERT INTO `xf_dbtech_ecommerce_address` (`user_id`, `title`, `business_title`, `business_co`, `address1`, `address2`, `address3`, `address4`, `country_code`, `sales_tax_id`, `address_state`, `address_id`, `is_default`, `order_count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_dbtech_ecomm...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/DBTech/eCommerce/Service/Address/Create.php(145): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Service/ValidateAndSavableTrait.php(40): DBTech\eCommerce\Service\Address\Create->_save()
#8 src/addons/DBTech/eCommerce/Admin/Controller/Address.php(238): DBTech\eCommerce\Service\Address\Create->save()
#9 src/XF.php(479): DBTech\eCommerce\Admin\Controller\Address->DBTech\eCommerce\Admin\Controller\{closure}()
#10 src/addons/DBTech/eCommerce/Admin/Controller/Address.php(242): XF::asVisitor(Object(DBTech\eCommerce\XF\Entity\User), Object(Closure))
#11 src/XF/Mvc/Dispatcher.php(350): DBTech\eCommerce\Admin\Controller\Address->actionSave(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('DBTech\\eCommerc...', 'Save', Object(XF\Mvc\RouteMatch), Object(DBTech\eCommerce\Admin\Controller\Address), NULL)
#13 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(DBTech\eCommerce\Admin\Controller\Address), NULL)
#14 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#16 src/XF.php(391): XF\App->run()
#17 admin.php(13): XF::runApp('XF\\Admin\\App')
#18 {main}
Request state
Code:
array(4) {
["url"] => string(44) "/admin.php?dbtech-ecommerce/addresses/0/save"
["referrer"] => string(60) "https://we-play.pro/admin.php?dbtech-ecommerce/addresses/add"
["_GET"] => array(1) {
["dbtech-ecommerce/addresses/0/save"] => string(0) ""
}
["_POST"] => array(14) {
["username"] => string(6) "Bastty"
["title"] => string(6) "Office"
["business_title"] => string(38) "WE-PLAY.PRO | Premium Gaming Community"
["business_co"] => string(0) ""
["address1"] => string(56) "12 Girton Road, Ellesmere Port, Cheshire, United Kingdom"
["address2"] => string(0) ""
["address3"] => string(0) ""
["address4"] => string(0) ""
["country_code"] => string(2) "GB"
["address_state"] => string(7) "visible"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(41) "/admin.php?dbtech-ecommerce/addresses/add"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Got this error when I try to to set an address (from admincp>> DragonByte eCommerce>> Addresses), like default.
My address was set before from Settings, but it was like a testing address. Thank you.