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.
