[ensembl-dev] Ensembl code and MySQL 5.5
Matthew Astley
mca at sanger.ac.uk
Fri Sep 6 13:59:15 BST 2013
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
More information about the Dev
mailing list