search

foradian / fluxday

A user-friendly, free & opensource task & productivity management tool for growing startups
http://fluxday.io/
Apache License 2.0
476 stars 174 forks source link

Issue with Rake db:migrate #59

Closed jquiyula closed 5 years ago

jquiyula commented 5 years ago

Caused by: Mysql2::Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/mysql2-0.3.21/lib/mysql2/client.rb:80:in _query' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/mysql2-0.3.21/lib/mysql2/client.rb:80:inblock in query' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/mysql2-0.3.21/lib/mysql2/client.rb:79:in handle_interrupt' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/mysql2-0.3.21/lib/mysql2/client.rb:79:inquery' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:287:in block in execute' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_adapter.rb:435:inblock in log' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activesupport-4.0.3/lib/active_support/notifications/instrumenter.rb:20:in instrument' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_adapter.rb:430:inlog' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:287:in execute' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/mysql2_adapter.rb:222:inexecute' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:190:in create_table' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:471:increate_table' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:625:in block in method_missing' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:597:inblock in say_with_time' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:597:in say_with_time' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:617:inmethod_missing' /home/ec2-user/fluxday/db/migrate/20140313044626_create_projects.rb:3:in change' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:571:inexec_migration' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:555:in block (2 levels) in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:554:inblock in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in with_connection' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:553:inmigrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:709:in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:959:inblock in execute_migration_in_transaction' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:1007:in ddl_transaction' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:958:inexecute_migration_in_transaction' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:920:in block in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:916:ineach' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:916:in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:764:inup' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/migration.rb:742:in migrate' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/activerecord-4.0.3/lib/active_record/railties/databases.rake:42:inblock (2 levels) in <top (required)>' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/gems/rake-12.3.2/exe/rake:27:in <top (required)>' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/bin/ruby_executable_hooks:24:ineval' /home/ec2-user/.rvm/gems/ruby-2.1.0@fluxday/bin/ruby_executable_hooks:24:in `

'

jquiyula commented 5 years ago

I am connected to AWS RDS MySQL Engine version 5.7.17

jquiyula commented 5 years ago

I was able to fix the Issue.

I created a file under /config/initializers called abstract_mysql_adapter.rb with the following code:

require 'active_record/connection_adapters/mysql2_adapter' class ActiveRecord::ConnectionAdapters::Mysql2Adapter NATIVE_DATABASE_TYPES[:primary_key] = "int(11) auto_increment PRIMARY KEY" end