Actions
Defect #2526
closed103_set_custom_fields_editable.rb and Sqlite3 support
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2009-01-18
Due date:
% Done:
0%
Estimated time:
Resolution:
Fixed
Affected version:
Description
Here is my script/about and the problem I found trying to run a db:migrate on latest r2277 :
# ruby script/about About your application's environment Ruby version 1.8.6 (i686-linux) RubyGems version 1.3.1 Rails version 2.1.2 Active Record version 2.1.2 Action Pack version 2.1.2 Active Resource version 2.1.2 Action Mailer version 2.1.2 Active Support version 2.1.2 Application root /my/super/path/redmine/r2277 Environment development Database adapter sqlite3 Database schema version 102 # rake db:migrate (in /my/super/path/redmine/r2277) == 103 SetCustomFieldsEditable: migrating ===================================== rake aborted! SQLite3::SQLException: no such column: false: UPDATE "custom_fields" SET editable = false WHERE ( ("custom_fields"."type" = 'UserCustomField' ) )
My Sqlite version is 3.3.8. Replacing "true"/"false" by "1"/"0" in the migration file solves this for Sqlite. It's OK with Mysql too, but I don't have any Postgres cluster at home to be sure it works with Postgres. Maybe someone could test it before applying any patch or solving it another way ?
Updated by Jean-Philippe Lang over 15 years ago
- Status changed from New to Closed
- Resolution set to Fixed
Fixed in r2279. Thanks for pointing this out.
Actions