array(10) {
[0]=>
array(6) {
["file"]=>
string(66) "/var/www/webroot/ROOT/webshop/services/service.DatabaseService.php"
["line"]=>
int(45)
["function"]=>
string(14) "_InternalQuery"
["class"]=>
string(15) "DatabaseService"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
string(1123) "SELECT
DISTINCT k.id AS kleurid,
c.id AS productid,
c.ean,
c.afbeelding1 AS kleurimage,
c.seourl,
k.kleurcode,
k.kleurnaam AS kleurnaam,
pg.naam AS model,
k.kleurnaam AS kleurnaam,
pg.seonaam AS modelnaam,
m.naam AS merknaam,
IF(s.prijsvan > 0, s.prijsvan, c.standaardvanprijs) AS prijsvan,
IF(s.prijsvoor > 0, s.prijsvoor, c.standaardvoorprijs) AS prijsvoor
FROM art_Content AS c
LEFT JOIN art_KleurMatches AS km ON km.ean=c.ean
LEFT JOIN art_Stock AS s ON s.productid=c.ean
LEFT JOIN art_Merken AS m ON c.merk=m.id
LEFT JOIN art_Kleurenhoofdgroep AS k ON k.id=c.kleur
LEFT JOIN art_producthoofdgroep AS pg ON pg.id=c.model
WHERE km.patroon = '15-235920 Polo's' AND
c.productcode != '21408-1015'"
}
}
[1]=>
array(6) {
["file"]=>
string(65) "/var/www/webroot/ROOT/webshop/services/service.ProductKleuren.php"
["line"]=>
int(181)
["function"]=>
string(5) "Query"
["class"]=>
string(15) "DatabaseService"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
string(1123) "SELECT
DISTINCT k.id AS kleurid,
c.id AS productid,
c.ean,
c.afbeelding1 AS kleurimage,
c.seourl,
k.kleurcode,
k.kleurnaam AS kleurnaam,
pg.naam AS model,
k.kleurnaam AS kleurnaam,
pg.seonaam AS modelnaam,
m.naam AS merknaam,
IF(s.prijsvan > 0, s.prijsvan, c.standaardvanprijs) AS prijsvan,
IF(s.prijsvoor > 0, s.prijsvoor, c.standaardvoorprijs) AS prijsvoor
FROM art_Content AS c
LEFT JOIN art_KleurMatches AS km ON km.ean=c.ean
LEFT JOIN art_Stock AS s ON s.productid=c.ean
LEFT JOIN art_Merken AS m ON c.merk=m.id
LEFT JOIN art_Kleurenhoofdgroep AS k ON k.id=c.kleur
LEFT JOIN art_producthoofdgroep AS pg ON pg.id=c.model
WHERE km.patroon = '15-235920 Polo's' AND
c.productcode != '21408-1015'"
}
}
[2]=>
array(6) {
["file"]=>
string(61) "/var/www/webroot/ROOT/webshop/classes/class.ProductPagina.php"
["line"]=>
int(96)
["function"]=>
string(27) "MaakOverzichtProductKleuren"
["class"]=>
string(14) "ProductKleuren"
["type"]=>
string(2) "::"
["args"]=>
array(8) {
[0]=>
string(1) "4"
[1]=>
string(10) "21408-1015"
[2]=>
string(2) "15"
[3]=>
string(50) "Gabbiano 235920 polo's Poloshirts 55556 mint green"
[4]=>
string(50) "Gabbiano 235920 polo's Poloshirts 55556 mint green"
[5]=>
string(1) "2"
[6]=>
string(5) "15483"
[7]=>
string(14) "ProductPagina."
}
}
[3]=>
array(6) {
["file"]=>
string(66) "/var/www/webroot/ROOT/webshop/templates/template.ProductPagina.php"
["line"]=>
int(2)
["function"]=>
string(26) "MaakOverzichtProductPagina"
["class"]=>
string(13) "ProductPagina"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
string(9) "175038470"
}
}
[4]=>
array(4) {
["file"]=>
string(66) "/var/www/webroot/ROOT/webshop/services/service.TemplateBuilder.php"
["line"]=>
int(435)
["args"]=>
array(1) {
[0]=>
string(66) "/var/www/webroot/ROOT/webshop/templates/template.ProductPagina.php"
}
["function"]=>
string(7) "require"
}
[5]=>
array(7) {
["file"]=>
string(66) "/var/www/webroot/ROOT/webshop/services/service.TemplateBuilder.php"
["line"]=>
int(48)
["function"]=>
string(13) "_KiesTemplate"
["class"]=>
string(15) "TemplateBuilder"
["object"]=>
object(TemplateBuilder)#8 (1) {
["_TemplateNaamSanitized"]=>
string(0) ""
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(9) "175038470"
}
}
[6]=>
array(7) {
["file"]=>
string(66) "/var/www/webroot/ROOT/webshop/services/service.TemplateBuilder.php"
["line"]=>
int(31)
["function"]=>
string(9) "_MakePage"
["class"]=>
string(15) "TemplateBuilder"
["object"]=>
object(TemplateBuilder)#8 (1) {
["_TemplateNaamSanitized"]=>
string(0) ""
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[7]=>
array(7) {
["file"]=>
string(61) "/var/www/webroot/ROOT/webshop/classes/class.BuildTemplate.php"
["line"]=>
int(15)
["function"]=>
string(11) "__construct"
["class"]=>
string(15) "TemplateBuilder"
["object"]=>
object(TemplateBuilder)#8 (1) {
["_TemplateNaamSanitized"]=>
string(0) ""
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(0) ""
}
}
[8]=>
array(7) {
["file"]=>
string(61) "/var/www/webroot/ROOT/webshop/classes/class.BuildTemplate.php"
["line"]=>
int(11)
["function"]=>
string(13) "_ToonTemplate"
["class"]=>
string(13) "BuildTemplate"
["object"]=>
object(BuildTemplate)#6 (1) {
["_TemplateNaam"]=>
NULL
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(0) ""
}
}
[9]=>
array(7) {
["file"]=>
string(39) "/var/www/webroot/ROOT/webshop/index.php"
["line"]=>
int(33)
["function"]=>
string(11) "__construct"
["class"]=>
string(13) "BuildTemplate"
["object"]=>
object(BuildTemplate)#6 (1) {
["_TemplateNaam"]=>
NULL
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
}
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 's' AND
c.productcode != '21408-1015'' at line 21 SQL Query: SELECT
DISTINCT k.id AS kleurid,
c.id AS productid,
c.ean,
c.afbeelding1 AS kleurimage,
c.seourl,
k.kleurcode,
k.kleurnaam AS kleurnaam,
pg.naam AS model,
k.kleurnaam AS kleurnaam,
pg.seonaam AS modelnaam,
m.naam AS merknaam,
IF(s.prijsvan > 0, s.prijsvan, c.standaardvanprijs) AS prijsvan,
IF(s.prijsvoor > 0, s.prijsvoor, c.standaardvoorprijs) AS prijsvoor
FROM art_Content AS c
LEFT JOIN art_KleurMatches AS km ON km.ean=c.ean
LEFT JOIN art_Stock AS s ON s.productid=c.ean
LEFT JOIN art_Merken AS m ON c.merk=m.id
LEFT JOIN art_Kleurenhoofdgroep AS k ON k.id=c.kleur
LEFT JOIN art_producthoofdgroep AS pg ON pg.id=c.model
WHERE km.patroon = '15-235920 Polo's' AND
c.productcode != '21408-1015'