search

vmware-archive / projectmonitor

Big Visible Chart CI aggregator
http://ci.pivotallabs.com
BSD 2-Clause "Simplified" License
428 stars 120 forks source link

DB migration fail #39

Closed tomersh closed 10 years ago

tomersh commented 10 years ago

20130404153158_add_iteration_story_state_counts_to_projects.rb fails to run on mysql: Mysql::Error: BLOB/TEXT column 'iteration_story_state_counts' can't have a default value: ALTER TABLE projects ADD iteration_story_state_counts text DEFAULT '{}'/Users/administrator/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:286:in `query'

gsiener commented 10 years ago

Hi @tomersh, sorry this migration is failing. We typically use Project Monitor with Postgres, but we do strive to be db agnostic. I'll take a look and update when we resolve this.

gsiener commented 10 years ago

https://www.pivotaltracker.com/story/show/60080522

ryanmoran commented 10 years ago

This just landed on master: https://github.com/pivotal/projectmonitor/commit/592af5dcb1d5eed8cad24c374213c9386c74c481

Let us know how this works out.