DB Query Error
SELECT
LOWER( vP.brand ) AS brand,
vP.inkContent as fillQuantity,
IF( "peach" = vP.brand, "1", "2" ) AS presort,
CONCAT(pd.name,
IF(IFNULL(vP.oemId, "")<>"", CONCAT(" ", vP.oemId), ""),
IF(IFNULL(vP.oemBrand, "")<>"", CONCAT(" ", vP.oemBrand), "")) as name,
pp.price as priceLocalInCents,
vP.id as product,
LOWER( PK.product_type ) AS type,
vP.yield,
vP.group as categoryID
FROM 3ppp3_products vP
INNER JOIN fotocharlyat_products ps
ON ps.id = vP.id
AND ps.country = "3"
INNER JOIN 3ppp3_products_descriptions pd
ON vP.id = pd.product
AND pd.language = "1"
INNER JOIN 3ppp3_models_products MP
ON MP.product = vP.id
INNER JOIN 3ppp3_products_inventory PI
ON PI.product = vP.id
AND PI.country = "AT"
INNER JOIN 3ppp3_products_prices pp
ON pp.product = vP.id
AND pp.currency = "2"
INNER JOIN 3ppp3_products_khkdaten PK
ON PK.id = vP.id
LEFT JOIN (SELECT product, sum(quantity) as components FROM 3ppp3_products_components GROUP BY product) v
ON vP.id = v.product
WHERE MP.model = "1454"
ORDER BY presort, IFNULL(v.components, 0) DESC, vP.priority, vP.id
LIMIT 0,50
Can't find file: '3ppp3_products_inventory' (errno: 2)
array(3) {
[0]=>
array(7) {
["file"]=>
string(55) "/var/www/clients/client34/web111/web/products_class.php"
["line"]=>
int(79)
["function"]=>
string(8) "DB_query"
["class"]=>
string(2) "DB"
["object"]=>
object(DB)#2 (1) {
["db_handle"]=>
resource(2) of type (mysql link)
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&string(1654) "
SELECT
LOWER( vP.brand ) AS brand,
vP.inkContent as fillQuantity,
IF( "peach" = vP.brand, "1", "2" ) AS presort,
CONCAT(pd.name,
IF(IFNULL(vP.oemId, "")<>"", CONCAT(" ", vP.oemId), ""),
IF(IFNULL(vP.oemBrand, "")<>"", CONCAT(" ", vP.oemBrand), "")) as name,
pp.price as priceLocalInCents,
vP.id as product,
LOWER( PK.product_type ) AS type,
vP.yield,
vP.group as categoryID
FROM 3ppp3_products vP
INNER JOIN fotocharlyat_products ps
ON ps.id = vP.id
AND ps.country = "3"
INNER JOIN 3ppp3_products_descriptions pd
ON vP.id = pd.product
AND pd.language = "1"
INNER JOIN 3ppp3_models_products MP
ON MP.product = vP.id
INNER JOIN 3ppp3_products_inventory PI
ON PI.product = vP.id
AND PI.country = "AT"
INNER JOIN 3ppp3_products_prices pp
ON pp.product = vP.id
AND pp.currency = "2"
INNER JOIN 3ppp3_products_khkdaten PK
ON PK.id = vP.id
LEFT JOIN (SELECT product, sum(quantity) as components FROM 3ppp3_products_components GROUP BY product) v
ON vP.id = v.product
WHERE MP.model = "1454"
ORDER BY presort, IFNULL(v.components, 0) DESC, vP.priority, vP.id
LIMIT 0,50"
}
}
[1]=>
array(7) {
["file"]=>
string(55) "/var/www/clients/client34/web111/web/products_class.php"
["line"]=>
int(27)
["function"]=>
string(11) "getProducts"
["class"]=>
string(15) "ProductsGrouped"
["object"]=>
object(ProductsGrouped)#15 (12) {
["languageID":"ProductsGrouped":private]=>
string(1) "1"
["currencyID":"ProductsGrouped":private]=>
string(1) "2"
["countryID":"ProductsGrouped":private]=>
string(1) "3"
["printerID":"ProductsGrouped":private]=>
string(4) "1454"
["categoryID":"ProductsGrouped":private]=>
int(1)
["storage":"ProductsGrouped":private]=>
object(DB)#2 (1) {
["db_handle"]=>
resource(2) of type (mysql link)
}
["countryISO"]=>
string(2) "AT"
["printerName"]=>
string(28) "HP Business InkJet 1200"
["printerBrand"]=>
string(2) "HP"
["printerModelgroup"]=>
string(15) "Business InkJet"
["printerSeparator"]=>
string(6) " "
["printerModel"]=>
string(4) "1200"
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[2]=>
array(7) {
["file"]=>
string(48) "/var/www/clients/client34/web111/web/handler.php"
["line"]=>
int(1383)
["function"]=>
string(14) "getProductList"
["class"]=>
string(15) "ProductsGrouped"
["object"]=>
object(ProductsGrouped)#15 (12) {
["languageID":"ProductsGrouped":private]=>
string(1) "1"
["currencyID":"ProductsGrouped":private]=>
string(1) "2"
["countryID":"ProductsGrouped":private]=>
string(1) "3"
["printerID":"ProductsGrouped":private]=>
string(4) "1454"
["categoryID":"ProductsGrouped":private]=>
int(1)
["storage":"ProductsGrouped":private]=>
object(DB)#2 (1) {
["db_handle"]=>
resource(2) of type (mysql link)
}
["countryISO"]=>
string(2) "AT"
["printerName"]=>
string(28) "HP Business InkJet 1200"
["printerBrand"]=>
string(2) "HP"
["printerModelgroup"]=>
string(15) "Business InkJet"
["printerSeparator"]=>
string(6) " "
["printerModel"]=>
string(4) "1200"
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
&string(4) "1454"
[1]=>
&int(1)
}
}
}