English > Install & Configure jDiction

error - 1064 - You have an error in your SQL syntax

(1/1)

Xtream:
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

Harald Leithner:
Do you have any custom components installed?

Xtream:
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

Harald Leithner:
The Component uses a query syntax that couldn't be correct decoded by jdiction:


--- Code: ---AS JD_MAGIC_KEY_2 ROM
--- End code ---
jdiction cuts

--- Code: ---FROM
--- End code ---

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.

Navigation

[0] Message Index

Go to full version