Changeset 661

Timestamp:

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

Author:

maron

Message:

• Fixed: Error in query filtering

Location:

trunk

Files:

• Modules/Translation/TranslationList.php (modified) (2 diffs)
• includes/Version.php (modified) (1 diff)

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 '.
                               ')';
                       }

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 660; // Subversion revision
+$Revision = 661; // Subversion revision
 $DatabaseRevision = 646; // Database structure revision 
 $ReleaseTime = '2013-12-20';