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.
