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]