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". 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. 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... -- 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.
