Today I decided to upgrade from owncloud 8.2 to nextcloud 9.0. There are a lot of posts around the internet so I am not going to give a detailed step by step (besides it is similar to a migration to a newer version of owncloud, so my previous post is valid here too). If you remember I had problems updating to the las version because of errors in the database upgrade. The error continued up to now and in both applications (owncloud or nextcloud).
The problem complained about creating some tables. The final reason was that those tables were already there (I do not know where they came from, because they are in my backups since version 7 provided by Debian). Finally I gave up and decided to spend the time deleting the affected tables and re-inserting the data if necessary. I went table by table and finally the following SQL script drop the problematic tables:
/* drop database an re-create */
drop database owncloud;
create database owncloud;
use owncloud;
/* load the dump from version 8.2 */
source /home/ricky/owncloud-8.2.dump
/* drop tables that seem to be wrong */
drop table oc_notifications;
drop table oc_trusted_servers;
drop table oc_addressbooks;
drop table oc_cards;
drop table oc_addressbookchanges;
drop table oc_calendarobjects;
drop table oc_calendars;
drop table oc_calendarchanges;
drop table oc_calendarsubscriptions;
drop table oc_schedulingobjects;
drop table oc_cards_properties;
drop table oc_dav_shares;
From those tables five of them had previous data in the backup (oc_addressbooks, oc_cards, oc_addressbookchanges, oc_calendars and oc_cards_properties). Nevertheless after the upgrade all of them were fully filled again (so I think the data is created from pre-existing information and no more action was needed). Deleting them the nextcloud upgrade ran successfully and now I am at version 9.0.53. As I commented in the previous entry do not forget to activate the applications you use and upgrade them too. Just one more comment, for the notes application I use, the current master branch is needed (last released version 2.0.1 does not work, nothing is shown inside the page).
So, finally I decided to move from owncloud to nextcloud. I also changed the phone application. Let's see what happens because I am not very sure about my decision. (Mainly I wanted to fix my broken upgrade to version 9.x. And, because both projects gave me the same problem, I realized that the issue had to be related to my particular data and not to a problem in the upgrade itself. That fact forced me to choose a project sooner than I would have wanted. The answer from the owncloud foundation to the nextcloud announce was quite decisive.)
Enjoy and retain your data!
Comments