jDiction Forum
English => Install & Configure jDiction => Topic started by: CarolynB on July 22, 2014, 04:36:58 pm
-
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?
-
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
-
Will try.
-
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.
-
Yes i would like to see the debug output
-
I sent you a message with the login credentials.
-
I fixed to independent bugs for the same query. One that makes troubles only with the menu and one that prevents translation of queries with no primary key and only one select column.
You have now the current git version.
I didn't found the SQL Error where can I find it?
-
The error is with the support video, top menu, submenu to Technical Support. But with the German translation. The English is fine.
https://dealers.cadlink.com/index.php/de/technischer-support/support-videos.
The error is with each of those category lists. German.
-
So, funny that this was not triggered before. I fixed a problem where tables quotes has no primary key.
I also released 1.2.9.2.
Thx for letting me debug that on your system.
-
Awesome! It works great!!! Thank you so much!!