Migration fails on the PostgreSQL

samchen2009 / ekanban

a kanban plugin for redmine

102 stars 42 forks source link

Migration fails on the PostgreSQL #19

Open steals opened 11 years ago

steals commented 11 years ago

HI,

The migration is failed on the postgresql database:

PG::Error: ERROR: column "wip_limit" cannot be cast automatically to type boolean HINT: Specify a USING expression to perform the conversion. : ALTER TABLE "kanban_panes" ALTER COLUMN "wip_limit" TYPE boolean

But I have found a workaround: http://stackoverflow.com/questions/11276855/ror-cannot-change-column-in-postgres-fine-in-mysql-mysql-for-development-pos/11276990#11276990

Could you please fix.

samchen2009 commented 11 years ago

Thanks! I'll install postgreSQL and verify it. Before that, you can follow #7 as a workaround either.

sgalitsky commented 10 years ago

at this moment very simple workaround exists - comment out wip_limit related lines from db/migrate/013_fix_kanbanpane_wiplimit_type.rb and db/migrate/010_add_kanban_tables_options.rb before migration