Fatal error: Uncaught Dibi\DriverException: 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 ')
) AND p.status=1
GROUP BY p.id
ORDER BY id ASC' at line 5 in /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/Drivers/MySqliDriver.php:179
Stack trace:
#0 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/Drivers/MySqliDriver.php(156): Dibi\Drivers\MySqliDriver::createException('You have an err...', 1064, '\n SELECT p.*...')
#1 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/Connection.php(316): Dibi\Drivers\MySqliDriver->query('\n SELECT p.*...')
#2 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/Connection.php(234): Dibi\Connection->nativeQuery('\n SELECT p.*...')
#3 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/dibi.php(176): Dibi\Connection->query(Array)
#4 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/modules/eshop/favorit.php(12): dibi::query(Array)
#5 /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/index.php(204): include('/data/e/b/eb154...')
#6 {main}
SQL:
SELECT p.*, IF(ps.sale>0 and ps.sale<ps.price, ps.sale, ps.price) as cena FROM product p
LEFT JOIN product_stock ps ON ps.id_product=p.id
LEFT JOIN brand b ON p.id_brand=b.id
WHERE (
ps.codecrc IN ()
) AND p.status=1
GROUP BY p.id
ORDER BY id ASC
thrown in /data/e/b/eb15478f-da5d-4164-abf9-f7cec58820a7/novotechno.sk/web/libs/Dibi/Dibi/Drivers/MySqliDriver.php on line 179