Changeset 661 for trunk/Modules/Translation/TranslationList.php

Timestamp:

Dec 20, 2013, 2:43:59 PM (11 years ago)

Author:

maron

Message:

• Fixed: Error in query filtering

File:

• trunk/Modules/Translation/TranslationList.php (modified) (2 diffs)

trunk/Modules/Translation/TranslationList.php

@@ -146 +146 @@
                                         '(`Sub`.`Language` <> '.$this->System->Config['OriginalLanguage'].')'.$LanguageFilter.
                                         ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`ID` != `T`.`ID`) AND (`Sub`.`Complete` = 1) AND '.
-                                        '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
+                                        '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`) LIMIT 1 ) ';
                                 foreach($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
                                 if($GroupItem['Visible'] == 1) {
@@ -153 +153 @@
                                           'SELECT LENGTH(`Sub`.`'.$GroupItem['Column'].'`) - LENGTH( REPLACE( `Sub`.`'.$GroupItem['Column'].'`,  \'$\',  \'\' ) ) FROM `'.$Table.'` AS `Sub` WHERE '.
                                                                         ' `Sub`.`Entry` = `T`.`Entry` AND `Sub`.`Language` = '.$this->System->Config['OriginalLanguage'].' AND '.
-                                                                        '`Sub`.`VersionStart` = `T`.`VersionStart` AND `Sub`.`VersionEnd` = `T`.`VersionEnd`'.
+                                                                        '`Sub`.`VersionStart` = `T`.`VersionStart` AND `Sub`.`VersionEnd` = `T`.`VersionEnd` LIMIT 1 '.
                               ')';
                       }