Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 status in (1) ORDER BY FIELD(id,)' at line 1 in /var/www/vhosts/shared/app_backend/prod/service_v2/utils.php:46
Stack trace:
#0 /var/www/vhosts/shared/app_backend/prod/service_v2/utils.php(46): PDOStatement->execute()
#1 /var/www/vhosts/shared/app_backend/prod/service_v2/utils.php(206): execSqlQuery()
#2 /var/www/vhosts/shared/app_backend/prod/service_v2/CB_Retailers.php(118): execMemQuery()
#3 /var/www/vhosts/cashyo.com/httpdocs/front/Classes/views/Search.php(97): CB_Retailers::getRetailersByIds()
#4 /var/www/vhosts/cashyo.com/httpdocs/front/Classes/views/Search.php(52): Search->getRetailersPreviewHTML()
#5 /var/www/vhosts/cashyo.com/httpdocs/front/Classes/mainView.php(213): Search->getContent()
#6 /var/www/vhosts/cashyo.com/httpdocs/front/Classes/mainView.php(139): mainView->renderPage()
#7 /var/www/vhosts/cashyo.com/httpdocs/front/index.php(32): mainView->renderLayout()
#8 /var/www/vhosts/cashyo.com/httpdocs/front/index.php(80): renderCurrentPage()
#9 {main}
thrown in /var/www/vhosts/shared/app_backend/prod/service_v2/utils.php on line 46