English > Install & Configure jDiction

ERROR 1064 with a category list item

(1/2) > >>

CarolynB:
Hello,
This plugin is absolutely amazing! I only have one issue I can not seem to resolve.
I get an 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 ')' at line 3 SQL=SELECT * FROM cirw6_jd_store WHERE idLang='4' AND referenceTable='#__content' AND idReference in ()"

This happens when I try to switch languges on a category list item.

Do you happen to know why this is happening?

Harald Leithner:
Thats really interesting because this should never happen.

would you please edit file /libraries/jdiction/jdiction.php in line 522 and add the following line before $this->getTranslation(....

var_dump(array($ids, $metadata, $table, $rows));

and post the output here or in an email

CarolynB:
Will try.

CarolynB:
We added the code. But the site still has the same issues. Do you need to see some debugging info from this code? I can message you with the login access. I am heading out for a couple hours but will be back later.

Harald Leithner:
Yes i would like to see the debug output

Navigation

[0] Message Index

[#] Next page

Go to full version