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"
}
}