Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[d4rkbl4de]

Hi!

My client has just informed me that the latest news on their website doesn't switch any more despite being translated. I checked and indeed, it's all the news.

http://collegeacadieipe.ca/index.php/en

Do you have any idea what could cause this?

Version   
Library Version: 1.2.0
Joomla Version 3.3.3 is untested.

Plugin   
JDiction Plugin is enabled
Languagefilter is enabled

Database   
jDiction Database Driver is selected

Language   
Seam to be good

Module   
Module is enabled

[Harald Leithner]

You have a good chance that the attached version fixes the problem.

[d4rkbl4de]

Damn, when I install it, it gives me this 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 'ALTER TABLE `irhqx_jd_store` DROP INDEX `idLang` , ADD UNIQUE `idLang` ( `id' at line 2 SQL=ALTER TABLE `irhqx_jd_store` CHANGE `referenceTable` `referenceTable` VARCHAR( 67 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Table of the translation' ALTER TABLE `irhqx_jd_store` DROP INDEX `idLang` , ADD UNIQUE `idLang` ( `idLang` , `referenceTable` , `idReference` )

[Harald Leithner]

strange, anyway did the package install?
this only changes the index of the table that maybe already done.

[d4rkbl4de]

Sadly no. it's still version 1.2.0 :/

[Harald Leithner]

retry with the attached version, I know its same git hash but its another build

[d4rkbl4de]

Library Version: 1.2.9.3-git.2014f44
Joomla Version 3.3.3 is untested.

It did install! Now, when I try to switch in the news section, it gives me this 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 '9,10,11,12,13,14,15,16,17,18,19,20,224,225,226,234,237,238,239,240,241,242,243,2' at line 3 SQL=SELECT * FROM irhqx_jd_store WHERE idLang='1' AND referenceTable='#__content' AND idReference in (,9,10,11,12,13,14,15,16,17,18,19,20,224,225,226,234,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251)

However, the rest of the articles switch fine.

[Harald Leithner]

Ok, this shouldn't happen because it tries to preload an article without and ID...
please try the attached version.

[d4rkbl4de]

Aw, it doesn't show an error now BUT, it's still doing the same thing as initially - it just goes to the homepage of the opposite language, not the article. If you want the admin access, I can give you one.

[Harald Leithner]

thats another problem, this could happen if the "home" menu is a featured or category view and the article is not in a sub category...
it could take some time to fix this.

whats the type of the home entrY?

[d4rkbl4de]

Articles » Category Blog with the category News chosen
It is the news that are doing that bug too! :0

[Harald Leithner]

so the problem is only for news articles correct?

[d4rkbl4de]

Exactly!

[Harald Leithner]

I will try to solve this problem tomorrow local time is UTC+1

[Harald Leithner]

Fix is ready, it works for you I will release 1.3.0 today.