Hi Juergen,

I'm hiking at the weekend, but I'll fix the scripts next week.
Please send any bugs you find,

Cheers,
Balint

--- Juergen Ulbts <j.ulbts at uni-oldenburg.de> wrote:

> 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
> 
> 
> _______________________________________________
> General mailing list
> General at open-xchange.org
> http://www.open-xchange.org/cgi-bin/mailman/listinfo/general
> 



		
___________________________________________________________ 
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" – The Wall Street Journal 
http://uk.docs.yahoo.com/nowyoucan.html