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 >>>> >>> >>> >>> >> > > >
