https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292012-03-21T08:30:37ZRedmineRedmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=369442012-03-21T08:30:37ZAlan Chandler
<ul></ul><p>references to #15501 should be <a class="issue tracker-1 status-5 priority-4 priority-default closed" title="Defect: migrate_from_mantis script fails on first project using sqlite3 (Closed)" href="https://www.redmine.org/issues/10501">#10501</a></p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=369832012-03-23T14:52:15ZAlan Chandler
<ul></ul><p>I am still trying to understand this issue, but as I am completely new to Ruby, let alone all the other lays of framework, I am struggling a bit.</p>
<p>As far as I can make out, the problem is with the "date_order" column in the version table in mantis. This is declared (in my mysql version) as <abbr title="10">INT</abbr>, but seems to be the number if seconds since 1970. In my redmine (sqlite3) database that is the target, we are looking at the effective_date field. This is declared as type DATE, although in SQLite it is stored as a field of type Numeric.</p>
<p>In order to handle that change the script does <code>effective_date => (version.date_order ? version.date_order.to_date : nil)</code> but fails on the .to_date function.</p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=369852012-03-23T15:05:40ZAlan Chandler
<ul><li><strong>File</strong> <a href="/attachments/7365">migrate2.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/7365/migrate2.patch">migrate2.patch</a> added</li></ul><p>I think the attached patch fixes this issue</p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=369862012-03-23T15:19:08ZAlan Chandler
<ul><li><strong>File</strong> <a href="/attachments/7366">migrate2.patch</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/7366/migrate2.patch">migrate2.patch</a> added</li></ul><p>Apologies, but the attached patch in the above update has Time.At as opposed to Time.at in it, and then fails. Revised patch attached</p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=370202012-03-25T08:46:44ZAlan Chandler
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li></ul><p>The fix for this issue is contained within <a class="issue tracker-1 status-3 priority-4 priority-default" title="Defect: migrate_from_mantis script fails with missing table name (Resolved)" href="https://www.redmine.org/issues/10532">#10532</a></p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=559452014-04-18T11:37:50Zmeta tech
<ul></ul><p>With version 2.5.0 I have the same problem, migrating from Mantis mysql DB.</p>
<p>Migrating users............<br />rake aborted!<br />undefined method `to_date' for 1242123547:Bignum<br />/home/user/redmine-2.5.0/lib/tasks/migrate_from_mantis.rake:289:in `migrate'<br />/var/lib/gems/1.8/gems/activerecord-3.2.17/lib/active_record/associations/collection_proxy.rb:91:in `each'<br />/var/lib/gems/1.8/gems/activerecord-3.2.17/lib/active_record/associations/collection_proxy.rb:91:in `send'<br />/var/lib/gems/1.8/gems/activerecord-3.2.17/lib/active_record/associations/collection_proxy.rb:91:in `method_missing'<br />/home/user/redmine-2.5.0/lib/tasks/migrate_from_mantis.rake:286:in `migrate'<br />/home/user/redmine-2.5.0/lib/tasks/migrate_from_mantis.rake:266:in `each'<br />/home/user/redmine-2.5.0/lib/tasks/migrate_from_mantis.rake:266:in `migrate'<br />/home/user/redmine-2.5.0/lib/tasks/migrate_from_mantis.rake:514<br />Tasks: TOP => redmine:migrate_from_mantis<br />(See full trace by running task with --trace)</p>
<p>Was the fix ever included ?<br />Thanks.</p> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=563712014-05-18T03:42:26ZToshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-3 priority-4 priority-default" href="/issues/10532">Defect #10532</a>: migrate_from_mantis script fails with missing table name</i> added</li></ul> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=563732014-05-18T03:42:40ZToshi MARUYAMA
<ul><li><strong>Category</strong> set to <i>Importers</i></li></ul> Redmine - Defect #10504: migrate_from_mantis script fails on first project when trying to update version dateshttps://www.redmine.org/issues/10504?journal_id=612062015-01-30T18:35:30ZToshi MARUYAMA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-3 priority-6 priority-highest" href="/issues/18984">Defect #18984</a>: migrate_from_mantis with NoMethodError: strftime</i> added</li></ul>