I am migrating a track installation to a new server. The current track environments are mixed postgres and sqlite databases.
I have followed the steps on here http://trac.edgewall.org/wiki/TracMigrate The thing is that those environments running sqlite database are working just fine, but those that running postgresql database are driving me nuts. I dumped the trac database from the old server and restored it into the new one. Here are the steps I did: pg_dump -U trac -h localhost trac > mydb.sql and on the new server I created the trac database then psql -U postgres -h localhost -d mydb.sql I had to use the postgres sql cause when I was using the trac user it was giving an error restoring some stuff. but the trac database was created with the trac user. And now when I run trac-admin $env upgrade --no-backup I get this error: NotSupportedError: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view trac_view.ticket depends on column "changetime" I tried both copy paste the old environment and also creating a new environment and just change the database. the trac running on the old server is trac-0.10 and on the new server is trac-0.12 I am really stucked on this, I have been googling for couple days with no results, so any help will be appreciated. Thanks. -- 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.
