Time taken: 4.00543212891E-5
Backtrace:array(4) {
[0]=>
array(7) {
["file"]=>
string(53) "/home/wallcann/public_html/classes/class.database.php"
["line"]=>
int(267)
["function"]=>
string(5) "debug"
["class"]=>
string(2) "db"
["type"]=>
string(2) "->"
["object"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(116) "SELECT *,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(8)
["time_taken"]=>
NULL
}
["args"]=>
array(3) {
[0]=>
&string(116) "SELECT *,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
[1]=>
&string(160) "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 ') ORDER BY lft' at line 1"
[2]=>
&float(4.00543212891E-5)
}
}
[1]=>
array(7) {
["file"]=>
string(51) "/home/wallcann/public_html/classes/preorder.inc.php"
["line"]=>
int(71)
["function"]=>
string(6) "select"
["class"]=>
string(2) "db"
["type"]=>
string(2) "->"
["object"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(116) "SELECT *,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(8)
["time_taken"]=>
NULL
}
["args"]=>
array(4) {
[0]=>
&string(37) "*,node.id,node.lft,node.rgt,node.name"
[1]=>
&string(11) "cat as node"
[2]=>
&string(35) "shop_id=18 AND (lft BETWEEN 1 AND )"
[3]=>
&string(3) "lft"
}
}
[2]=>
array(7) {
["file"]=>
string(37) "/home/wallcann/public_html/global.php"
["line"]=>
int(517)
["function"]=>
string(21) "getSubordinates_speed"
["class"]=>
string(8) "preorder"
["type"]=>
string(2) "->"
["object"]=>
object(preorder)#9 (8) {
["db:private"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(116) "SELECT *,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(8)
["time_taken"]=>
NULL
}
["table:private"]=>
string(3) "cat"
["name:private"]=>
string(4) "name"
["id:private"]=>
string(2) "id"
["left:private"]=>
string(3) "lft"
["right:private"]=>
string(3) "rgt"
["parent:private"]=>
string(9) "parent_id"
["shop_id:private"]=>
int(18)
}
["args"]=>
array(3) {
[0]=>
&int(115)
[1]=>
&array(1) {
[0]=>
string(1) "*"
}
[2]=>
&string(0) ""
}
}
[3]=>
array(4) {
["file"]=>
string(47) "/home/wallcann/public_html/product-list-alt.php"
["line"]=>
int(20)
["args"]=>
array(1) {
[0]=>
string(37) "/home/wallcann/public_html/global.php"
}
["function"]=>
string(7) "include"
}
}
Error Returned: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 ') ORDER BY lft' at line 1
Query Used:
SELECT *,node.id,node.lft,node.rgt,node.name
FROM cat as node
WHERE shop_id=18 AND (lft BETWEEN 1 AND )
ORDER BY lft
Time taken: 3.981590271E-5
Backtrace:array(3) {
[0]=>
array(7) {
["file"]=>
string(53) "/home/wallcann/public_html/classes/class.database.php"
["line"]=>
int(267)
["function"]=>
string(5) "debug"
["class"]=>
string(2) "db"
["type"]=>
string(2) "->"
["object"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(137) "SELECT section,name,path,top5,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(11)
["time_taken"]=>
NULL
}
["args"]=>
array(3) {
[0]=>
&string(137) "SELECT section,name,path,top5,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
[1]=>
&string(160) "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 ') ORDER BY lft' at line 1"
[2]=>
&float(3.981590271E-5)
}
}
[1]=>
array(7) {
["file"]=>
string(51) "/home/wallcann/public_html/classes/preorder.inc.php"
["line"]=>
int(71)
["function"]=>
string(6) "select"
["class"]=>
string(2) "db"
["type"]=>
string(2) "->"
["object"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(137) "SELECT section,name,path,top5,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(11)
["time_taken"]=>
NULL
}
["args"]=>
array(4) {
[0]=>
&string(58) "section,name,path,top5,node.id,node.lft,node.rgt,node.name"
[1]=>
&string(11) "cat as node"
[2]=>
&string(35) "shop_id=18 AND (lft BETWEEN 1 AND )"
[3]=>
&string(3) "lft"
}
}
[2]=>
array(7) {
["file"]=>
string(47) "/home/wallcann/public_html/product-list-alt.php"
["line"]=>
int(77)
["function"]=>
string(21) "getSubordinates_speed"
["class"]=>
string(8) "preorder"
["type"]=>
string(2) "->"
["object"]=>
object(preorder)#9 (8) {
["db:private"]=>
object(db)#2 (10) {
["server"]=>
string(9) "localhost"
["username"]=>
string(13) "wallcare_shop"
["password"]=>
string(10) "gh5672sfgh"
["database"]=>
string(13) "wallcare_shop"
["connection"]=>
resource(20) of type (mysql link)
["query"]=>
string(137) "SELECT section,name,path,top5,node.id,node.lft,node.rgt,node.name FROM cat as node WHERE shop_id=18 AND (lft BETWEEN 1 AND ) ORDER BY lft"
["error"]=>
string(160) "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 ') ORDER BY lft' at line 1"
["debug"]=>
int(0)
["query_count"]=>
int(11)
["time_taken"]=>
NULL
}
["table:private"]=>
string(3) "cat"
["name:private"]=>
string(4) "name"
["id:private"]=>
string(2) "id"
["left:private"]=>
string(3) "lft"
["right:private"]=>
string(3) "rgt"
["parent:private"]=>
string(9) "parent_id"
["shop_id:private"]=>
int(18)
}
["args"]=>
array(2) {
[0]=>
&int(115)
[1]=>
&array(4) {
[0]=>
string(7) "section"
[1]=>
string(4) "name"
[2]=>
string(4) "path"
[3]=>
string(4) "top5"
}
}
}
}
Error Returned: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 ') ORDER BY lft' at line 1
Query Used:
SELECT section,name,path,top5,node.id,node.lft,node.rgt,node.name
FROM cat as node
WHERE shop_id=18 AND (lft BETWEEN 1 AND )
ORDER BY lft