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 with a category list item  (Read 15106 times)

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
ERROR 1064 with a category list item
« 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?
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #1 on: July 22, 2014, 05:01:17 pm »
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
Logged
Joomla! 5.0 Release Manager
Vote at JED

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #2 on: July 22, 2014, 05:03:44 pm »
Will try.
Logged

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #3 on: July 22, 2014, 06:21:35 pm »
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.
« Last Edit: July 22, 2014, 06:32:03 pm by CarolynB »
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #4 on: July 22, 2014, 07:21:29 pm »
Yes i would like to see the debug output
Logged
Joomla! 5.0 Release Manager
Vote at JED

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #5 on: July 22, 2014, 11:35:22 pm »
I sent you a message with the login credentials.
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #6 on: July 23, 2014, 12:15:29 pm »
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?
Logged
Joomla! 5.0 Release Manager
Vote at JED

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #7 on: July 23, 2014, 01:30:57 pm »
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.
« Last Edit: July 23, 2014, 01:34:17 pm by CarolynB »
Logged

Harald Leithner

  • Administrator
  • Hero Member
  • *****
  • Posts: 1688
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #8 on: July 23, 2014, 04:35:04 pm »
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.
Logged
Joomla! 5.0 Release Manager
Vote at JED

CarolynB

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: ERROR 1064 with a category list item
« Reply #9 on: July 23, 2014, 06:41:15 pm »
Awesome! It works great!!! Thank you so much!!
Logged