Sebastian, Thats exactly right! This occurs during the installation itself and none of the tables are being created upon running the Red5 batch file.
We were able to successfully install it until last week, but suddenly upon trying the same installation on a fresh system gives the mentioned error. Let me know if you need any more detailed log files to understand the root cause. Regards, Syed / Ambarish On Thu, Jul 7, 2011 at 3:00 PM, [email protected] <[email protected] > wrote: > that sounds a lot like an actual installation issue. > What database are you using? Did you check if the database and the > tables are created during installation process? > I guess there is not a single table as the application was never able > to connect to the database? > > Sebastian > > 2011/7/6 ambairish kumar <[email protected]>: > > > > Table does not error while running openmeetings .. > > > > what might have gone wronge......:) > > > > > > > > > > ERROR 07-06 20:58:32.374 AppointmentDaoImpl.java 40359 1004 > > org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl > > [Red5_Scheduler_Worker-4] - Error in getTodaysAppoitmentsForA > > llUsers : > > org.hibernate.exception.SQLGrammarException: could not execute query > > at > > > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) > > [hibernate3.jar:3.6.1.Final] > > at > > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.loader.Loader.doList(Loader.java:2536) > > [hibernate3.jar:3.6.1.Final] > > at > > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.loader.Loader.list(Loader.java:2271) > > [hibernate3.jar:3.6.1.Final] > > at > org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) > > [hibernate3.jar:3.6.1.Final] > > at > > > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) > > [hibernate3.jar:3.6.1.Final] > > at > > > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > > [hibernate3.jar:3.6.1.Final] > > at > > > org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl.getTodaysAppointmentsForAllUsers(AppointmentDaoImpl.java:998) > > [openmeetings.jar:na] > > at > > > org.openmeetings.app.data.calendar.management.AppointmentLogic.doScheduledMeetingReminder(AppointmentLogic.java:331) > > [openmeetings.jar:na] > > at > > > org.openmeetings.app.quartz.scheduler.QuartzMeetingReminderJob.execute(QuartzMeetingReminderJob.java:18) > > [openmeetings.jar:na] > > at > > > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzSchedulingServiceJob.java:59) > > [red5.jar:na] > > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > > [quartz-1.6.5.jar:1.6.5] > > at > > > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) > > [quartz-1.6.5.jar:1.6.5] > > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table > > 'openmeetings.meeting_members' doesn't exist > > at sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown > > Source) [na:na] > > at > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > [na:1.6.0] > > at > java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > [na:1.6.0] > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.Util.getInstance(Util.java:382) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at > > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at > > > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) > > [mysql-connector-java-5.1.15-bin.jar:na] > > at > > > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) > > [c3p0-0.9.1.jar:0.9.1] > > at > > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > > [hibernate3.jar:3.6.1.Final] > > at > > > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) > > [hibernate3.jar:3.6.1.Final] > > at org.hibernate.loader.Loader.doList(Loader.java:2533) > > [hibernate3.jar:3.6.1.Final] > > ... 13 common frames omitted > > ERROR 07-06 20:58:35.249 Sessionmanagement.java 43234 605 > > org.openmeetings.app.data.basic.Sessionmanagement > [Red5_Scheduler_Worker-2] > > - clearSessionTable > > java.lang.NullPointerException: null > > at > > > org.openmeetings.app.data.basic.Sessionmanagement.clearSessionTable(Sessionmanagement.java:592) > > [openmeetings.jar:na] > > at > > > org.openmeetings.app.quartz.scheduler.QuartzSessionClear.execute(QuartzSessionClear.java:24) > > [openmeetings.jar:na] > > at > > > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzSchedulingServiceJob.java:59) > > [red5.jar:na] > > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > > [quartz-1.6.5.jar:1.6.5] > > at > > > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) > > [quartz-1.6.5.jar:1.6.5] > > > > > > -- > > Ambarish Kumar Lowsarwar > > > > -- > > You received this message because you are subscribed to the Google Groups > > "OpenMeetings User" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > > http://groups.google.com/group/openmeetings-user?hl=en. > > > > > > -- > Sebastian Wagner > http://www.webbase-design.de > http://openmeetings.googlecode.com > http://www.wagner-sebastian.com > [email protected] > > -- > You received this message because you are subscribed to the Google Groups > "OpenMeetings User" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/openmeetings-user?hl=en. > > -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
