[ensembl-dev] Ensembl code and MySQL 5.5

[Will Chow]

Thanks Matthew for the tip, I believe this could be a possible cause.

Will



On 6 Sep 2013, at 13:59, Matthew Astley <mca at sanger.ac.uk> wrote:

> On Fri, Sep 06, 2013 at 12:13:28PM +0100, Will Chow wrote:
> 
>> Has anyone used the Ensembl schema with MySQL 5.5 and had any
>> issues?
> 
> We have for a month or two, and I think we've had no problems or code
> changes.
> 
>> The reason I'm asking is I'm having issues with the ensembl webcode
>> for writing user configurations into the user tables via
>> DBSQL/ConfigAdaptor.pm
>> 
>>  $dbh->do(
>>    'INSERT INTO configuration_details VALUES ("", ?, ?, "n", ?, ?, ?, ?, ?)', {},
>>    map(encode_entities($args{$_}) || '', qw(record_type record_type_id name description)), $self->servername, $self->site_type, $self->version
>>  );
>> 
>> In 5.1, inserting ("", ?, ?, "n", ?, ?, ?, ?, ?), where the first
>> item is an "int" and a primary key, will work.  It'll spit out some
>> warnings in that "" is not an integer but it will work and insert
>> the row.  In 5.5, this is not allowed, and will spit out an error,
>> so no user config details will be written.
> 
> Has your configuration of sql_mode changed?
> 
>  http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html
> 
> I'm not sure it'll cause this, but it sounds like a strictness issue.
> -- 
> Matthew
> 
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/