Shape 5

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=102

I'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/about

I 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.

Hello,

If you PM me back end Super User and FTP access we can take a closer look. However SQL errors are related to the database and a Template does not generate tables the same way a Site Shaper does. It just adds some styling sheets to the website.

Regards,

I had my tech staff look into this. Adding a line to this file solved the problem.
./templates/Shape5_Spectrum_template_current/vertex/parameters.php

See graphic for instructions. Hopefully it can help others.

Hello,

Thanks I have forwarded this thread to our Vertex team for review.

Regards,

Hello,

Thank you for that information. I am a little confused, because that same code is already defined at line 31 of parameters.php, did your developer change anything else?

I ended up having another issue - the Vertex tab was missing to make the edits to the template.

I had my developer take another look and it turns out both issues were related to the template name.

When you unzip the template package, the folder is called "Shape5_Spectrum_template_current". You need to change the name to "spectrum", as that is the name called in various places within the template.

Hello,

The template doesn't control the name of the folder it's in as it doesn't sit in a folder in the zip. Everything is in the root of the zip file. The template name is “spectrum”, and that's defined in the templateDetails.xml. If you extracted it to a folder called “Shape5_Spectrum_template_current”, that's not the correct process and the issue would be with whatever programming your using to extract it with.

You do not need to extract a Template. They need to be installed via the extensions manager to work properly.