mysqli_sql_exception: 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 a.published = 1 GROUP BY b.product_id ORDER BY a.ordering desc LIMIT 0,16' at line 2 in /work/savani.vn/public_html/libraries/CI/Database/MySQLi/Connection.php:331
Stack trace:
#0 /work/savani.vn/public_html/libraries/CI/Database/MySQLi/Connection.php(331): mysqli->query()
#1 /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php(756): CodeIgniter\Database\MySQLi\Connection->execute()
#2 /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php(676): CodeIgniter\Database\BaseConnection->simpleQuery()
#3 /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php(1969): CodeIgniter\Database\BaseConnection->query()
#4 /work/savani.vn/public_html/modules/products/models/collection.php(222): CodeIgniter\Database\BaseConnection->query_limit()
#5 /work/savani.vn/public_html/modules/products/controllers/collection.php(37): ProductsModelsCollection->getProductsList()
#6 /work/savani.vn/public_html/libraries/functions.php(1199): ProductsControllersCollection->detail()
#7 /work/savani.vn/public_html/index.php(305): call_module()
#8 /work/savani.vn/public_html/index.php(176): loadMainContent()
#9 {main}
Fatal error: Uncaught Error: Call to undefined method CodeIgniter\Database\Query::getResult() in /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php:705
Stack trace:
#0 /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php(1969): CodeIgniter\Database\BaseConnection->query()
#1 /work/savani.vn/public_html/modules/products/models/collection.php(222): CodeIgniter\Database\BaseConnection->query_limit()
#2 /work/savani.vn/public_html/modules/products/controllers/collection.php(37): ProductsModelsCollection->getProductsList()
#3 /work/savani.vn/public_html/libraries/functions.php(1199): ProductsControllersCollection->detail()
#4 /work/savani.vn/public_html/index.php(305): call_module()
#5 /work/savani.vn/public_html/index.php(176): loadMainContent()
#6 {main}
thrown in /work/savani.vn/public_html/libraries/CI/Database/BaseConnection.php on line 705