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 prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC' at line 1
SELECT shop_products.* FROM shop_products WHERE prod_sectionID = AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC
SELECT shop_products.* FROM shop_products WHERE prod_sectionID = AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC
array(4) { [0]=> array(4) { ["file"]=> string(91) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/admin/extensions/shop/classes/class.section.php" ["line"]=> int(240) ["function"]=> string(7) "dbQuery" ["args"]=> array(1) { [0]=> string(129) "SELECT shop_products.* FROM shop_products WHERE prod_sectionID = AND prod_active = 1 AND prod_archived = 0 ORDER BY prod_pos ASC" } } [1]=> array(7) { ["file"]=> string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/includes/content-shop_section.php" ["line"]=> int(72) ["function"]=> string(12) "get_products" ["class"]=> string(12) "shop_section" ["object"]=> object(shop_section)#57 (17) { ["id"]=> NULL ["parent"]=> NULL ["name"]=> NULL ["subhead"]=> NULL ["slug"]=> NULL ["details"]=> NULL ["dateAdded"]=> NULL ["dateModified"]=> NULL ["pos"]=> NULL ["active"]=> NULL ["show_nostock"]=> NULL ["show_archived"]=> NULL ["prods_per_page"]=> NULL ["pagination"]=> NULL ["in_sitemap"]=> NULL ["trans_id"]=> NULL ["lang":"shop_section":private]=> string(2) "en" } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(2) { ["orderby"]=> string(8) "prod_pos" ["sort"]=> string(3) "ASC" } } } [2]=> array(4) { ["file"]=> string(58) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/index.php" ["line"]=> int(237) ["args"]=> array(1) { [0]=> string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/includes/content-shop_section.php" } ["function"]=> string(7) "include" } [3]=> array(4) { ["file"]=> string(53) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/index.php" ["line"]=> int(2) ["args"]=> array(1) { [0]=> string(58) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/index.php" } ["function"]=> string(7) "include" } }