What's New
Viewing 4 posts - 1 through 4 (of 4 total)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic.
After saving an product filter by category, the following error is displayed in debug mode:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘3,)’ at line 1<br /><br />
SELECT name
FROM mp_category_lang WHERE id_lang=1 AND id_shop=1 AND id_category IN (,3,)
at line 769 in file classes/db/Db.php
if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
PS Version 1.7.7.5
PHP 7.3
MySQL-Version 5.7.34
Hi,
Please replace the \modules\stproductsbyattrs\stproductsbyattrs.php file with my attached one.
Best regards.
You must be logged in to reply to this topic.