jDiction Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

jDiction 2.2.0 released. http://jdiction.org/downloads

Author Topic: error - 1064 - You have an error in your SQL syntax  (Read 17752 times)

Xtream

  • Newbie
  • *
  • Posts: 13
    • View Profile
error - 1064 - You have an error in your SQL syntax
« 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
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1619
    • View Profile
Re: error - 1064 - You have an error in your SQL syntax
« Reply #1 on: October 08, 2013, 11:44:48 am »

Do you have any custom components installed?
Logged

Xtream

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: error - 1064 - You have an error in your SQL syntax
« Reply #2 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
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1619
    • View Profile
Re: error - 1064 - You have an error in your SQL syntax
« Reply #3 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.
Logged