Forum Support

 
Advanced Search


[1]

Offline jackied
Free Member
Posts: 5
Posted on: July 29, 2015, 01:33:45 PM

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

Offline mikenicoll
Free Member
Posts: 20162 WWW
Posted on: July 29, 2015, 05:27:08 PM

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,
Logged

Offline jackied
Free Member
Posts: 5
Posted on: July 31, 2015, 12:18:23 PM

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

Offline mikenicoll
Free Member
Posts: 20162 WWW
Posted on: July 31, 2015, 01:02:23 PM

Hello,

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

Regards,
Logged

Offline mikek
Free Member
Posts: 28743 WWW
Posted on: July 31, 2015, 03:03:10 PM

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?
Logged

Offline jackied
Free Member
Posts: 5
Posted on: August 12, 2015, 12:33:50 PM

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

Offline mikenicoll
Free Member
Posts: 20162 WWW
Posted on: August 12, 2015, 11:23:31 PM

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.
« Last Edit: August 14, 2015, 01:51:15 AM by mikenicoll »
Logged
[1]

Jump to:  


Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Page created in 0.025 seconds with 22 queries.
Need some help getting your site up and running? Be sure to check out our tutorials area, post on the forum or hire us
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.