https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292009-12-29T14:54:07ZRedmineRedmine - Defect #4504: Version Status not upgraded from 0.8.5 -> 0.9.0https://www.redmine.org/issues/4504?journal_id=133562009-12-29T14:54:07ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Target version</strong> set to <i>0.9.0</i></li><li><strong>Affected version (unused)</strong> set to <i>devel</i></li><li><strong>Resolution</strong> set to <i>Fixed</i></li></ul><p>I've fixed the migration in <a class="changeset" title="Set status of existing versions to 'open' (#4504)." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/3259">r3259</a>.<br />This problem did not occur with my Mysql 5 database (status was set to 'open' by default). What is yours ?</p>
<p>Please run the following to set blank statuses to 'open':</p>
<pre>
$ ruby script/console production
Loading production environment (Rails 2.3.5)
>> Version.update_all("status = 'open'", "status IS NULL")
</pre> Redmine - Defect #4504: Version Status not upgraded from 0.8.5 -> 0.9.0https://www.redmine.org/issues/4504?journal_id=133582009-12-29T15:37:09ZSimone Carletti
<ul></ul><p>Running the update fixed the issue.<br />The database is PostgreSQL.</p> Redmine - Defect #4504: Version Status not upgraded from 0.8.5 -> 0.9.0https://www.redmine.org/issues/4504?journal_id=133682009-12-29T22:50:10ZAndrea Campi
<ul></ul><p>This works great, but it's easy to miss if someone had already upgraded to trunk before this commit.<br />You should really move this to a new migration--and add a "status IS NULL" condition just in case.</p>