Deleted rooms are not exported :( @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r LEFT JOIN FETCH r.moderators WHERE *r.deleted = false* "),
You need to remove WHERE clause. Maybe this should also be fixed in 3.0.2+ On Tue, May 6, 2014 at 1:49 PM, Michael Wuttke <[email protected]>wrote: > Hello Maxim, > > select id, 0+deleted from room; works for OM 2.1.1. > > Ok, now I get: > +-----+-----------+ > | id | 0+deleted | > +-----+-----------+ > | 1 | 0 | > | 2 | 0 | > | 3 | 0 | > | 4 | 0 | > | 5 | 0 | > | 6 | 0 | > | 7 | 0 | > | 8 | 0 | > | 9 | 0 | > | 10 | 0 | > | 11 | 1 | > | 12 | 1 | > | 13 | 1 | > | 14 | 1 | > | 15 | 1 | > | 16 | 1 | > | 17 | 1 | > | 18 | 1 | > > and so on ... > > But in the room.xml the deleted rooms are still missing. What should I do? > > Thanks, > Michael > > Am 06.05.14 06:27, schrieb Maxim Solodovnik: > > please try to "select id, 0+deleted from rooms" > > columns and tables might vary > > > > we are trying to continuously improve things :) > > > > > > On Tue, May 6, 2014 at 2:56 AM, Michael Wuttke > > <[email protected]>wrote: > > > >> Hello Maxim, > >> > >> thanks, now it works. I compilied OM 2.1.1 with the change you suggested > >> yesterday (I added "ORDER BY room_id"). But after the backup I had the > >> same room.xml like before. > >> I discovered that there faild 10 rooms. In the Admin-GUI -> rooms they > >> faild as well. But in the database there are no entries in the column > >> field 'deleted'. What should be there? In the latest OM version 3.0.1 I > >> can find 'f' for false or 't' for true in that field. > >> > >> Thank you, > >> Michael > >> > >> Am 05.05.14 18:06, schrieb Maxim Solodovnik: > >>> The problem is: /usr/adm/apache-ant-1.9.3/bin/ant > >>> > >>> you need ant 1.8.4-1.9.2 for this > >>> > >>> > >>> On Mon, May 5, 2014 at 10:26 PM, Michael Wuttke < > >>> [email protected]> wrote: > >>> > >>>> Hello, > >>>> > >>>> I tried to download the source code of OM 2.1.1 and tried to compile > it > >>>> with the following stepps: > >>>> > >>>> mkdir /usr/adm/singlewebapp > >>>> cd /usr/adm/singlewebapp > >>>> wget > >>>> > >>>> > >> > http://apache.mirrors.timporter.net/openmeetings/2.1.1/src/apache-openmeetings-2.1.1-src.tar.gz > >>>> tar -zxvf apache-openmeetings-2.1.1-src.tar.gz > >>>> /usr/adm/apache-ant-1.9.3/bin/ant clean.all > >>>> /usr/adm/apache-ant-1.9.3/bin/ant -Ddb=mysql > >>>> > >>>> like described in this tutorial: > >>>> > >>>> > >> > https://cwiki.apache.org/confluence/download/attachments/27838216/Installing%20OM2.1.1%20on%20Debian64%20Wheezy.pdf?version=1&modificationDate=1380291632000&api=v2 > >>>> > >>>> But it failed with the following error message: > >>>> BUILD FAILED > >>>> /usr/adm/singlewebapp/build.xml:751: java.lang.NullPointerException > >>>> at > >>>> > >>>> > >> > org.apache.tools.ant.taskdefs.Javadoc.postProcessGeneratedJavadocs(Javadoc.java:2450) > >>>> at > >> org.apache.tools.ant.taskdefs.Javadoc.execute(Javadoc.java:1790) > >>>> at > >>>> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) > >>>> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) > >>>> at > >>>> > >>>> > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >>>> at java.lang.reflect.Method.invoke(Method.java:597) > >>>> at > >>>> > >> > org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) > >>>> at org.apache.tools.ant.Task.perform(Task.java:348) > >>>> at org.apache.tools.ant.Target.execute(Target.java:435) > >>>> at org.apache.tools.ant.Target.performTasks(Target.java:456) > >>>> at > >>>> org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393) > >>>> at > org.apache.tools.ant.Project.executeTarget(Project.java:1364) > >>>> at > >>>> > >>>> > >> > org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) > >>>> at > >> org.apache.tools.ant.Project.executeTargets(Project.java:1248) > >>>> at org.apache.tools.ant.Main.runBuild(Main.java:851) > >>>> at org.apache.tools.ant.Main.startAnt(Main.java:235) > >>>> at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) > >>>> at > org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) > >>>> > >>>> Please has someone an idea what was wrong? > >>>> > >>>> Thanks for any help, > >>>> Michael > >>>> > >>> > >>> > >>> > >> > > > > > > > -- WBR Maxim aka solomax
