Forum Support

Shape 5
March 28, 2024, 03:26:44 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: 1064 - You have an error in your SQL syntax  (Read 847 times)
jackied
Jr. Member
**
Offline Offline

Posts: 5



« 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
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #1 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

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
jackied
Jr. Member
**
Offline Offline

Posts: 5



« Reply #2 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
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #3 on: July 31, 2015, 01:02:23 PM »

Hello,

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

Regards,
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #4 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

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
jackied
Jr. Member
**
Offline Offline

Posts: 5



« Reply #5 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
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #6 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

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
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.