Hello!

I've followed the wiki to update the database structure from OX 0.8.0 to 
OX 0.8.2 which worked except for the project and project tasks.
I haven't checked the normal tasks yet.
There are problems accessing the project tasks.

Has anyone completed the project and task (project tasks) migration 
successfully or created a working migration script for this?


There are several problems with the available migration script that is 
available for the debian package (see "6. SQL Script to perform most of 
the complex steps above"):
http://www.open-xchange.org/oxwiki/StableUpgrade


I'm currently comparing the tables entries by creating entries in both 
OX versions (0.8.0-6 and 0.8.2).

For the table "projects" there are at least these problems - and I've 
just started looking for the problems:
-project_currency: text (but a nummeric ID is stored)
  OLD: prg_projects_field09 = <CURRENCY CODE> (e.g. "EUR", "FRA")
   1 = "EUR"
   2 = "USD"
   3 = "GBP"
   4 = "CHF"
   5 = "SEK"
   6 = "DKK"
   7 = "RUB"
   8 = "PLN"
   9 = "TRL"
  10 = "OTHER"

-project_effort_unit: text (but a nummeric ID is stored)
  1 = "hours" (DEFAULT) - OLD: prg_projects.field08 = "H"
  2 = "days" - OLD: prg_projects.field08 = "D"
  3 = "other"


-project_reminder_id: integer
  -1 = DEFAULT to disable it. Not NULL as with the script.

-created_from and changed_from: text
Previously the name of the logged in user was stored not it's the login. 
The fields are currently mapped 1 on 1.
This doesn't seem to be a serious problem as it's only an information 
but it's not 100% correct!

To be continued...


Kind regards,
Juergen Ulbts