From: <sy...@us...> - 2008-01-21 03:01:37
|
Update of /cvsroot/tikiwiki/tiki/lib/trackers In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv9475/lib/trackers Modified Files: Tag: BRANCH-1-10 trackerlib.php Log Message: [FIX]tracker: useless part of the query that was putting mysql 4.4.7 (ok with 5) into a loop Index: trackerlib.php =================================================================== RCS file: /cvsroot/tikiwiki/tiki/lib/trackers/trackerlib.php,v retrieving revision 1.231.2.20 retrieving revision 1.231.2.21 diff -u -d -r1.231.2.20 -r1.231.2.21 --- trackerlib.php 18 Jan 2008 22:26:12 -0000 1.231.2.20 +++ trackerlib.php 21 Jan 2008 03:01:25 -0000 1.231.2.21 @@ -539,10 +539,9 @@ if ( substr($sort_mode, 0, 2) == 'f_' ) { list($a, $asort_mode, $corder) = split('_', $sort_mode); $csort_mode = 'sttif.`value` '; - $sort_tables = ' LEFT JOIN (`tiki_tracker_item_fields` sttif, `tiki_tracker_fields` sttf)' + $sort_tables = ' LEFT JOIN (`tiki_tracker_item_fields` sttif)' .' ON (tti.`itemId` = sttif.`itemId`' ." AND sttif.`fieldId` = $asort_mode" - .' AND sttf.`fieldId` = sttif.`fieldId`' .')'; } else { list($csort_mode, $corder) = split('_', $sort_mode); |