首页 文章

ActiveRecord :: StatementInvalid:Mysql2 :: Error:Unknown collation:'utf8_0900_ai_ci'

提问于
浏览
0

我是一个新手,试图通过使用ROR版本5.0和mysql 8.02的Lynda视频系列来学习ruby on rails . 在DB> migrate> model.rb文件中创建表条目并运行“rails db:migrate”后,我在终端中收到一个错误的错误 . iv使用不同的用户并使用mysql特权并在网上搜索但没有运气 .

=============================

class CreateUsers <ActiveRecord :: Migration [5.0]

def up create_table:用户做| t |

t.column "first_name", :string, :limit => 25
    t.string "last_name", :limit => 50
    t.string "email", :default => '', :null => false
    t.string "password", :limit => 40

  t.timestamps
end

结束

贬低

drop_table :users

结束

结束

MBP:simple_cms $ rails db:migrate rails aborted! ActiveRecord的:: StatementInvalid:Mysql2 ::错误:未知归类:'utf8_0900_ai_ci':CREATE TABLE schema_migrationsversion VARCHAR(255)COLLATE utf8_0900_ai_ci PRIMARY KEY)ENGINE = InnoDB的/Users/.rvm/gems/ruby-2.3.0/gems/mysql2- 0.4.9 / lib / mysql2 / client.rb:112:在查询'/Users/.rvm/gems/ruby-2.3.0/gems/mysql2-0.4.9/lib/mysql2/client.rb中的 _query' /Users/.rvm/gems/ruby-2.3.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:120:in 块中: 119:在 handle_interrupt' /Users/.rvm/gems/ruby-2.3.0/gems/mysql2-0.4.9/lib/mysql2/client.rb:119:in 查询 '/Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in block in execute' /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:590:in 块在日志'/用户/ . rvm / gems / ruby-2.3.0 / gems / activesupport-5.0.6 / lib / active_support / notifications / instrumenter.rb:21:in instrument' /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:583:in log'/Users/.rvm/gems/ruby-2.3.0/gems/了activerecord-5.0.6 / LIB / active_record / connection_adapters / abstract_mysql_adapter.rb:218:在 execute' /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/mysql/database_statements.rb:31:in 执行” /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/ abstract / schema_statements.rb:278:in create_table' /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:423:in create_table'/Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/act ive_record / schema_migration.rb:27:in create_table' /Users/.rvm/gems/ruby-2.3.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:1008:in initialize_schema_migrations_table'

1 回答

  • 0

    您的问题存在问题:https://github.com/rails/rails/issues/28730

    这已在 rails v5.1.0.rc2 中修复 . 升级到最新版本并重新生成 schema.rb 应该可以解决您的问题 .

相关问题