English > Install & Configure jDiction

Error 1064

(1/2) > >>

JCEF:
Hi, looked on the site but didn't see a solution.  After setting the database driver to use JDiction_mysqli, I get the following error on any of the translated pages (the originals still work fine): 

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 ' c.id AS JD_MAGIC_KEY_1 jos_content c WHERE c.id='86'' at line 4 SQL=SELECT c.id as id, c.title as title, c.metakey as metakeywords, c.metadesc as metadescription FROM , c.id AS JD_MAGIC_KEY_1 jos_content c WHERE c.id='86'


The check page reports the following:

Test    Result
 
Version    

    Library Version: 0.9.9.11

Plugin    

    JDiction Plugin is enabled
    Languagefilter is enabled
    Multiple Plugins have the same loading position (0)

Database    

    jDiction Database Driver is selected

Language    

    Seam to be good

Module    

    Module is enabled


Here's where it gets even more strange, my home page (which uses the same template, but a few different modules) displays normally, on both language settings.  However I tried unpublishing literally every assigned module on a test page I created that was not also published on the homepage, and it did not fix the problem.  I'm pretty much out of ideas at this point.  Is there any help to be had?  I'm trying to get the rest of this site translated by Wednesday. 

Harald Leithner:
Please upgrade to the latest version

JCEF:
Ok I'll give it a try.  Where can I find instructions for that, and are there any Joomla compatibility issues I'll need to watch out for during the process?

JCEF:
Nevermind on that last part.  Updated jDiction.  Still have the issue.  check page now says: 

Test    Result
 
Version    

    Library Version: 1.1.0
    Joomla Version 3.2.0 is ok.

Plugin    

    JDiction Plugin is enabled
    Languagefilter is enabled
    Multiple Plugins have the same loading position (0)

Database    

    jDiction Database Driver is selected

Language    

    Seam to be good

Module    

    Module is enabled

Common mistakes    

    At least one content item has the language set not to ALL.
    The default editor is not tinymce, jDiction does only support tinymce at the moment.

Harald Leithner:
Latest version is 1.2.0

Navigation

[0] Message Index

[#] Next page

Go to full version