/module/bankwire/validation 500 internal server error

[gregcold]

Witam

Proszę o pomoc w rozwiązaniu problemu jaki napotkałem przy upgradzie presty z 1.6.0.9 do 1.6.1.13.

Strona działa do momentu kliknięcia potwierdź zakup potem wyskakuje 500 error. (moduł z x13.pl)

Włączyłem tryb debugowania i takie oto otrzymuje info może macie jakiś pomysł:

 

[PrestaShopDatabaseException]

Unknown column 'round_mode' 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`) VALUES ('1191', '1191', '1', '1', '1', '1', '1', '1075', '56', '0', 'c6a470eab22f1bbfb887bfc2007034fc', 'Przelew na konto', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '269', '269', '218.7', '0', '203.25', '250', '19', '19', '15.45', '23', '0', '0', '0', '2', '2', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'YRJYEDMLZ', '2017-05-29 12:12:04', '2017-05-29 12:12:04')

at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

  Argument [0]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`) VALUES ('1191', '1191', '1', '1', '1', '1', '1', '1075', '56', '0', 'c6a470eab22f1bbfb887bfc2007034fc', 'Przelew na konto', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '269', '269', '218.7', '0', '203.25', '250', '19', '19', '15.45', '23', '0', '0', '0', '2', '2', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'YRJYEDMLZ', '2017-05-29 12:12:04', '2017-05-29 12:12:04')

• DbCore->query - [line 763 - classes/db/Db.php] - [1 Arguments]

  Argument [0]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`) VALUES ('1191', '1191', '1', '1', '1', '1', '1', '1075', '56', '0', 'c6a470eab22f1bbfb887bfc2007034fc', 'Przelew na konto', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '269', '269', '218.7', '0', '203.25', '250', '19', '19', '15.45', '23', '0', '0', '0', '2', '2', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'YRJYEDMLZ', '2017-05-29 12:12:04', '2017-05-29 12:12:04')

• DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments]

  Argument [0]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`) VALUES ('1191', '1191', '1', '1', '1', '1', '1', '1075', '56', '0', 'c6a470eab22f1bbfb887bfc2007034fc', 'Przelew na konto', 'bankwire', '0', '0', NULL, '0', '0', '0', '0', '269', '269', '218.7', '0', '203.25', '250', '19', '19', '15.45', '23', '0', '0', '0', '2', '2', NULL, '1', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', 'YRJYEDMLZ', '2017-05-29 12:12:04', '2017-05-29 12:12:04')Argument [1]1

• DbCore->insert - [line 487 - classes/ObjectModel.php] - [3 Arguments]

  Argument [0]ordersArgument [1]Array(    [id_address_delivery] => 1191    [id_address_invoice] => 1191    [id_cart] => 1    [id_currency] => 1    [id_shop_group] => 1    [id_shop] => 1    [id_lang] => 1    [id_customer] => 1075    [id_carrier] => 56    [current_state] => 0    [secure_key] => c6a470eab22f1bbfb887bfc2007034fc    [payment] => Przelew na konto    [module] => bankwire    [recyclable] => 0    [gift] => 0    [gift_message] =>     [mobile_theme] => 0    [total_discounts] => 0    [total_discounts_tax_incl] => 0    [total_discounts_tax_excl] => 0    [total_paid] => 269    [total_paid_tax_incl] => 269    [total_paid_tax_excl] => 218.7    [total_paid_real] => 0    [total_products] => 203.25    [total_products_wt] => 250    [total_shipping] => 19    [total_shipping_tax_incl] => 19    [total_shipping_tax_excl] => 15.45    [carrier_tax_rate] => 23    [total_wrapping] => 0    [total_wrapping_tax_incl] => 0    [total_wrapping_tax_excl] => 0    [round_mode] => 2    [round_type] => 2    [shipping_number] =>     [conversion_rate] => 1    [invoice_number] => 0    [delivery_number] => 0    [invoice_date] => 0000-00-00 00:00:00    [delivery_date] => 0000-00-00 00:00:00    [valid] => 0    [reference] => YRJYEDMLZ    [date_add] => 2017-05-29 12:12:04    [date_upd] => 2017-05-29 12:12:04)Argument [2]1

• ObjectModelCore->add - [line 309 - classes/order/Order.php] - [2 Arguments]

  Argument [0]1Argument [1]1

• OrderCore->add - [line 227 - override/classes/PaymentModule.php]

  222. 223. 					if (self::DEBUG_MODE)224. 						PrestaShopLogger::addLog('PaymentModule::validateOrder - Order is about to be added', 1, null, 'Cart', (int)$id_cart, true);225. 226. 					// Creating order227. 					$result = $order->add();228. 229. 					if (!$result)230. 					{231. 						PrestaShopLogger::addLog('PaymentModule::validateOrder - Order cannot be created', 3, null, 'Cart', (int)$id_cart, true);232. 						throw new PrestaShopException('Can\'t save Order');

• PaymentModule->validateOrder - [line 64 - modules/bankwire/controllers/front/validation.php] - [9 Arguments]

  59. 			'{bankwire_owner}' => Configuration::get('BANK_WIRE_OWNER'),60. 			'{bankwire_details}' => nl2br(Configuration::get('BANK_WIRE_DETAILS')),61. 			'{bankwire_address}' => nl2br(Configuration::get('BANK_WIRE_ADDRESS'))62. 		);63. 64. 		$this->module->validateOrder($cart->id, Configuration::get('PS_OS_BANKWIRE'), $total, $this->module->displayName, NULL, $mailVars, (int)$currency->id, false, $customer->secure_key);65. 		Tools::redirect('index.php?controller=order-confirmation&id_cart='.$cart->id.'&id_module='.$this->module->id.'&id_order='.$this->module->currentOrder.'&key='.$customer->secure_key);66. 	}67. }

