Hi Peter, thanks for your hints. I will have a look at the other xml files too. ;-)
Normaly the OM rooms are created by moodle via the SOAP-Gateway. I am not sure if these rooms will be marked as deleted and remain in the databas as well when I delete the so called OM activity in moodle. Greetings, Michael Am 05.05.2014 11:07, schrieb Peter Dähn: > Hi Michael, > > we had also problems with user.xml and a few other files... maybe you > should have a look at the other files too... > > rooms should just be deleted over the admin interface. Then the rooms > will just be marked as deleted and remain in the database. Then the > right order will be kept. You run into problems, if you delete something > in the database. > > Greetings Peter > > > Am 05.05.2014 10:52, schrieb Michael Wuttke: >> Hello Peter, >> >> Am 05.05.2014 09:42, schrieb Peter Dähn: >>> sorry.. was out of office... ;-) >> no problem. No wonder with so many public holidays. ;-) >> >>> We added an orderby to the export functions of the backup-procedure and >>> make another backup... but we used OM 2.0... so... you need to find the >>> used functions and add to the sql queries an orderby-part by youtrself... >>> Therefor you need to change some source-files an recompile om... >> Maxim suggested it yesterday too: >>> The easiest way is to correct 2.1.1 sources and add ORDER BY: >>> >>> >> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java >> >>> To this line: >>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r >> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "), >> >>> But with mysql the order shoulb be fine.. as far as I remember... it was >>> just an issue with postgres... Are the id's mixed in your rooms.xml? >> Yes the id's of the rooms.xml export file are mixed. >> >> I'm curious about, what will be happen with the deleted rooms. Maybe >> they will be skipped and the id's might change as well. >> >> After the next upgrade test I can tell more about it. ;-) >> >> Thank you & Greetings, >> Michael >> >> -- Danke & mit freundlichen Grüßen, Michael Wuttke Learning Management System Moodle http://lms.beuth-hochschule.de Beuth Hochschule Berlin - Labor Online Learning http://learn.beuth-hochschule.de Luxemburger Str. 10 13353 Berlin Tel: +49 (0)30 45 04 2184 E-Mail: [email protected] News: http://lms.beuth-hochschule.de/rss
