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(*) AS

[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

[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]

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 think

[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