Thanks! I'll take a look at it. Reinoud
On 15 jan. 2014, at 22:41, Frank Karlitschek <fr...@owncloud.org> wrote: > We are working on providing a DB migration script. Here is a pull request > that is still work in progress: > https://github.com/owncloud/core/pull/6457 > Any help with coding and testing is highly appreciate. > > > Frank > > > On 15.01.2014, at 16:17, Otto Kekäläinen <o...@seravo.fi> wrote: > >> I tried this migration a few days ago (look at the mailing list >> history with author my name), and I after manually fixing many many >> things I eventually gave up. At the moment there is no working >> migration script. >> >> Today I reinstalled one OwnCloud installation with MySQL and simply >> re-created the users and moved the files. A bit of work, but at the >> moment the best option. Hopefully an official migration script would >> be made at some point. Even better if SQLite was not default, not even >> for home users.. >> >> 2014/1/15 Reinoud van Leeuwen <reinou...@n.leeuwen.net>: >>> >>> On 15 jan. 2014, at 21:56, Diederik de Haas <didi.deb...@cknow.org> wrote: >>> >>>> On Wednesday 15 January 2014 21:39:19 Reinoud van Leeuwen wrote: >>>>> I have another problem: it seems that in my SQLite installation a table >>>>> oc_fscache is present, which is missing in the Mysql Dump... >>>> >>>> Just create that table, or leave it out all together. It is meant to cache >>>> things, so if it's not present, it will be created (and filled). >>>> I've cleared that table many times during testing, so afaik it's safe to >>>> leave >>>> it out. >>> >>> Next thing I stumble upon is: >>> >>> ERROR 1062 (23000) at line 5269: Duplicate entry >>> 'calendar/appinfo/remote.php-core' for key 'PRIMARY' >>> >>> Makes sense since the create table statement is >>> >>> CREATE TABLE `oc_appconfig` ( >>> `appid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', >>> `configkey` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', >>> `configvalue` longtext COLLATE utf8_unicode_ci, >>> PRIMARY KEY (`appid`,`configkey`), >>> >>> and in the dump are lines: >>> >>> INSERT INTO `oc_appconfig` >>> VALUES('calendar/appinfo/remote.php','core','remote_calendar'); >>> INSERT INTO `oc_appconfig` >>> VALUES('calendar/appinfo/remote.php','core','remote_caldav'); >>> >>> >>> So, someone might know how to fix this particular problem, but my point is >>> that from a application maintainer perspective I do not feel really good >>> having to hack like this in SQL dumps to get this working. And it sounds >>> like the database is different on SQLite, otherwise this would not have >>> been present in the database at all.. >>> Or is this the result from buggy updates? >>> >>> Reinoud >>> _______________________________________________ >>> Owncloud mailing list >>> Owncloud@kde.org >>> https://mail.kde.org/mailman/listinfo/owncloud >> >> >> >> -- >> Otto Kekäläinen >> +358 44 566 2204 >> http://seravo.fi/ >> _______________________________________________ >> Owncloud mailing list >> Owncloud@kde.org >> https://mail.kde.org/mailman/listinfo/owncloud > > _______________________________________________ > Owncloud mailing list > Owncloud@kde.org > https://mail.kde.org/mailman/listinfo/owncloud > _______________________________________________ Owncloud mailing list Owncloud@kde.org https://mail.kde.org/mailman/listinfo/owncloud
