ruby-on-rails – Mysql2 ::错误：PRIMARY KEY的所有部分必须为N

发布时间：2020-12-16 21:16:42 所属栏目：百科来源：网络整理

导读：我在rails 3.2.9和 ruby versiion 2.0.0中创建了一个演示应用程序.脚手架Blog模型后我试图迁移它,但有以下问题. # rake db:migrate == CreateBlogs: migrating ==================================================== — create_table(:blogs) rake aborted!

我在rails 3.2.9和 ruby versiion 2.0.0中创建了一个演示应用程序.脚手架Blog模型后我试图迁移它,但有以下问题.

# rake db:migrate

== CreateBlogs: migrating ====================================================

— create_table(:blogs)
rake aborted!

StandardError: An error has occurred,all later migrations canceled:

Mysql2::Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key,use UNIQUE instead: CREATE TABLE blogs (id int(11) DEFAULT NULL auto_increment PRIMARY KEY,title varchar(255),description text,created_at datetime NOT NULL,updated_at datetime NOT NULL) ENGINE=InnoDB
/usr/local/rvm/gems/ruby-2.0.0-p648@demo-app/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in query' /usr/local/rvm/gems/ruby-2.0.0-p648@demo-app/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:inblock in execute’
/usr/local/rvm/gems/ruby-2.0.0-p648@demo-app/gems/activerecord-

….

-3.2.9/lib/active_record/migration.rb:551:in migrate' /usr/local/rvm/gems/ruby-2.0.0-p648@demo-app/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:179:inblock (2 levels) in ‘
/usr/local/rvm/gems/ruby-2.0.0-p648@demo-app/gems/rake-11.3.0/exe/rake:27:in `’
Tasks: TOP => db:migrate
(See full trace by running task with –trace)

解决方法

配置/初始化/ abstract_mysql2_adapter.rb

require 'active_record/connection_adapters/mysql2_adapter'

class ActiveRecord::ConnectionAdapters::Mysql2Adapter
  NATIVE_DATABASE_TYPES[:primary_key] = "int(11) auto_increment PRIMARY KEY"
end

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!