Thanks for the reply Christian. Actually I did read the upgrade
documentation, and I didn't see anything about the format change in the
time fields. Is it really there and am I blind? Something else that is
entirely vague is if you can upgrade from 10-> 12 directly or do you
have to update from 10 -> 11 -> 12.
On 2/14/2011 11:54 PM, Christian Boos wrote:
Hello Matt,
On 2/15/2011 1:05 AM, MattK wrote:
I have a Trac 0.10.3 instance using sqlite that I want to update to
Trac 12. I installed Trac 0.12.2 on another machine and copied over
my Trac environment. I followed the instructions carefully for
upgrading. I also used the sqlite2pg script to convert my trac.db to
a Postgres database. This seemed to work without issue.
Prior to switching to 0.10.3 I converted my trac.db to Postgres with
the Trac 10 instance. I didn't use this DB, I just wanted to test out
the conversion script. The resulting Postgres DB's "Wiki" and
"Ticket" tables had time fields that were of type "integer".
When I did the same convertion using the Trac 12 instance, the
resulting table's time fields were of type "bigint".
Expected.
This seems to be causing problems for me as several custom reports no
longer work, and things like the Wikinfo plugin won't work when
accessing the time column's value trying to call strftime.
Some adaptations are needed for your custom reports (/ 1 000 000) and
you need of course to check the compatibility of your plugins and
upgrade them if necessary.
Are there any known issues and fixes with this migration and/or the
use of the sqlite to postgres script that someone can point me to so I
can resolve some of these problems? I feel like I shouldn't be
punished for trying to upgrade the software...
No, instead you're "punished" for not reading the upgrade notes ;-)
In particular:
-
http://trac.edgewall.org/wiki/TracUpgrade#UpgradingfromTrac0.10toTrac0.11
-
http://trac.edgewall.org/wiki/TracUpgrade#UpgradingfromTrac0.11toTrac0.12
Hope this helps,
-- Christian
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
