[Bioperl-l] type=MyISAM

[Lincoln Stein]

With respect to Bio::DB::GFF being broken on new mysql installations, I
could replace TYPE with ENGINE and this would fix newer MySQLs while
breaking older ones. I will simply remove the declaration and accept the
default.

Lincoln

On Thu, Mar 31, 2011 at 6:59 PM, Scott Cain <scott at scottcain.net> wrote:

> Hi Lincoln,
>
> It appears that having "type=MyISAM" in the table definitions for
> newer MySQL instances is a problem, as I get this when I try to create
> a Bio::DB::GFF database:
>
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'type=MyISAM' at line 6 at
> /Library/Perl/5.8.8/Bio/DB/GFF/Adaptor/dbi.pm line 1049.
>
> Should we change that, or is there a way to get newer mysql servers to
> accept it as is?
>
> Thanks,
> Scott
>
>
> --
> ------------------------------------------------------------------------
> Scott Cain, Ph. D.                                   scott at scottcain dot
> net
> GMOD Coordinator (http://gmod.org/)                     216-392-3087
> Ontario Institute for Cancer Research
>



-- 
Lincoln D. Stein
Director, Informatics and Biocomputing Platform
Ontario Institute for Cancer Research
101 College St., Suite 800
Toronto, ON, Canada M5G0A3
416 673-8514
Assistant: Renata Musa <Renata.Musa at oicr.on.ca>