Orders cannot be completed... :(

[movieseals]

When clients try to process their payment, they get the following error:

500 Server Error Oops, something went wrong.

Try to refresh this page or feel free to contact us if the problem persists. Please make sure to expand and include the following error code in your message, so we can help you better:

And then there is an encrypted list for the error code. It does not matter what payment method is used. Nothing special appears in the php logs...

Any help would be appreciated. Thirty Bees 1.0.3

[SLiCK_303]

try turning debugging on, see if that comes up with a better error message

[movieseals]

This is what Debug gets me, with a PayPal payment:

[ThirtyBeesDatabaseException] Unknown column 'owners' in 'field list'

INSERT INTO ps_orders (id_address_delivery, id_address_invoice, id_cart, id_currency, id_shop_group, id_shop, id_lang, id_customer, id_carrier, current_state, secure_key, payment, module, recyclable, gift, gift_message, mobile_theme, total_discounts, total_discounts_tax_incl, total_discounts_tax_excl, total_paid, total_paid_tax_incl, total_paid_tax_excl, total_paid_real, total_products, total_products_wt, total_shipping, total_shipping_tax_incl, total_shipping_tax_excl, carrier_tax_rate, total_wrapping, total_wrapping_tax_incl, total_wrapping_tax_excl, round_mode, round_type, shipping_number, conversion_rate, invoice_number, delivery_number, invoice_date, delivery_date, valid, reference, date_add, date_upd, owners) VALUES ('160', '160', '665', '3', '1', '1', '1', '158', '324', '0', '71794f8423d60628ec48babbbbce7364', 'PayPal Payments Standard', 'elegantalpaymentpaypal', '0', '0', NULL, '0', '0', '0', '0', '6.6', '6.6', '6.28', '0', '6.28', '6.6', '0', '0', '0', '0', '0', '0', '0', '2', '3', NULL, '1.256926', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'YMKOOEWKH', '2018-02-22 13:42:11', '2018-02-22 13:42:11', NULL)

at line 808 in file classes/db/Db.php 803. if ($webserviceCall && $errno) { 804. $dbg = debugbacktrace(); 805. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 806. } elseif (PSDEBUGSQL_ && $errno && !defined('TBINSTALLATIONIN_PROGRESS')) { 807. if ($sql) { 808. throw new PrestaShopDatabaseException($this->getMsgError().'

'.$sql.'

'); 809. } 810. 811. throw new PrestaShopDatabaseException($this->getMsgError()); 812. } 813. } DbCore->displayError - [line 460 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 783 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 553 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 586 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 303 - classes/order/Order.php] - [2 Arguments] OrderCore->add - [line 559 - classes/module/PaymentModule.php] PaymentModuleCore->validateOrder - [line 1317 - controllers/admin/AdminOrdersController.php] - [9 Arguments] AdminOrdersControllerCore->postProcess - [line 355 - classes/controller/Controller.php] ControllerCore->run - [line 743 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 63 - admin/index.php]

[SLiCK_303]

I wonder what module or override put 'owners' there, its not normal in the table. Any thoughts?

[movieseals]

That would be a module called Employees, but it is currently uninstalled, as it was causing other issues in the backend.

[SLiCK_303]

it's disabled, or uninstalled? If uninstalled, it did a crappy job of that.

[movieseals]

Definitely uninstalled, not disabled.

[SLiCK_303]

Do you know if when you installed it, it had any overrides?

[movieseals]

I guess I am going to try and find the overrides of that modules and remove them? It does have several overrides.

[SLiCK_303]

yeah. If you dont have it installed anymore, you need to get rid of it's overrides. I hope you have a good backup....just in case something goes wrong

[movieseals]

Trying to track them all down. Will let you know. Already found one in orders.

[movieseals]

Yup, that did it. Thanks...

[SLiCK_303]

You did it, not me, but you're welcome. ;)

[movieseals]

You pointed me in the right direction, which is highly valuable in my book! ;)

[SLiCK_303]

well then...glad I could help. Feel free to mark this one solved.

[wakabayashi]

I will mark this thread als solved...