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
