[Owncloud] Re-Upgrade to Owncloud 5

owncloud_mailing_list at status.e4ward.com owncloud_mailing_list at status.e4ward.com
Tue Jul 9 20:36:40 UTC 2013


Hello all.

I have a frustrating issue. For unrelated issues, a while back I needed to rebuild my server from scratch. I was storing my owncloud data in a mysql database, and when I rebuilt, (for again unrelated issues) I needed to use postgresql. I used the mysql2psql Ruby gem to convert the Owncloud database to Postgresql, then ran the resulting dump to restore the owncloud database. I initially did this restore as the postgres user, so all of the tables etc. were owned by postgres.

I then installed owncloud 5.0.7 (before the restore I was running 4.8.1, so my database was 4.8.1). When I visited my newly restored/updated Owncloud, it went through the update process for the database. It only made it a little way before it failed, since the database tables weren't owned by the owncloud database user. I realized the problem, dropped the table, and re-imported the database dump as the owncloud user. At that point, the upgrade succeeded and all my stuff was back. Yay!

That was several days ago. Owncloud calendar and contacts were working perfectly, and only now did I try to start syncing again. It wasn't working with the sync client (something about 'csync not connecting via proxy' or some such error), so I looked at the admin log, where I found several errors about violating a database constraint (unfortunately I don't remember the exact error... "id already exists" or some such thing). I googled the error and came upon this: https://github.com/owncloud/core/pull/2096 . That made me think that my first failed attempt at updating (when all the tables were owned by postgres) threw off my subsequent successful update, and I decided to try it again. So I dropped my postgresql table and went through the import process again.

However, now owncloud isn't attempting the update. When I visit the URL, I get the plain old login page. When I login, all I get is a blank white page. The apache2 error log doesn't show anything other than a missing favicon, which it's always complained about (if I remember correctly).

What did I do wrong? How can I get my stuff back? My files are all safe, so I could technically restore from scratch, but I really need my calendar and contacts back, too.

Please help! Thank you very much.

Kyle



More information about the Owncloud mailing list