Query Error: Unknown column 'r' in 'where clause'
SQL: SELECT p.id, p.cname, t.filename AS contentfile,
l.templatefile AS layoutfile,
t.id AS template_id,
t.code
FROM pages p
INNER JOIN pageversions pv
ON pv.id = p.published_pageversions_id
INNER JOIN templates t
ON t.id = p.templates_id
INNER JOIN layouts l
ON l.id = t.layouts_id
WHERE p.isdeleted = 0
AND p.sites_id = '1'
AND p.languages_id = 1
AND p.url = 'templates/main/js/gulpified/'+r+'&qlt=45,0' Exception::__set_state(array(
'message' => 'Query Error:
SQL: SELECT p.id, p.cname, t.filename AS contentfile,
l.templatefile AS layoutfile,
t.id AS template_id,
t.code AS templatecode
FROM pages p
INNER JOIN pageversions pv ON pv.id = p.published_pageversions_id INNER JOIN templates t
ON t.id = p.templates_id
INNER JOIN layouts l
ON l.id = t.layouts_id
WHERE p.isdeleted = 0
AND p.sites_id = \'1\'
AND p.languages_id = 1
AND p.url = \'templates/main/js/gulpified/\'+r+\'&qlt=45,0\' ',
'string' => '',
'code' => 38387,
'file' => '/var/www/share/esite/classes/Db.Class.php',
'line' => 292,
'trace' =>
array (
0 =>
array (
'file' => '/var/www/html/mandarinoriental_com/trunk/classes/Navigation.Class.php',
'line' => 152,
'function' => 'Query',
'class' => 'Db',
'type' => '->',
'args' =>
array (
0 => 'SELECT p.id, p.cname, t.filename AS contentfile,
l.templatefile AS layoutfile,
t.id AS template_id,
t.code AS templatecode
FROM pages p
INNER JOIN pageversions pv ON pv.id = p.published_pageversions_id INNER JOIN templates t
ON t.id = p.templates_id
INNER JOIN layouts l
ON l.id = t.layouts_id
WHERE p.isdeleted = 0
AND p.sites_id = \'1\'
AND p.languages_id = 1
AND p.url = \'templates/main/js/gulpified/\'+r+\'&qlt=45,0\' ',
),
),
1 =>
array (
'file' => '/var/www/html/mandarinoriental_com/trunk/structure.php',
'line' => 60,
'function' => 'getStructureXml',
'class' => 'Navigation',
'type' => '->',
'args' =>
array (
0 => 1,
),
),
2 =>
array (
'file' => '/var/www/share/cde/branches/v1.8.4_chain/caliban.php',
'line' => 1313,
'args' =>
array (
0 => '/var/www/html/mandarinoriental_com/trunk/structure.php',
),
'function' => 'include',
),
3 =>
array (
'file' => '/var/www/share/cde/branches/v1.8.4_chain/caliban.php',
'line' => 301,
'function' => 'structure',
'class' => 'caliban',
'type' => '->',
'args' =>
array (
),
),
4 =>
array (
'file' => '/var/www/html/mandarinoriental_com/trunk/index.php',
'line' => 65,
'function' => 'caliban',
'class' => 'caliban',
'type' => '->',
'args' =>
array (
0 => '/var/www/html/mandarinoriental_com/trunk/index.php',
1 =>
array (
'prePath' => NULL,
'deviceHandling' => 1,
),
),
),
),
'previous' => NULL,
))