Skip to content

Instantly share code, notes, and snippets.

@lalithr95
Created March 26, 2016 16:25
Show Gist options
  • Save lalithr95/a6983fb099494e080a4c to your computer and use it in GitHub Desktop.
Save lalithr95/a6983fb099494e080a4c to your computer and use it in GitHub Desktop.
sqlite3 trace
== DrupalSchema: migrating ===================================================
-- table_exists?("comments")
-> 0.0003s
-- 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
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `initialize'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `new'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `prepare'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:134:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `block in execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.22.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:170:in `create_table'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:466:in `block in method_missing'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `block in say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:458:in `method_missing'
/Users/Lalith/plots2/db/migrate/20120101000000_drupal_schema.rb:4:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:389:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:528:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:720:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `call'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `block in ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/transactions.rb:208:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:719:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `each'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:570:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:551:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'
/Users/Lalith/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `eval'
/Users/Lalith/.rvm/gems/ruby-2.1.2/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
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `initialize'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `new'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `prepare'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:134:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `block in execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.22.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:170:in `create_table'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:466:in `block in method_missing'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `block in say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:458:in `method_missing'
/Users/Lalith/plots2/db/migrate/20120101000000_drupal_schema.rb:4:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:389:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:528:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:720:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `call'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `block in ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/transactions.rb:208:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:719:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `each'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:570:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:551:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'
/Users/Lalith/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `eval'
/Users/Lalith/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `<main>'
SQLite3::SQLException: near "ENGINE": syntax error
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `initialize'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `new'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:91:in `prepare'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/sqlite3-1.3.11/lib/sqlite3/database.rb:134:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `block in execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activesupport-3.2.22.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/sqlite_adapter.rb:278:in `execute'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:170:in `create_table'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:466:in `block in method_missing'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `block in say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:438:in `say_with_time'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:458:in `method_missing'
/Users/Lalith/plots2/db/migrate/20120101000000_drupal_schema.rb:4:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:410:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:389:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:528:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:720:in `block (2 levels) in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `call'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `block in ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/transactions.rb:208:in `transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:775:in `ddl_transaction'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:719:in `block in migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `each'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:700:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:570:in `up'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/migration.rb:551:in `migrate'
/Users/Lalith/.rvm/gems/ruby-2.1.2/gems/activerecord-3.2.22.2/lib/active_record/railties/databases.rake:193:in `block (2 levels) in <top (required)>'
/Users/Lalith/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `eval'
/Users/Lalith/.rvm/gems/ruby-2.1.2/bin/ruby_executable_hooks:15:in `<main>'
Tasks: TOP => db:migrate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment