Tygh\Exceptions\AException

Message

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 ') GROUP BY products.product_id' at line 3 (1064)

SELECT GROUP_CONCAT(pc.category_id) AS categories FROM cscart_products AS products LEFT JOIN cscart_products_categories AS pc ON products.product_id = pc.product_id WHERE 1 AND products.product_id IN () GROUP BY products.product_id

Error at

app/Tygh/Database/Connection.php, line: 1153

Backtrace

File:app/Tygh/Database/Connection.php
Line:516
Function:throwError
File:app/Tygh/Database/Connection.php
Line:317
Function:query
File:app/functions/fn.database.php
Line:81
Function:getColumn
File:app/addons/ab__deal_of_the_day/controllers/frontend/promotions.post.php
Line:61
Function:db_get_fields
File:app/functions/fn.control.php
Line:679
Function:include
File:app/functions/fn.control.php
Line:430
Function:fn_run_controller
File:index.php
Line:27
Function:fn_dispatch