Defect #934

Unable to save a metadata with a LocaleChoice attribute on signle language catalog

Added by Blatti Yves almost 3 years ago. Updated almost 3 years ago.

Status:ClosedStart date:03/11/2015
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:CATALOG
Target version:4.3.1
Affected version:4.3.0

Description

If only a single (default) language is enabled on a catalog, and a LocalChoice is present in model, metadata save fails.

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 4
SQL=SELECT t.text2, `iso3166-1-alpha2` 
    FROM jos_sdi_translation t 
    INNER JOIN jos_sdi_language l ON l.id=t.language_id 
    WHERE t.element_guid = '517ee37c-ca15-00a4-c1e4-3f3f48ed5eb1' AND t.language_id IN () 

In \components\com_easysdi_catalog\controllers\metadata.php:1363 private function getI18nValue($guid)

History

#1 Updated by Blatti Yves almost 3 years ago

It is patched in my sandbox, but needs testing on a multilingual environment to avoid regression.

#2 Updated by Magoni Bruno almost 3 years ago

  • Assignee changed from Blatti Yves to Battaglia Marc
  • Target version set to 4.3.0

#3 Updated by Magoni Bruno almost 3 years ago

  • Target version changed from 4.3.0 to 4.3.1

#4 Updated by Villemagne Jérôme almost 3 years ago

  • Status changed from Affected to Resolved
  • Assignee changed from Battaglia Marc to Villemagne Jérôme

#5 Updated by Villemagne Jérôme almost 3 years ago

  • Status changed from Resolved to Closed
  • Assignee deleted (Villemagne Jérôme)

Also available in: Atom PDF