IF Chamber
) [message] => Unable to process query [SELECT node.parent_id, (COUNT(parent.parent_id) -1) AS depth FROM pages AS node, pages AS parent WHERE node.id = AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.deleted = 0 GROUP BY node.parent_id ORDER BY node.lft;] Error Number: 1064 with the message : 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 'AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.' at line 4 [type] => Exception ) ) 1
Exception: Unable to process query [SELECT node.parent_id, (COUNT(parent.parent_id) -1) AS depth FROM pages AS node, pages AS parent WHERE node.id = AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.deleted = 0 GROUP BY node.parent_id ORDER BY node.lft;] Error Number: 1064 with the message : 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 'AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.' at line 4
( ! ) Exception: Unable to process query [SELECT node.parent_id, (COUNT(parent.parent_id) -1) AS depth FROM pages AS node, pages AS parent WHERE node.id = AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.deleted = 0 GROUP BY node.parent_id ORDER BY node.lft;] Error Number: 1064 with the message : 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 'AND node.lft BETWEEN parent.lft AND parent.rgt AND node.deleted = 0 AND parent.' at line 4 in /home/ifchamb/public_html/cms/helpers/db/mysql.php on line 37
Call Stack
#TimeMemoryFunctionLocation
10.000587820{main}( )../index.php:0
20.21564083872Controller_Page->after( )../index.php:44
30.23154332676CMS_DO_Page->GetDepth( )../page.php:20
40.23164332892CMS_DO_Base->GetDepth( )../page.php:220
50.23194333880DB_MySql->execute( )../base.php:1502