jDiction Forum

English => Install & Configure jDiction => Topic started by: Xtream on October 08, 2013, 11:38:59 am

Title: error - 1064 - You have an error in your SQL syntax
Post by: Xtream on October 08, 2013, 11:38:59 am
Hello
I first time install this component and can't understand where is a problem. I use Joomla 3.1.5 and jDiction 0.9.9.10, PHP 5.3.27

Info from Jdiction check:
Version   
Library Version: 0.9.9.10
Plugin   
JDiction Plugin is enabled
Languagefilter is enabled
Database   
jDiction Database Driver is selected
Language   
Seam to be good
Module   
Module is enabled

Published plugins: Language Filter, jDiction multilanguage package, jDiction content plugin

All language contents have public rights

Site works only with default language, but when I switch to another language (throw jdlanguage module) i receive next 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 'F, c.id AS JD_MAGIC_KEY_1, content.id AS JD_MAGIC_KEY_2 ROM piot5_categori' at line 3 SQL=SELECT c.id AS CID F, c.id AS JD_MAGIC_KEY_1, content.id AS JD_MAGIC_KEY_2 ROM piot5_categories AS c LEFT JOIN piot5_content AS content ON c.id = content.catid WHERE ( c.id = 8 ) AND c.extension = 'com_content' AND c.published = 1
Title: Re: error - 1064 - You have an error in your SQL syntax
Post by: Harald Leithner on October 08, 2013, 11:44:48 am
Do you have any custom components installed?
Title: Re: error - 1064 - You have an error in your SQL syntax
Post by: Xtream on October 08, 2013, 05:38:44 pm
Thanx for idea... after component/plugins/modules unpublished tests... problem is found.
It's News Show Pro GK5, when module is unpublished, translation works, when module is published on site is error 1064
Title: Re: error - 1064 - You have an error in your SQL syntax
Post by: Harald Leithner on October 08, 2013, 05:44:15 pm
The Component uses a query syntax that couldn't be correct decoded by jdiction:

Code: [Select]
AS JD_MAGIC_KEY_2 ROMjdiction cuts
Code: [Select]
FROM
So I think it falls back to parser mode and fails to parse... maybe you could ask the author to rewrite his query to use JDatabaseQuery.