Error 500 orders

[corianito]

Hello everyone,

I have a problem on my prestashop 1.6.  On the last step to confirm orders, it throws a Server 500 error.  I was able to change the defines.ini.php file and it gave me this info.  I just hope any of you guys can help me fix it.  Thank you for all your help.

 

 

 

[PrestaShopDatabaseException]

Unknown column 'payment_fee' 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`, `shipping_number`, `conversion_rate`, `invoice_number`, `delivery_number`, `invoice_date`, `delivery_date`, `valid`, `reference`, `date_add`, `date_upd`, `payment_fee`, `payment_fee_rate`) VALUES ('171', '171', '334', '2', '1', '1', '3', '161', '44', '0', 'ee245a43982254e9621945584406a60d', 'Transferencia bancaria', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '8.27', '8.27', '8.27', '0', '5', '5', '3.27', '3.27', '3.27', '0', '0', '0', '0', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'DJWAUTJOX', '2014-11-17 02:00:20', '2014-11-17 02:00:20', '0', '0')

at line 635 in file classes/db/Db.php
629.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630.         }
631.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632.         {
633.             if ($sql)
634.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635.             throw new PrestaShopDatabaseException($this->getMsgError());
636.         }
637.     }
638. 
639.     /**
DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 464 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 289 - classes/order/Order.php] - [2 Arguments]
OrderCore->add - [line 330 - classes/PaymentModule.php]
PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments]
BankwireValidationModuleFrontController->postProcess - [line 171 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Edited November 19, 2014 by corianito (see edit history)

[El Patron]

do you have module that add's payment fee to order?

 

this looks like issue with some feature you have added...not a native prestashop issue.

[corianito]

I have nothing added, just upgraded from version 1.5 through clickupdate.

 

Can you think of any idea how to fix it?

[El Patron]

uninstall bankwire module and retest

[corianito]

I've already reinstalled, still the same.

[El Patron]

you seem to have old logic from 1.5 that expect payment_fee in orders table.  native 1.6 does not have this field

 

 

I see this in trace above, I can only assume from this view what exact issue is.

ObjectModelCore->add - [line 289 - classes/order/Order.php] - [2 Arguments]
OrderCore->add - [line 330 - classes/PaymentModule.php]
PaymentModuleCore->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments]

but if you uninstalled, then please re-post the error with trace data

[www.tabletegd.com]

I have the same problem, any idea?

[tuk66]

Search for payment_fee in your old files. You had payment_fee and payment_fee_rate fields in the old ps_orders table and the bankwire module (possibly patched) is trying to use them.