Chad Matsalla wrote: > Gretings! > > I see this as well. It's because this query: > SELECT COUNT(*) AS `mapCount` FROM `base2_dynamic`.`D320RawParents` `rawmap` > WHERE `rawmap`.`cube` = 3 GROUP BY `rawmap`.`column`, `rawmap`.`position` > ORDER BY COUNT(*) DESC > > should say: > SELECT COUNT(*) AS `mapCount` FROM `base2_dynamic`.`D320RawParents` `rawmap` > WHERE `rawmap`.`cube` = 3 GROUP BY `rawmap`.`column`, `rawmap`.`position` > ORDER BY mapCount DESC > > Hm. For mysql4, anyway.
It may be as you say, but I can't verify it since I don't have a MySQL 4 database. Strange that it complains about the GROUP BY clause when the error is in the ORDER BY clause. Anyway, 'ORDER BY mapCount' should work with MySQL 5 as well and it shouldn't be difficult to fix. I have added a ticket for it (http://base.thep.lu.se/ticket/581), but don't expect it to be fixed before the 2.4 release. In the meantime I think upgrading to MySQL 5.0 is the only option. /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]
