Search the shop
You may also like
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY prc_id ORDER BY prc_pos ASC' at line 1
SELECT prc_id FROM shop_prices WHERE prc_prodID = GROUP BY prc_id ORDER BY prc_pos ASC
SELECT prc_id FROM shop_prices WHERE prc_prodID = GROUP BY prc_id ORDER BY prc_pos ASC
array(4) {
[0]=>
array(4) {
["file"]=>
string(83) "/data/vhosts/boxbird.co.uk/httpdocs/admin/extensions/shop/classes/class.product.php"
["line"]=>
int(530)
["function"]=>
string(7) "dbQuery"
["args"]=>
array(1) {
[0]=>
&string(87) "SELECT prc_id FROM shop_prices WHERE prc_prodID = GROUP BY prc_id ORDER BY prc_pos ASC"
}
}
[1]=>
array(7) {
["file"]=>
string(83) "/data/vhosts/boxbird.co.uk/httpdocs/admin/extensions/shop/classes/class.product.php"
["line"]=>
int(613)
["function"]=>
string(10) "get_prices"
["class"]=>
string(7) "product"
["object"]=>
object(product)#28 (51) {
["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"]=>
NULL
["expired"]=>
NULL
["available"]=>
NULL
["pos"]=>
NULL
["active"]=>
NULL
["vat"]=>
NULL
["featured"]=>
NULL
["featuredPos"]=>
NULL
["ship_choice"]=>
NULL
["shipping"]=>
NULL
["ship_selected"]=>
NULL
["ship_insurance"]=>
NULL
["thumbnail"]=>
NULL
["code"]=>
NULL
["unit_term"]=>
NULL
["option_label"]=>
NULL
["option2_label"]=>
NULL
["option3_label"]=>
NULL
["option4_label"]=>
NULL
["cost"]=>
NULL
["info_req"]=>
NULL
["info_label"]=>
NULL
["archived"]=>
NULL
["base_price"]=>
NULL
["base_sale_price"]=>
NULL
["size_req"]=>
NULL
["col_req"]=>
NULL
["option_req"]=>
NULL
["option2_req"]=>
NULL
["option3_req"]=>
NULL
["option4_req"]=>
NULL
["turnaround"]=>
NULL
["shipping_cat"]=>
NULL
["images"]=>
NULL
["stock"]=>
NULL
["trans_id"]=>
NULL
["lang":"product":private]=>
string(2) "en"
["sale_item"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[2]=>
array(7) {
["file"]=>
string(69) "/data/vhosts/boxbird.co.uk/httpdocs/includes/content-shop_product.php"
["line"]=>
int(97)
["function"]=>
string(17) "get_display_price"
["class"]=>
string(7) "product"
["object"]=>
object(product)#28 (51) {
["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"]=>
NULL
["expired"]=>
NULL
["available"]=>
NULL
["pos"]=>
NULL
["active"]=>
NULL
["vat"]=>
NULL
["featured"]=>
NULL
["featuredPos"]=>
NULL
["ship_choice"]=>
NULL
["shipping"]=>
NULL
["ship_selected"]=>
NULL
["ship_insurance"]=>
NULL
["thumbnail"]=>
NULL
["code"]=>
NULL
["unit_term"]=>
NULL
["option_label"]=>
NULL
["option2_label"]=>
NULL
["option3_label"]=>
NULL
["option4_label"]=>
NULL
["cost"]=>
NULL
["info_req"]=>
NULL
["info_label"]=>
NULL
["archived"]=>
NULL
["base_price"]=>
NULL
["base_sale_price"]=>
NULL
["size_req"]=>
NULL
["col_req"]=>
NULL
["option_req"]=>
NULL
["option2_req"]=>
NULL
["option3_req"]=>
NULL
["option4_req"]=>
NULL
["turnaround"]=>
NULL
["shipping_cat"]=>
NULL
["images"]=>
NULL
["stock"]=>
NULL
["trans_id"]=>
NULL
["lang":"product":private]=>
string(2) "en"
["sale_item"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[3]=>
array(4) {
["file"]=>
string(45) "/data/vhosts/boxbird.co.uk/httpdocs/index.php"
["line"]=>
int(137)
["args"]=>
array(1) {
[0]=>
string(69) "/data/vhosts/boxbird.co.uk/httpdocs/includes/content-shop_product.php"
}
["function"]=>
string(7) "include"
}
}