Vote #66275
完了Version Status not upgraded from 0.8.5 -> 0.9.0
0%
説明
I just installed and upgraded my Redmine instance from 0.8.5 to 0.9.0 (stable branch).
The application is working well, but I just noticed there's an issue with Project Versions.
It seems the migration didn't update the status field (screenshot 1).
In fact, if I manually open a version and hit update, then the error disappear because the status field is now properly set (screenshot 2).
Also, the version select is not displayed in any existing project probably because Redmine can't find any active version after the upgrade.
journals
I've fixed the migration in r3259.
This problem did not occur with my Mysql 5 database (status was set to 'open' by default). What is yours ?
Please run the following to set blank statuses to 'open':
<pre>
$ ruby script/console production
Loading production environment (Rails 2.3.5)
>> Version.update_all("status = 'open'", "status IS NULL")
</pre>
--------------------------------------------------------------------------------
Running the update fixed the issue.
The database is PostgreSQL.
--------------------------------------------------------------------------------
This works great, but it's easy to miss if someone had already upgraded to trunk before this commit.
You should really move this to a new migration--and add a "status IS NULL" condition just in case.
--------------------------------------------------------------------------------