[TYPO3-project-seminars] Problem with sorting according to date

Oliver Klee typo3-german-01 at oliverklee.de
Sat Mar 3 14:31:30 CET 2007


Hi Nico,

Nico Deblauwe schrieb:
> My configuration: Seminar Manager, version 0.4.8, MySQL server version:
> 4.1.21, PHP Version 4.4.4

For the upcoming release, we have included a patch that solves a problem
with MySQL < 5.x. Could you please try whether this change solves the
problem for you?

diff -urN seminars_old/class.tx_seminars_bag.php
seminars/class.tx_seminars_bag.php
--- seminars_old/class.tx_seminars_bag.php	Fri Jan 19 17:14:15 2007
+++ seminars/class.tx_seminars_bag.php	Fri Jan 19 17:32:56 2007
@@ -148,7 +148,7 @@
 		}

 		$this->dbResult =& $GLOBALS['TYPO3_DB']->exec_SELECTquery(
-			'DISTINCT '.$this->dbTableName.'.*',
+			$this->dbTableName.'.*',
 			$this->dbTableName.$this->additionalTableNames,
 			$this->queryParameters.$this->enabledFieldsQuery,
 			$this->groupBy,

(Practically, that's just removing the "DISTINCT" keyword.)

Regards,


Oliver


More information about the TYPO3-project-seminars mailing list