My site works fine on my previous custom template and all of the default Joomla templates. ONLY when using Shape5 templates do I get this error. I have tested with Spectrum and General Contractor (downloaded today) themes.
Full Error:
1064 - 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 alias = 'about'' at line 1 SQL=SELECT * FROM jos_menu WHERE template_style_id IN () AND alias = 'about'
I've tried setting Search Engine Friendly URLs and Use URL Rewriting to NO. This would be the sample URL:
http://www.website.com/index.php?option=com_content&view=article&id=2&Itemid=102I've tried setting Search Engine Friendly URLs and Use URL Rewriting to YES and rename htaccess.txt to .htaccess. This would be the sample URL:
http://www.website.com/aboutI have tried to "fix" the Database via the Joomla backend - nothing changes.
I get this error on all pages of the site, not just articles. I tried to create new menu items and new articles and they have the same issue.
I have unpublished all of the modules - still get the error.
I put the site on 2 different servers with different PHP and MySQL specs - still get the error.
MySQL 5.6.15 and PHP 5.4.23
MySQL 5.1.67 and PHP 5.3.21
Same error before and after Joomla upgrade. 3.3.6 to 3.4.3.
All cache is purged.
I see that other users have had the same issue and the only resolution has been to use Site Shaper. This is not an option for me. My site already has content in it and I don't want to start all over.
The Shape5 responses all say this is not a template issue, but there is obviously something different about your templates. All others work fine.
Please help me. Thank you in advance.