Buenas,
Lo que nos dijeron en soporte es lo siguiente:
Hemos activado el debug de prestashop y está arrojando un error:
[[PrestaShopDatabaseException]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') as total_paid_tax_excl, SUM(a0.total_paid_tax_incl + ) as total_paid_tax_incl,' at line 8
SELECT id_order_invoice,
id_order,
number,
delivery_number,
delivery_date,
total_discount_tax_excl,
total_discount_tax_incl,
SUM(a0.total_paid_tax_excl + ) as total_paid_tax_excl,
SUM(a0.total_paid_tax_incl + ) as total_paid_tax_incl,
total_products,
total_products_wt,
total_shipping_tax_excl,
total_shipping_tax_incl,
shipping_tax_computation_method,
total_wrapping_tax_excl,
total_wrapping_tax_incl,
shop_address,
invoice_address,
delivery_address,
note,
date_add
FROM `ps_order_invoice` a0
WHERE (a0.`id_order` = 185)
GROUP BY id_order_invoice
at line 746 in file classes/db/Db.php
741. if ($webservice_call && $errno) {
742. $dbg = debug_backtrace();
743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745. if ($sql) {
746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747. }
748.
749. throw new PrestaShopDatabaseException($this->getMsgError());
750. }
751. }
DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 597 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 357 - classes/PrestaShopCollection.php] - [1 Arguments]
PrestaShopCollectionCore->getAll - [line 454 - classes/PrestaShopCollection.php]
PrestaShopCollectionCore->count - [line - ]
count - [line 91 - classes/pdf/PDF.php] - [1 Arguments]
PDFCore->__construct - [line 72 - controllers/front/PdfInvoiceController.php] - [3 Arguments]
PdfInvoiceControllerCore->display - [line 275 - classes/controller/Controller.php]
ControllerCore->run - [line 428 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]
Un saludo,
