Project

General

Profile

Actions

Patch #14567

open

migrate_from_trac.rake does not convert timestamps in Trac database version 23

Added by Craig Rodrigues over 12 years ago. Updated over 12 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Importers
Target version:
-

Description

In Trac API 0.12, the representation of timestamps was changed from seconds since the epoch
to microseconds since the epoch:
http://trac.edgewall.org/wiki/TracDev/ApiChanges/0.12#Timestampstorageindatabase

See this patch that changed it in Trac:

http://trac.edgewall.org/attachment/ticket/6466/6466-microsecond-times-r8770.patch

If you try to run the existing migrate_from_trac.rake script, the year will be thousands
of years in the future, and the importer will populate the date in redmine is 0000000000.
This causes many things to break.
The problem still exists with the trunk version of the migrate_from_trac.rake script.

In #882 , the user encountered the problem, but went down the wrong path with the fix,
because he didn't understand why timestamps were being imported incorrectly.

I am submitting a better fix, which detects the database version of Trac. If the database
version is > 22, then every time a timestamp from Trac is encountered, we divide by 1 million.

This patch is against trunk.
I have used this patch successfully and it fixes all my problems importing from Trac.

I think many people are hitting these issues when doing Trac -> Redmine migrations. Here are some example tickets:

#5764
#8690
#12477


Files

migrate_from_trac.rake.patch.txt (5.31 KB) migrate_from_trac.rake.patch.txt Craig Rodrigues, 2013-07-29 16:41

Related issues

Related to Redmine - Patch #5764: migrate_from_trac does not support trac 0.12New2010-06-27Actions
Related to Redmine - Defect #8690: User can't be displayedNeeds feedback2011-06-27Actions
Related to Redmine - Defect #12477: Internal server error after migrate from Trac 0.12.3 ro Redmine 2Needs feedbackActions
Related to Redmine - Defect #14590: migrate_from_trac.rake does not import Trac users, uses too short passwordClosedJean-Philippe LangActions
Related to Redmine - Patch #14592: migrate_from_trac.rake does not properly parse First Name and Last NameClosedActions
Related to Redmine - Patch #14593: migrate_from_trac.rake, print out validation errors when doing saveNewActions
Related to Redmine - Defect #14844: migrate_from_trac is not run in database transactionNewActions
Related to Redmine - Defect #6868: migrate_from_trac and trac 0.12Reopened2010-11-11Actions
Related to Redmine - Defect #10738: trac import issueNewActions
Related to Redmine - Defect #20943: migrate_from_trac.rake dont workResolvedActions
Has duplicate Redmine - Defect #14845: Error in user controllerClosedActions
Has duplicate Redmine - Defect #17898: Exception in Migration from Trac to Redmine (incl. solution)ClosedActions
Actions

Also available in: Atom PDF