Project

General

Profile

Actions

Defect #2526

closed

103_set_custom_fields_editable.rb and Sqlite3 support

Added by Jean-Baptiste Barth over 15 years ago. Updated over 15 years ago.

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 ?

Actions #1

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

Also available in: Atom PDF