ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

Redmine Migration Fails on NULL column (Bug #641)


Added by Peer Allan at 2011-09-23 05:35 pm.


Status:Open Start date:2011-09-23
Priority:Normal Due date:
Assignee:- % Done:

0%

Category:-
Target version:-
Remote issue URL: Affected version:

Description

When attempting to migrate to Chiliproject from Redmine 1.2.1 we received the following MySQL error while running the UpdateJournalsForActsAsJournalized migration. The error appears to be related to custom fields for issues created before the custom field was added. The error is:

MysqlStatement::Error Value for field `value` cannot be NULL INSERT INTO custom_value ...

Turning on allow NULL in the database allows the migration to run. In our example the custom field "Country" was added after issues had already been completed. It appears the migration is trying to rebuild the custom values, but because this issue is missing a value for 'Country' it tries to insert NULL and fails.

I realize this possible cause is speculative. If I have more time to try isolate it more closely I will let you know.


Associated revisions

Revision 4ff77cc6
Added by John Goerzen at 2008-03-20 06:41 pm

Make an issue's done_ratio field adjustable from the right-click
context menu.

Uses patch from, and fixes #641. Patch by Dov Murik.

git-svn-id: http://redmine.rubyforge.org/svn/trunk@1277 e93f8b46-1217-0410-a6f0-8f06a7374b81

Revision 8ed97f43
Added by John Goerzen at 2008-03-20 08:25 pm

Revert "Make an issue's done_ratio field adjustable from the right-click"

Reverts commit r1277
fixes #904
refs #641

This had been working for me in testing for some time, but received
issue #904 saying it broke the context menu. I was able to make it do
so on a new project as well. Will revert and comment in #641 about this.

git-svn-id: http://redmine.rubyforge.org/svn/trunk@1278 e93f8b46-1217-0410-a6f0-8f06a7374b81

Revision bbf422e2
Added by Jean-Philippe Lang at 2008-03-21 06:32 pm

Add done_ratio to the right-click context menu.
Closes #904 (back_to variable used in patch #641 and in r1277 is no longer defined).

git-svn-id: http://redmine.rubyforge.org/svn/trunk@1279 e93f8b46-1217-0410-a6f0-8f06a7374b81

History

Also available in: Atom PDF