Hello,

have OpenProject 3 installed and would now like to integrate the 2.4 database tables and files of the open project on the 3.0. is possible or what should I look for there?
For I have received an error message.
what data must actually be copied from the 2.4 to the 3.0?

regards janek

more error messages

after I have imported into the database 3.0, 2.4 and op “bundle exec rake db: migrate” have executed this error message came.

Hello Janek,

you need to prepare the legacy data before you can actually migrate it. First of all I recommend you to use the migrations:change_timestamps_to_utc rake task if your local timezone is different to UTC like this:

FROM="Europe/Berlin" rake migrations:change_timestamps_to_utc

Don’t forget to replace Europre/Berlin by your timezone. So, you should start the migration with the following command:

FROM="Europe/Berlin" rake migrations:change_timestamps_to_utc db:migrate

Regarding the last error message: Documents are not supported for projects and versions by OpenProject 3.0. Thus, you need to delete documents with rake task migrations:attachments:delete_from_projects_and_versions as described in the error message.

I hope this helps you to get through the migration. If not, don’t hesitate to get back to us with your questions. Note that we are constantly working on OpenProject, so you should try to get the latest revision from GitHub.

Kind regards,
Hagen

hello Hagen,

when I enter the two commands, comes this:

Hello Janek,

yeah, you need to load time zone information into your database beforehand. You’ll find details in the MySQL documentation. For Ubuntu this means you need to issue the following command:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Kind regards,
Hagen

Well, assuming you are on a Linux system, you should just run the above command to load the timezone data.
This way MySQL knows how to convert timestamps in different zones from summer to winter time and so on.
Don’t forget to create backups before doing anything. This is essentially still a Beta state…

Regards,
Sebastian

I should probably reload a page before starting to write answers…