Re: [base] GROUP clause error
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]
[base] GROUP clause error
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. Any ideas on how this can be repaired for people who are bound to mysql4? Chad Matsalla - 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]
[base] GROUP clause error
We are using BASE 2.2.1 and Mysql Ver 14.7 distrib 4.1.12 Gauthier Jean-Pierre. Bio-informatique. INRA. UMR BIO3P. Domaine de la Motte. BP. 35327. 35653 LE RHEU CEDEX. tel : 33(0)2.23.48.51.68 fax : 33(0)2.23.48.51.50 mail : [EMAIL PROTECTED] - 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]
Re: [base] GROUP clause error
Jean-Pierre Gauthier wrote: We are using BASE 2.2.1 and Mysql Ver 14.7 distrib 4.1.12 We have only tested BASE with MySQL 5.0. Can you upgrade and check if it works? I think it may be a problem with the older MySQL version. Unfortunately, we can't support anything before 5.0 and I don't think MySQL supports the older versions either. By the way, I think that 4.1.12 is the real MySQL version. The 14.7 is probably something internal to your operating system which probably comes bundled with MySQL. /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]
[base] GROUP clause error
Hi BASErs, I think I have all well done by importing my data files and reporters . But when I try to create a root bioassy set, all seems to work well (Base say: calculating spot intensities: 10 of 12 raw bioassay(s) done). same pb with 1 or 2... raw bioassay And then error: Invalid use of GROUP clause ... Has somebody seen this problem? Thanks Here is the log. net.sf.basedb.core.BaseException: Utilisation invalide de la clause GROUP at net.sf.basedb.core.AbstractSqlQuery.iterate(AbstractSqlQuery.java:193) at net.sf.basedb.core.DataCube.countSpotMappings(DataCube.java:682) at net.sf.basedb.core.DataCube.onBeforeCommit(DataCube.java:171) at net.sf.basedb.core.DbControl.commit(DbControl.java:365) at net.sf.basedb.plugins.IntensityCalculatorPlugin.run(IntensityCalculatorPlugin.java:261) at net.sf.basedb.core.PluginExecutionRequest.invoke(PluginExecutionRequest.java:88) at net.sf.basedb.core.InternalJobQueue$JobRunner.run(InternalJobQueue.java:420) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Utilisation invalide de la clause GROUP at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3176) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.basedb.core.AbstractSqlQuery.iterate(AbstractSqlQuery.java:184) ... 7 more Job parameters Experimentlsd_experiment FormulaMean FG Bioassay set nameNew bioassayset Raw bioassaysh1ld_cy3, h1ld_cy5, h1sd_cy3, h1sd_cy5, h2ld_cy3, h2ld_cy5, h2sd_cy3, h2sd_cy5, h3ld_cy3, h3ld_cy5, h3sd_cy3, h3sd_cy5 Gauthier Jean-Pierre. Bio-informatique. INRA. UMR BIO3P. Domaine de la Motte. BP. 35327. 35653 LE RHEU CEDEX. tel : 33(0)2.23.48.51.68 fax : 33(0)2.23.48.51.50 mail : [EMAIL PROTECTED] - 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]