Defect #26

sqlite3 exception in db:migrate on AddChangesetCommitDate file when upgrading to last trunk

Added by Nicolas Chuche 521 days ago. Updated 521 days ago.

Status:Closed Start:
Priority:Normal Due date:
Assigned to:- % Done:

0%

Category:-
Target version:-

Description

When trying to upgrade to the last trunk db:migrate aborts with this message :

% rake db:migrate --trace
(in /home/nc/travail/rails/redmine) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate
AddChangesetCommitDate: migrating ========================================
-- add_column(:changesets, :commit_date, :date, {:null=>false})
rake aborted!
SQLite3::SQLException: Cannot add a NOT NULL column with default value NULL: ALTER TABLE changesets ADD
"commit_date" date NOT NULL
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
[...]

Two choices :
- allow NULL date
- set a default date

History

2007-03-26 12:42 - Jean-Philippe Lang

The migration script is fixed, NULL is now allowed.

Thanks

Also available in: Atom PDF