Created
September 15, 2016 16:04
-
-
Save sebyx07/8365e315123e4450c2262a8f251c3d49 to your computer and use it in GitHub Desktop.
This file contains hidden or 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("upc_offers", {:id=>:bigint, :unsigned=>true, :force=>:cascade, :options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8"}) | |
| rake aborted! | |
| StandardError: An error has occurred, all later migrations canceled: | |
| Mysql2::Error: Invalid default value for 'updated_t': CREATE TABLE `upc_offers` (`id` bigint unsigned AUTO_INCREMENT PRIMARY KEY, `upc_details_id` bigint unsigned DEFAULT 0 NOT NULL, `merchant` varchar(100) DEFAULT '', `domain` varchar(100) DEFAULT '', `title` varchar(512) DEFAULT '', `currency` varchar(3) DEFAULT 'USD', `list_price` decimal(9,2) DEFAULT '0.0', `price` decimal(9,2) DEFAULT '0.0', `shipping` varchar(100) DEFAULT '', `condition` varchar(32) DEFAULT '', `availability` varchar(32) DEFAULT '', `link` varchar(512) DEFAULT '', `updated_t` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, INDEX `domain` USING btree (`domain`), INDEX `merchant` USING btree (`merchant`), INDEX `title` USING btree (`title`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `_query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `block in query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `handle_interrupt' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `query' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `block in execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' | |
| /usr/local/bundle/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/mysql/database_statements.rb:46:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:283:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:420:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:845:in `block in method_missing' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `block in say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:834:in `method_missing' | |
| /app/db/migrate/20160914184937_create_upc_offers.rb:4:in `change' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:788:in `exec_migration' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:771:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:770:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:950:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1281:in `ddl_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `each' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1298:in `with_advisory_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1005:in `up' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:983:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/tasks/database_tasks.rb:161:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' | |
| /usr/local/bundle/gems/rake-11.2.2/exe/rake:27:in `<top (required)>' | |
| ActiveRecord::StatementInvalid: Mysql2::Error: Invalid default value for 'updated_t': CREATE TABLE `upc_offers` (`id` bigint unsigned AUTO_INCREMENT PRIMARY KEY, `upc_details_id` bigint unsigned DEFAULT 0 NOT NULL, `merchant` varchar(100) DEFAULT '', `domain` varchar(100) DEFAULT '', `title` varchar(512) DEFAULT '', `currency` varchar(3) DEFAULT 'USD', `list_price` decimal(9,2) DEFAULT '0.0', `price` decimal(9,2) DEFAULT '0.0', `shipping` varchar(100) DEFAULT '', `condition` varchar(32) DEFAULT '', `availability` varchar(32) DEFAULT '', `link` varchar(512) DEFAULT '', `updated_t` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, INDEX `domain` USING btree (`domain`), INDEX `merchant` USING btree (`merchant`), INDEX `title` USING btree (`title`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `_query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `block in query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `handle_interrupt' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `query' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `block in execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' | |
| /usr/local/bundle/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/mysql/database_statements.rb:46:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:283:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:420:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:845:in `block in method_missing' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `block in say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:834:in `method_missing' | |
| /app/db/migrate/20160914184937_create_upc_offers.rb:4:in `change' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:788:in `exec_migration' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:771:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:770:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:950:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1281:in `ddl_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `each' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1298:in `with_advisory_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1005:in `up' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:983:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/tasks/database_tasks.rb:161:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' | |
| /usr/local/bundle/gems/rake-11.2.2/exe/rake:27:in `<top (required)>' | |
| Mysql2::Error: Invalid default value for 'updated_t' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `_query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:107:in `block in query' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `handle_interrupt' | |
| /usr/local/bundle/gems/mysql2-0.4.4/lib/mysql2/client.rb:106:in `query' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `block in execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' | |
| /usr/local/bundle/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:218:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/mysql/database_statements.rb:46:in `execute' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:283:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:420:in `create_table' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:845:in `block in method_missing' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `block in say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:814:in `say_with_time' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:834:in `method_missing' | |
| /app/db/migrate/20160914184937_create_upc_offers.rb:4:in `change' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:788:in `exec_migration' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:772:in `block (2 levels) in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:771:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:770:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:950:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1211:in `block in execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1281:in `ddl_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1210:in `execute_migration_in_transaction' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1183:in `block in migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `each' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1182:in `migrate_without_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `block in migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1298:in `with_advisory_lock' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1131:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:1005:in `up' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/migration.rb:983:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/tasks/database_tasks.rb:161:in `migrate' | |
| /usr/local/bundle/gems/activerecord-5.0.0.1/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>' | |
| /usr/local/bundle/gems/rake-11.2.2/exe/rake:27:in `<top (required)>' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment