SOFTD Posted August 3, 2015 Share Posted August 3, 2015 Hola, a todos, les comento mi problema: actualice mi tienda a la versión 1.6.1 vengo de la versión 1.6.01, el principal problema es que no aparecen los productos en las ordenes del backoffice y en los correos, vi la solución de desactivar todos los módulos y volver a activarlos, no funciono, cuando realizo la compra y voy al último paso me aparece: [PrestaShopDatabaseException]Unknown column 'original_wholesale_price' in 'field list' INSERT INTO `ims_order_detail` (`id_order`, `id_order_invoice`, `id_warehouse`, `id_shop`, `product_id`, `product_attribute_id`, `product_name`, `product_quantity`, `product_quantity_in_stock`, `product_quantity_return`, `product_quantity_refunded`, `product_quantity_reinjected`, `product_price`, `reduction_percent`, `reduction_amount`, `reduction_amount_tax_incl`, `reduction_amount_tax_excl`, `group_reduction`, `product_quantity_discount`, `product_ean13`, `product_upc`, `product_reference`, `product_supplier_reference`, `product_weight`, `tax_name`, `tax_rate`, `tax_computation_method`, `id_tax_rules_group`, `ecotax`, `ecotax_tax_rate`, `discount_quantity_applied`, `download_hash`, `download_nb`, `download_deadline`, `unit_price_tax_incl`, `unit_price_tax_excl`, `total_price_tax_incl`, `total_price_tax_excl`, `purchase_supplier_price`, `original_product_price`, `original_wholesale_price`) VALUES ('2615', '0', '0', '1', '22785', '0', 'PRESTO VIVACE - 9597', '1', '1', '0', '0', '0', '100', '0', '0', '0', '0', '0', '0', '7783478761828', '', 'DISTRO 3930', '', '0.15', '', '0', '0', '0', '0', '0', '0', '', '0', '0000-00-00 00:00:00', '100', '100', '100', '100', '66', '100', '66')at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) {787. $dbg = debug_backtrace();788. WebserviceRequest::getInstance()->setError(500, ' '.$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] DbCore->query - [line 763 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 487 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 800 - classes/order/OrderDetail.php] - [2 Arguments] OrderDetailCore->add - [line 445 - classes/ObjectModel.php] - [2 Arguments] ObjectModelCore->save - [line 651 - classes/order/OrderDetail.php] OrderDetailCore->create - [line 676 - classes/order/OrderDetail.php] - [7 Arguments] OrderDetailCore->createList - [line 364 - classes/PaymentModule.php] - [7 Arguments] PaymentModuleCore->validateOrder - [line 59 - modules/cashondelivery/controllers/front/validation.php] - [9 Arguments] CashondeliveryValidationModuleFrontController->postProcess - [line 178 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
SOFTD Posted August 3, 2015 Author Share Posted August 3, 2015 AL final pude solucionar el problema creando la columna original_wholesale_price en la tabla ims_order_detail tema resuelto 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now