This is already fixed in 3.x On May 5, 2014 1:22 AM, "Michael Wuttke" <[email protected]> wrote:
> 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 > >> > > > > > > >
