[ensembl-dev] Ensembl code and MySQL 5.5

[Matthew Astley]

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