Hello Maxim, ok, I will try it.
To open an issue in JIRA for that is not necessary, or? Thank you, Michael Am 04.05.14 18:32, schrieb Maxim Solodovnik: > yes sure > > > On Sun, May 4, 2014 at 11:16 PM, Michael Wuttke <[email protected] >> wrote: > >> Hello Maxim, >> >> and after adding ORDER BY, I have to recompile the code? >> >> Thanks, >> Michael >> >> Am 04.05.14 17:18, schrieb Maxim Solodovnik: >>> 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 >> > > >
