DB Query Error SELECT PI.*,
IF( IFNULL( next_delivery_confirmed, 0 ) = 0 OR ROUND( DATEDIFF( next_delivery, now() ) / 7 + 0.5 , 0) < 0 OR next_delivery IS NULL,
NULL,
ROUND( DATEDIFF( next_delivery, now() ) / 7 + 0.5 , 0)
) as weeks
FROM 3ppp3_products_inventory PI
WHERE PI.product = '313240'
AND LOWER(PI.country) = LOWER('CH') Can't find file: '3ppp3_products_inventory' (errno: 2)
array(4) {
[0]=>
array(7) {
["file"]=>
string(55) "/var/www/clients/client34/web111/web/products_class.php"
["line"]=>
int(421)
["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(484) "SELECT PI.*,
IF( IFNULL( next_delivery_confirmed, 0 ) = 0 OR ROUND( DATEDIFF( next_delivery, now() ) / 7 + 0.5 , 0) < 0 OR next_delivery IS NULL,
NULL,
ROUND( DATEDIFF( next_delivery, now() ) / 7 + 0.5 , 0)
) as weeks
FROM 3ppp3_products_inventory PI
WHERE PI.product = '313240'
AND LOWER(PI.country) = LOWER('CH')"
}
}
[1]=>
array(7) {
["file"]=>
string(58) "/var/www/clients/client34/web111/web/templates/product.php"
["line"]=>
int(462)
["function"]=>
string(12) "availability"
["class"]=>
string(15) "ProductsGrouped"
["object"]=>
object(ProductsGrouped)#16 (7) {
["languageID":"ProductsGrouped":private]=>
string(1) "1"
["currencyID":"ProductsGrouped":private]=>
string(1) "1"
["countryID":"ProductsGrouped":private]=>
string(1) "1"
["printerID":"ProductsGrouped":private]=>
NULL
["categoryID":"ProductsGrouped":private]=>
NULL
["storage":"ProductsGrouped":private]=>
object(DB)#2 (1) {
["db_handle"]=>
resource(2) of type (mysql link)
}
["countryISO"]=>
string(2) "CH"
}
["type"]=>
string(2) "->"
["args"]=>
array(3) {
[0]=>
&string(6) "313240"
[1]=>
&string(0) ""
[2]=>
&string(1) "1"
}
}
[2]=>
array(4) {
["file"]=>
string(56) "/var/www/clients/client34/web111/web/templates/index.php"
["line"]=>
int(55)
["args"]=>
array(1) {
[0]=>
string(58) "/var/www/clients/client34/web111/web/templates/product.php"
}
["function"]=>
string(7) "include"
}
[3]=>
array(4) {
["file"]=>
string(48) "/var/www/clients/client34/web111/web/handler.php"
["line"]=>
int(844)
["args"]=>
array(1) {
[0]=>
string(56) "/var/www/clients/client34/web111/web/templates/index.php"
}
["function"]=>
string(7) "include"
}
}
|