Bug in MySQL Query for integrity migrate_db (gem version 0.1.10)
Reported by Björn Grossmann | June 9th, 2009 @ 07:56 PM
When I run integrity migrate_db using a mysql database, I get the following:
bjoern@myserver:/home/bjoern# integrity migrate_db
/var/www/integrity/config.yml
== Performing Up Migration #1: initial CREATE TABLE
integrity_projects ENGINE = InnoDB CHARACTER SET utf8
COLLATE utf8_general_ci (id serial PRIMARY KEY,
name VARCHAR(50) NOT NULL, permalink
VARCHAR(50), uri VARCHAR NOT NULL DEFAULT NULL,
branch VARCHAR(50) NOT NULL DEFAULT 'master',
command VARCHAR(50) NOT NULL DEFAULT 'rake',
public TINYINT DEFAULT 1, building
TINYINT DEFAULT 0, created_at DATETIME,
updated_at DATETIME, build_id INT(11),
notifier_id INT(11))
/opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/adapters/data_objects_adapter.rb:92:in
execute_non_query': (mysql_errno=1064, sql_state=42000) 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
'idserial PRIMARY KEY,nameVARCHAR(50) NOT
NULL,permalinkVARCHAR(50),' at line 1
(MysqlError) Query: CREATE TABLE integrity_projects
ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
(id serial PRIMARY KEY, name VARCHAR(50)
NOT NULL, permalink VARCHAR(50), uri
VARCHAR NOT NULL DEFAULT NULL, branch VARCHAR(50) NOT
NULL DEFAULT 'master', command VARCHAR(50) NOT NULL
DEFAULT 'rake', public TINYINT DEFAULT 1,
building TINYINT DEFAULT 0, created_at
DATETIME, updated_at DATETIME, build_id
INT(11), notifier_id INT(11))
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/adapters/data_objects_adapter.rb:92:in `execute'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/adapters/data_objects_adapter.rb:173:in `with_connection'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/adapters/data_objects_adapter.rb:90:in `execute'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-migrations-0.9.11/lib/migration.rb:85:in `execute'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-migrations-0.9.11/lib/migration.rb:138:in `say_with_time'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/1.8/benchmark.rb:293:in `measure'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-migrations-0.9.11/lib/migration.rb:138:in `say_with_time'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/dm-migrations-0.9.11/lib/migration.rb:84:in `execute'
... 16 levels...
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/thor-0.9.9/lib/thor.rb:78:in `start'
from /opt/ruby-enterprise-1.8.6-20090201/lib/ruby/gems/1.8/gems/foca-integrity-0.1.9.3/bin/integrity:4
from /opt/ruby-enterprise-1.8.6-20090201/bin/integrity:19:in `load'
from /opt/ruby-enterprise-1.8.6-20090201/bin/integrity:19
Comments and changes to this ticket
-
Simon Rozet June 11th, 2009 @ 10:39 AM
- State changed from “new” to “dupe”
- Tag changed from “mysql, query” to “mysql”
dupe of #92
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Automated continuous integration server that doesn't suck.
Björn Grossmann
Simon Rozet