hb_config2accounts qty column is null

[charlie]

Hi!

Yesterday i upgrade Hostbill to 4.8.2 version, and this broke my SolusVM order page.

In the last page of order scenario, hostbill run to error:

Code Select Expand

Exception: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'qty' cannot be null IN /var/www/users/mikro/wwwroot/includes/components/order/class.order.php(2653), stack trace:
#0 /var/www/users/mikro/wwwroot/includes/components/order/class.order.php(2653): PDOStatement->execute()
#1 /var/www/users/mikro/wwwroot/includes/components/order/class.order.php(2190): Order->createAccount()
#2 /var/www/users/mikro/wwwroot/includes/modules/Site/cart/models/class.cart_model.php(1571): Order->buildOrder()
#3 /var/www/users/mikro/wwwroot/includes/modules/Site/cart/user/class.cart_controller.php(954): Cart_Model->buildOrder()
#4 /var/www/users/mikro/wwwroot/hbf/core/class.controller.php(253): cart_Controller->_default()
#5 /var/www/users/mikro/wwwroot/hbf/core/types/class.user_frontcontroller.php(121): Controller::dispatchControl()
#6 /var/www/users/mikro/wwwroot/hbf/core/class.frontcontroller.php(124): User_FrontController::dispatch()
#7 /var/www/users/mikro/wwwroot/hbf/core/class.frontcontroller.php(107): FrontController->handleRequest()
#8 /var/www/users/mikro/wwwroot/index.php(12): FrontController::init()
#9 {main}

I switched on mysql query log, and i see this insert before error:

Code Select Expand

INSERT INTO hb_config2accounts(`rel_type`,`account_id`,`config_cat`,`config_id`,`qty`,`data`) VALUES ('Hosting','110','116','1589',NULL,'')
so, hostbill simply send NULL, but MySQL expect a number for qty

Anybody met this error? (Or any other like this?)

[ninostar]

Hi,

Yes. I've first installed hostbill_version 2014-06-20 and thereafter made auto update. Then I've added two plugins - namecheap and cPanel, but sadly I get almost same error when trying to add a new product in any of both order pages.

Here's what I get:
Uh oh! Something went wrong ...
Exception: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sort_order' cannot be null IN /homepublic_html/servis/includes/modules/Site/services/models/class.services_model.php(1208), stack trace:
#0 /home/public_html/servis/includes/modules/Site/services/models/class.services_model.php(1208): PDOStatement->execute()
#1 /home/public_html/servis/includes/modules/Site/services/models/class.services_model.php(1532): Services_Model->addProduct()
#2 /home/public_html/servis/includes/modules/Site/services/admin/class.services_controller.php(448): Services_Model->editProduct()
#3 /home/public_html/servis/hbf/core/class.controller.php(254): services_Controller->beforeCall()
#4 /home/public_html/servis/hbf/core/types/class.admin_frontcontroller.php(129): Controller::dispatchControl()
#5 /home/public_html/servis/hbf/core/class.frontcontroller.php(124): Admin_FrontController->dispatch()
#6 /home/public_html/servis/hbf/core/class.frontcontroller.php(107): FrontController->handleRequest()
#7 /home/public_html/servis/admin/index.php(15): FrontController::init()
#8 {main}