[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