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 30652 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: 1656
    • 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
Joomla 3.9.x Release Lead
Vote at JED

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: 1656
    • 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
Joomla 3.9.x Release Lead
Vote at JED