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'));
Labels |
Added:
?
|
||
Build | ⇒ | staging |
Error came up after installing Gantry with RokNavMenu, so not an Joomla-CMS issue.