Question Please help. Got an error

Status
Not open for further replies.

Bastty

Customer
Server error log

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.
 
I've confirmed a bug with this feature and a maintenance version will be released shortly.
 
Hello @...like Pro!,

We hope your ticket regarding DragonByte eCommerce 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.
 
Status
Not open for further replies.

DragonByte eCommerce

XenForo 2.0.6+ XenForo 2.1.x XenForo 2.2.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,405
Customer rating
4.83 star(s) 6 ratings
Back
Top