?
avatar jdeproost
jdeproost
17 Jan 2013

This error occured when adding a menu item or a menu.
JLIB_DATABASE_QUERY_FAILED SQL=SELECT template FROM #__template_styles WHERE home = 1 AND client_id = 0

PHP Built On Windows NT 2JFVL4J-LI 6.1 build 7600 (Windows 7 Business Edition) i586
Database Version 9.2.2
PHP Version 5.4.7
Web Server Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.0.2 Stable [ Ember ] 08-November-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 12.2.0 Stable [ Neil Armstrong ] 21-September-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; rv:18.0) Gecko/20100101 Firefox/18.0

The SQL should be ... WHERE home = '1'...

Tracked it down to mod_roknavmenu

in modules/mod_roknavmenu/lib/RokNavMenu.php line 109
$query->where('home = 1');
should be
$query->where('home = ' . $db->quote('1'));

in modules/mod_roknavmenu/lib/RokNavMenu.php line 175
$query->where('client_id = 0 AND home = 1');
should be
$query->where('client_id = 0 AND home = ' . $db->quote('1'));
or
$query->where('client_id = 0);
$query->where('home = ' . $db->quote('1'));

avatar jdeproost jdeproost - open - 17 Jan 2013
avatar zero-24 zero-24 - close - 20 Feb 2013
avatar jdeproost jdeproost - close - 20 Feb 2013
avatar jdeproost
jdeproost - comment - 20 Feb 2013

Error came up after installing Gantry with RokNavMenu, so not an Joomla-CMS issue.

avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?
Build staging

Add a Comment

Login with GitHub to post a comment