• BankwireValidationModuleFrontController->postProcess - [line 178 - classes/controller/Controller.php]

  173.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {174.                 $this->setMedia();175.             }176. 177.             // postProcess handles ajaxProcess178.             $this->postProcess();179. 180.             if (!empty($this->redirect_after)) {181.                 $this->redirect();182.             }183. 

• ControllerCore->run - [line 367 - classes/Dispatcher.php]

  362.             if (isset($params_hook_action_dispatcher)) {363.                 Hook::exec('actionDispatcher', $params_hook_action_dispatcher);364.             }365. 366.             // Running controller367.             $controller->run();368.         } catch (PrestaShopException $e) {369.             $e->displayMessage();370.         }371.     }372. 

• DispatcherCore->dispatch - [line 28 - index.php]

  23. *  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)24. *  International Registered Trademark & Property of PrestaShop SA25. */26. 27. require(dirname(__FILE__).'/config/config.inc.php');28. Dispatcher::getInstance()->dispatch();

 

[koening]

Sprawdź w phpmyadmin  czy w tabeli  ps_orders istnieje kolumna round_mode

[gregcold]

Witam

dodałem kilka brakujących  kolumn do tabel ps_orders i ps_order_detail po czym pojawiły się inne błędy może ktoś wie co dalej trzeba zrobić

 

Strict Standards: Declaration of Mail::Send() should be compatible with MailCore::Send($id_lang, $template, $subject, $template_vars, $to, $to_name = NULL, $from = NULL, $from_name = NULL, $file_attachment = NULL, $mode_smtp = NULL, $template_path = '/home/test...', $die = false, $id_shop = NULL, $bcc = NULL, $reply_to = NULL) in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 47

Warning: include_once(/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift.php): failed to open stream: No such file or directory in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 3

Warning: include_once(): Failed opening '/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 3

Warning: include_once(/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Connection/SMTP.php): failed to open stream: No such file or directory in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 4

Warning: include_once(): Failed opening '/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Connection/SMTP.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 4

Warning: include_once(/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Connection/NativeMail.php): failed to open stream: No such file or directory in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 5

Warning: include_once(): Failed opening '/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Connection/NativeMail.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 5

Warning: include_once(/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Plugin/Decorator.php): failed to open stream: No such file or directory in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 6

Warning: include_once(): Failed opening '/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/swift/Swift/Plugin/Decorator.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/override/classes/Mail.php on line 6

Fatal error: Uncaught --> Smarty Compiler: Syntax error in template "/home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/themes/transformer/mails/pl/order_conf_product_list.txt" on line 2 "{$product[\'reference\']}" - Unexpected "\" <-- thrown in /home/testowa/domains/fotoporcelana.com.pl/public_html/prestashop3/tools/smarty/sysplugins/smarty_internal_templatecompilerbase.php on line 2

[e_com]

Witam

dodałem kilka brakujących  kolumn do tabel ps_orders i ps_order_detail po czym pojawiły się inne błędy może ktoś wie co dalej trzeba zrobić

 

1. Jeśli w bazie brakuje trochę kolumn tu, trochę tam, to ten sklep raczej nie ma prawa działać bo nie wiadomo gdzie są jeszcze dziury w bazie.

2. Jakieś błędne nadpisania klasy Mail w overridach.

3. Błędy składni w templatkach e-maili.

[Piotr K.]

Masz override klasy mail.php - może miałeś moduł aktualizujący swiftmailer a może coś innego i teraz są problemy - trzeba to uporządkować najpierw bo w mailach między 1.6.0.9 a 1.6.1.13 były bardzo duże zmiany.