{"action":"created","issue":{"url":"https://api.github.com/repos/decko-commons/decko/issues/160","repository_url":"https://api.github.com/repos/decko-commons/decko","labels_url":"https://api.github.com/repos/decko-commons/decko/issues/160/labels{/name}","comments_url":"https://api.github.com/repos/decko-commons/decko/issues/160/comments","events_url":"https://api.github.com/repos/decko-commons/decko/issues/160/events","html_url":"https://github.com/decko-commons/decko/issues/160","id":296412199,"number":160,"title":"decko seed on postgresql generates errors","user":{"login":"tukanos","id":731154,"avatar_url":"https://avatars2.githubusercontent.com/u/731154?v=4","gravatar_id":"","url":"https://api.github.com/users/tukanos","html_url":"https://github.com/tukanos","followers_url":"https://api.github.com/users/tukanos/followers","following_url":"https://api.github.com/users/tukanos/following{/other_user}","gists_url":"https://api.github.com/users/tukanos/gists{/gist_id}","starred_url":"https://api.github.com/users/tukanos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tukanos/subscriptions","organizations_url":"https://api.github.com/users/tukanos/orgs","repos_url":"https://api.github.com/users/tukanos/repos","events_url":"https://api.github.com/users/tukanos/events{/privacy}","received_events_url":"https://api.github.com/users/tukanos/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-02-12T15:20:29Z","updated_at":"2018-02-14T20:51:27Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Hi Ethan,\r\n\r\nI have tried to deploy the Decko on postgresql but got error when performing \"decko seed\".\r\n\r\nIt appears that the 1ENGINE=InnoDB DEFAULT1 alias Mysql is hardcoded.  Is there a trick for it to be deployed on Postgresql?\r\n\r\nHere is the error:\r\n\r\n```\r\n[smalltalk@localhost test_postgresql]$ decko seed -p\r\nenv RAILS_ENV=production bundle exec rake decko:seed\r\nDatabase 'production-database' already exists\r\nrake aborted!\r\nActiveRecord::StatementInvalid: PG::SyntaxError: ERROR:  syntax error at or near \"ENGINE\"\r\nLINE 1: ...n_type\" integer, \"draft\" boolean, \"comment\" text) ENGINE=Inn...\r\n                                                             ^\r\n: CREATE TABLE \"card_actions\" (\"id\" serial NOT NULL PRIMARY KEY, \"card_id\" integer, \"card_act_id\" integer, \"super_action_id\" integer, \"action_type\" integer, \"draft\" boolean, \"comment\" text) ENGINE=InnoDB DEFAULT CHARSET=utf8\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `async_exec'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `block (2 levels) in execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:72:in `block in execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:71:in `execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:849:in `block in method_missing'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `block in say_with_time'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `say_with_time'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:838:in `method_missing'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/card-1.93.8/db/schema.rb:15:in `block in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:48:in `instance_eval'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:48:in `define'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:44:in `define'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/card-1.93.8/db/schema.rb:13:in `<top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `block in load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:233:in `load_schema'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:255:in `block in load_schema_current'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:304:in `block in each_current_configuration'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:303:in `each'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:303:in `each_current_configuration'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:254:in `load_schema_current'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:248:in `block (3 levels) in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/decko-0.3.8/lib/decko/tasks/decko.rake:119:in `seed'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/decko-0.3.8/lib/decko/tasks/decko.rake:17:in `block (2 levels) in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/rake-12.3.0/exe/rake:27:in `<top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `eval'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `<main>'\r\n\r\nCaused by:\r\nPG::SyntaxError: ERROR:  syntax error at or near \"ENGINE\"\r\nLINE 1: ...n_type\" integer, \"draft\" boolean, \"comment\" text) ENGINE=Inn...\r\n                                                             ^\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `async_exec'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `block (2 levels) in execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:72:in `block in execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:71:in `execute'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:288:in `create_table'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:849:in `block in method_missing'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `block in say_with_time'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `say_with_time'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:838:in `method_missing'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/card-1.93.8/db/schema.rb:15:in `block in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:48:in `instance_eval'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:48:in `define'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/schema.rb:44:in `define'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/card-1.93.8/db/schema.rb:13:in `<top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `block in load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:258:in `load_dependency'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activesupport-5.1.4/lib/active_support/dependencies.rb:286:in `load'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:233:in `load_schema'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:255:in `block in load_schema_current'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:304:in `block in each_current_configuration'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:303:in `each'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:303:in `each_current_configuration'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:254:in `load_schema_current'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:248:in `block (3 levels) in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/decko-0.3.8/lib/decko/tasks/decko.rake:119:in `seed'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/decko-0.3.8/lib/decko/tasks/decko.rake:17:in `block (2 levels) in <top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/gems/rake-12.3.0/exe/rake:27:in `<top (required)>'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `eval'\r\n/home/smalltalk/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in `<main>'\r\nTasks: TOP => db:schema:load\r\n(See full trace by running task with --trace)\r\nnot dropped\r\ncreating\r\nloading schema\r\n-- create_table(\"card_actions\", {:id=>:integer, :force=>:cascade, :options=>\"ENGINE=InnoDB DEFAULT CHARSET=utf8\"})\r\n```\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/decko-commons/decko/issues/comments/365741083","html_url":"https://github.com/decko-commons/decko/issues/160#issuecomment-365741083","issue_url":"https://api.github.com/repos/decko-commons/decko/issues/160","id":365741083,"user":{"login":"ethn","id":21904,"avatar_url":"https://avatars1.githubusercontent.com/u/21904?v=4","gravatar_id":"","url":"https://api.github.com/users/ethn","html_url":"https://github.com/ethn","followers_url":"https://api.github.com/users/ethn/followers","following_url":"https://api.github.com/users/ethn/following{/other_user}","gists_url":"https://api.github.com/users/ethn/gists{/gist_id}","starred_url":"https://api.github.com/users/ethn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ethn/subscriptions","organizations_url":"https://api.github.com/users/ethn/orgs","repos_url":"https://api.github.com/users/ethn/repos","events_url":"https://api.github.com/users/ethn/events{/privacy}","received_events_url":"https://api.github.com/users/ethn/received_events","type":"User","site_admin":false},"created_at":"2018-02-14T20:51:27Z","updated_at":"2018-02-14T20:51:27Z","author_association":"COLLABORATOR","body":"Wow, thanks for all this.  I know that the installation instructions on wagn.org are a bit of a mess; this will be a huge help in updating them.\r\n\r\nRe postgres versions, our continuous integration tests (on Semaphore) start with a fresh copy of the latest code using `--database=postgresql` and update the gem bundle, so this means it is using the latest version of the pg gem.  I'm not sure what version of postgres it uses, honestly. I'll have to dig into to figure out what those version numbers are; it's not something we tweak much. It occurs to me I'll need to be systematic about this for us to be able to keep the README current.\r\n\r\nRe config/database.yml, you would really only need to add a lot more there if you wanted to work on decko code and run your code in many different environments (test, develop, etc). \"profile\" is just another of those environments; one optimized for doing performance profiling of the code.  If you really do want these environments, the easiest way to see an example of a database.yml that does that is to create a new \"core-dev\" deck with `decko new --core-dev mydeckname`.\r\n\r\nThe more important thing for getting wagn performing well in production is getting going with memcached. I think you broached that topic in another issue, but the key link is wagn.org/wagn_in_production.\r\n\r\n"}}
{"actor":{"display_login":"ethn"}}