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 link_relID = prod_id AND prod_active = 1 GROUP BY prod_id ORDER BY prod_p...' at line 1
SELECT link_relID FROM shop_related_products,shop_products WHERE link_prodID = AND link_relID = prod_id AND prod_active = 1 GROUP BY prod_id ORDER BY prod_pos ASC LIMIT 4
SELECT link_relID FROM shop_related_products,shop_products WHERE link_prodID = AND link_relID = prod_id AND prod_active = 1 GROUP BY prod_id ORDER BY prod_pos ASC LIMIT 4
array(5) {
[0]=>
array(4) {
["file"]=>
string(91) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/admin/extensions/shop/classes/class.product.php"
["line"]=>
int(1008)
["function"]=>
string(7) "dbQuery"
["args"]=>
array(1) {
[0]=>
string(171) "SELECT link_relID FROM shop_related_products,shop_products WHERE link_prodID = AND link_relID = prod_id AND prod_active = 1 GROUP BY prod_id ORDER BY prod_pos ASC LIMIT 4"
}
}
[1]=>
array(7) {
["file"]=>
string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/modules/shop-related_products.php"
["line"]=>
int(17)
["function"]=>
string(20) "get_related_products"
["class"]=>
string(7) "product"
["object"]=>
object(product)#60 (57) {
["id"]=>
NULL
["dateAdded"]=>
NULL
["dateModified"]=>
NULL
["sectionID"]=>
NULL
["title"]=>
NULL
["slug"]=>
NULL
["summary"]=>
NULL
["desc"]=>
NULL
["tags"]=>
NULL
["colour1"]=>
NULL
["colour2"]=>
NULL
["colour3"]=>
NULL
["ss_img"]=>
NULL
["show_ss"]=>
int(0)
["expired"]=>
int(0)
["available"]=>
int(0)
["pos"]=>
int(0)
["active"]=>
int(0)
["vat"]=>
int(0)
["featured"]=>
int(0)
["featuredPos"]=>
int(0)
["ship_choice"]=>
string(3) "ALL"
["shipping"]=>
int(0)
["ship_selected"]=>
NULL
["ship_insurance"]=>
int(0)
["thumbnail"]=>
int(0)
["code"]=>
NULL
["unit_term"]=>
NULL
["option_label"]=>
NULL
["option2_label"]=>
NULL
["option3_label"]=>
NULL
["option4_label"]=>
NULL
["cost"]=>
int(0)
["info_req"]=>
int(0)
["info_label"]=>
NULL
["archived"]=>
int(0)
["base_price"]=>
int(0)
["base_sale_price"]=>
int(0)
["size_req"]=>
int(0)
["col_req"]=>
int(0)
["option_req"]=>
int(0)
["option2_req"]=>
int(0)
["option3_req"]=>
int(0)
["option4_req"]=>
int(0)
["turnaround"]=>
int(0)
["shipping_cat"]=>
int(0)
["option_desc"]=>
NULL
["option2_desc"]=>
NULL
["option3_desc"]=>
NULL
["option4_desc"]=>
NULL
["brand_id"]=>
int(0)
["props":"product":private]=>
array(51) {
[0]=>
string(2) "id"
[1]=>
string(9) "dateAdded"
[2]=>
string(12) "dateModified"
[3]=>
string(9) "sectionID"
[4]=>
string(5) "title"
[5]=>
string(4) "slug"
[6]=>
string(7) "summary"
[7]=>
string(4) "desc"
[8]=>
string(4) "tags"
[9]=>
string(7) "colour1"
[10]=>
string(7) "colour2"
[11]=>
string(7) "colour3"
[12]=>
string(6) "ss_img"
[13]=>
string(7) "show_ss"
[14]=>
string(7) "expired"
[15]=>
string(9) "available"
[16]=>
string(3) "pos"
[17]=>
string(6) "active"
[18]=>
string(3) "vat"
[19]=>
string(8) "featured"
[20]=>
string(11) "featuredPos"
[21]=>
string(11) "ship_choice"
[22]=>
string(8) "shipping"
[23]=>
string(13) "ship_selected"
[24]=>
string(14) "ship_insurance"
[25]=>
string(9) "thumbnail"
[26]=>
string(4) "code"
[27]=>
string(9) "unit_term"
[28]=>
string(12) "option_label"
[29]=>
string(13) "option2_label"
[30]=>
string(13) "option3_label"
[31]=>
string(13) "option4_label"
[32]=>
string(4) "cost"
[33]=>
string(8) "info_req"
[34]=>
string(10) "info_label"
[35]=>
string(8) "archived"
[36]=>
string(10) "base_price"
[37]=>
string(15) "base_sale_price"
[38]=>
string(8) "size_req"
[39]=>
string(7) "col_req"
[40]=>
string(10) "option_req"
[41]=>
string(11) "option2_req"
[42]=>
string(11) "option3_req"
[43]=>
string(11) "option4_req"
[44]=>
string(10) "turnaround"
[45]=>
string(12) "shipping_cat"
[46]=>
string(11) "option_desc"
[47]=>
string(12) "option2_desc"
[48]=>
string(12) "option3_desc"
[49]=>
string(12) "option4_desc"
[50]=>
string(8) "brand_id"
}
["images"]=>
NULL
["stock"]=>
NULL
["trans_id"]=>
NULL
["lang":"product":private]=>
string(2) "en"
["sale_item"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
array(1) {
["limit"]=>
int(4)
}
}
}
[2]=>
array(4) {
["file"]=>
string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/includes/content-shop_product.php"
["line"]=>
int(73)
["args"]=>
array(1) {
[0]=>
string(82) "/srv/data/vhosts/sallyelford.co.uk/httpdocs/site/modules/shop-related_products.php"
}
["function"]=>
string(7) "include"
}
[3]=>
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_product.php"
}
["function"]=>
string(7) "include"
}
[4]=>
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"
}
}