[base] GROUP clause error

2007-04-20 Thread Jean-Pierre Gauthier
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 GR

[base] GROUP clause error

2007-04-23 Thread Jean-Pierre Gauthier
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] --

[base] GROUP clause error

2007-04-30 Thread Chad Matsalla
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`.

Re: [base] GROUP clause error

2007-04-20 Thread Nicklas Nordborg
Jean-Pierre Gauthier wrote: > 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... ra

Re: [base] GROUP clause error

2007-04-23 Thread Nicklas Nordborg
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 thin

Re: [base] GROUP clause error

2007-05-02 Thread Nicklas Nordborg
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(