Created
January 13, 2018 15:51
-
-
Save cesswairimu/5ece8b30d3888e1bee68bacbbe996c55 to your computer and use it in GitHub Desktop.
SQLite3::SQLException: near "ENGINE": syntax error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- create_table("comments", {:primary_key=>"cid", :options=>"ENGINE=MyISAM"}) | |
| rake aborted! | |
| StandardError: An error has occurred, this and all later migrations canceled: | |
| SQLite3::SQLException: near "ENGINE": syntax error: CREATE TABLE "comments" ("cid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pid" integer DEFAULT 0 NOT NULL, "nid" integer DEFAULT 0 NOT NULL, "uid" integer DEFAULT 0 NOT NULL, "subject" varchar(64) DEFAULT '' NOT NULL, "comment" text(2147483647) NOT NULL, "hostname" varchar(128) DEFAULT '' NOT NULL, "timestamp" integer DEFAULT 0 NOT NULL, "status" integer(1) DEFAULT 0 NOT NULL, "format" integer(2) DEFAULT 0 NOT NULL, "thread" varchar(255) NOT NULL, "name" varchar(60), "mail" varchar(64), "homepage" varchar(255)) ENGINE=MyISAM/home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `initialize' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `new' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `prepare' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/sqlite3_adapter.rb:334:in `block in execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activesupport-4.1.16/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/sqlite3_adapter.rb:334:in `execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in `create_table' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:656:in `block in method_missing' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:628:in `block in say_with_time' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:628:in `say_with_time' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:648:in `method_missing' | |
| /home/cessito/code/plots2/db/migrate/20120101000000_drupal_schema.rb:4:in `up' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:605:in `exec_migration' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:586:in `block (2 levels) in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:585:in `block in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:584:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:759:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:1044:in `block in ddl_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/transactions.rb:208:in `transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:1044:in `ddl_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:997:in `execute_migration_in_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:959:in `block in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:955:in `each' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:955:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:814:in `up' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:792:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `eval' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `<main>' | |
| ActiveRecord::StatementInvalid: SQLite3::SQLException: near "ENGINE": syntax error: CREATE TABLE "comments" ("cid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pid" integer DEFAULT 0 NOT NULL, "nid" integer DEFAULT 0 NOT NULL, "uid" integer DEFAULT 0 NOT NULL, "subject" varchar(64) DEFAULT '' NOT NULL, "comment" text(2147483647) NOT NULL, "hostname" varchar(128) DEFAULT '' NOT NULL, "timestamp" integer DEFAULT 0 NOT NULL, "status" integer(1) DEFAULT 0 NOT NULL, "format" integer(2) DEFAULT 0 NOT NULL, "thread" varchar(255) NOT NULL, "name" varchar(60), "mail" varchar(64), "homepage" varchar(255)) ENGINE=MyISAM | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `initialize' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `new' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `prepare' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/sqlite3_adapter.rb:334:in `block in execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract_adapter.rb:378:in `block in log' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activesupport-4.1.16/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract_adapter.rb:372:in `log' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/sqlite3_adapter.rb:334:in `execute' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in `create_table' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:656:in `block in method_missing' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:628:in `block in say_with_time' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:628:in `say_with_time' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:648:in `method_missing' | |
| /home/cessito/code/plots2/db/migrate/20120101000000_drupal_schema.rb:4:in `up' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:605:in `exec_migration' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:586:in `block (2 levels) in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:585:in `block in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:584:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:759:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:998:in `block in execute_migration_in_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:1044:in `block in ddl_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `block in transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:209:in `within_new_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/connection_adapters/abstract/database_statements.rb:201:in `transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/transactions.rb:208:in `transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:1044:in `ddl_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:997:in `execute_migration_in_transaction' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:959:in `block in migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:955:in `each' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:955:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:814:in `up' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/migration.rb:792:in `migrate' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/gems/activerecord-4.1.16/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `eval' | |
| /home/cessito/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `<main>' | |
| SQLite3::SQLException: near "ENGINE": syntax error |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment