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 "), This might help only partially :( due to deleted rooms will be skipped and ids might change On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke <[email protected]>wrote: > Hello Maxim, > > sorry but I don't know how to transform the rooms.xml from the > backup.zip to have sorted room ID's. I played arround with libreoffice > headless, a xml filter for libreoffice and with xsltproc but could not > find a solution. > > Please could you help me? Or can you give me a hint how to export the OM > database into the xml files with sorted ID's? > > Thank you, > Michael > > Am 03.05.14 12:33, schrieb Maxim Solodovnik: > > Unfortunately the only option for you is to re-order rooms in xml file > > (manually or using xsl transformation) > > Rooms should be ordered by ID > > > > > > On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke > > <[email protected]>wrote: > > > >> Hello Maxim, > >> > >> we are backp on OM version 2.1.1 now! > >> > >> This was the procedure of my upgrade test: > >> > >> 1. I stoped Openmeetings > >> 2. I backuped the red5 folder of the OM 2.1.1 installation > >> 3. I made a DB backup for the mysql database of OM > >> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file > >> ../backup_today.zip > >> 5. I moved the folder of the OM 2.1.1 installation > >> 6. I unziped the 3.0.1 version of OM into the same folder (red5) > >> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file > >> ../backup_today.zip --drop --skip-default-rooms > >> 8. I started Openmeetings again > >> > >> Sorry, but I don't know exactly what do you suggest. How can I influence > >> the export of the OM DB to make sure that the ID's of the rooms are in > >> the right order after the import? There are no difference between the > >> admin.sh scripts, logback-config.xml and logback.xsd files of the OM > >> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014). > >> Or where do I have to look for? > >> > >> Thank you for help or advice, > >> Michael > >> > >> Am 03.05.14 05:41, schrieb Maxim Solodovnik: > >>> you can try to "install from backup" from command line admin > >>> in this case no additional users/rooms are creted, so IDs should be the > >>> same. > >>> > >>> I guess it is export issue (and should be fixed in latest OM, I have > >> added > >>> ORDER BY if I'm not mistaken) > >>> > >>> > >>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke < > >> [email protected] > >>>> wrote: > >>> > >>>> and how did you solve that problem? ;-) > >>>> > >>>> Greetings, > >>>> Michael > >>>> > >>>> Am 02.05.14 13:49, schrieb Peter Dähn: > >>>>> well.. I just was remembered at my experience... > >>>>> > >>>>> BR Peter > >>>>> > >>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke: > >>>>>> Hello Peter, > >>>>>> > >>>>>> sorry, but in this case I am using mysql for both: moodle and > >>>>>> openmeetings. > >>>>>> > >>>>>> But thank you for your quick reply. > >>>>>> Michael > >>>>>> > >>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn: > >>>>>>> Hello together, > >>>>>>> > >>>>>>> could be the problem witht the postgres export... > >>>>>>> > >>>>>>> What kind o database do you use? > >>>>>>> > >>>>>>> BR Peter > >>>>>>> > >>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke: > >>>>>>> > >>>>>>>> Hello Maxim, > >>>>>>>> > >>>>>>>> ok, I checked the databases (the database before the upgrade und > >>>>>>>> the database after the upgrade) and the red5 folders (version > 2.1.1 > >>>>>>>> and 3.0.1). In both databases are same entries of users, of rooms > >>>>>>>> and of files (items in the fileexploreritem table). In both red5 > >>>>>>>> folders are the same number of files (in the upload folder). In > the > >>>>>>>> OM installation I have more than 500 users, more then 200 rooms- > all > >>>>>>>> created & managed via moodle - and more than 750 files uploaded > into > >>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still > >>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the > >>>>>>>> right moodle om activities. They are not in the right order. What > >>>>>>>> can I do. How can I fix the issue? > >>>>>>>> > >>>>>>>> Thank you for help or any advice, > >>>>>>>> Michael > >>>>>>>> > >>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik: > >>>>>>>> According to the process only deleted files might be removed .... > >>>>>>>> can you check if these files are still in the DB? > (fileexploreritem > >>>>>>>> > >>>>>>>> table, you can check by filehash and/of filename) > >>>>>>>> > >>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke > >>>>>>>> <[email protected]> wrote: > >>>>>>>> > >>>>>>>> Hello, > >>>>>>>> > >>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via > >>>>>>>> the > >>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade. > >>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1] > >>>>>>>> > >>>>>>>> After the upgrade some uploaded files are not available any longer > >>>>>>>> in > >>>>>>>> the rooms or at the witheboards. In the log files there were no > >>>>>>>> error > >>>>>>>> messages. > >>>>>>>> > >>>>>>>> Has anybody an idea how I can find the missing files? I made a > >>>>>>>> backup of > >>>>>>>> the old database and the red5 folder with all the data and the > >>>>>>>> logs. > >>>>>>>> > >>>>>>>> Greetings, > >>>>>>>> Michael > -- WBR Maxim aka solomax
