Missing Tables

[emily.beckett]

Hi,

I have installed open KM with a MySQL database, however I seem to have a couple of tables missing.

I have followed the KB article, http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2 and set my OpenKM.cfg to:

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.hbm2ddl=create

The majoriy of the tables look to have been created (see attached view from MySQL Workbench)

However when I log in I get the attached error.

In my Catalina log file I get the below messages:

Code: Select all

2014-06-23 14:19:39,039 [http-apr-0.0.0.0-8080-exec-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1146, SQLState: 42S02
2014-06-23 14:19:39,040 [http-apr-0.0.0.0-8080-exec-1] ERROR org.hibernate.util.JDBCExceptionReporter- Table 'okmdb.okm_activity' doesn't exist
2014-06-23 14:19:39,040 [http-apr-0.0.0.0-8080-exec-1] ERROR com.openkm.util.UserActivity- could not insert: [com.openkm.dao.bean.Activity]
2014-06-23 14:19:40,252 [http-apr-0.0.0.0-8080-exec-10] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1064, SQLState: 42000
2014-06-23 14:19:40,252 [http-apr-0.0.0.0-8080-exec-10] ERROR org.hibernate.util.JDBCExceptionReporter- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 nodebase0_.NBS_UUID as col_0_0_ from OKM_NODE_BASE nodebase0_ where nodebase0_' at line 1
2014-06-23 14:19:40,342 [http-apr-0.0.0.0-8080-exec-10] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 1146, SQLState: 42S02
2014-06-23 14:19:40,342 [http-apr-0.0.0.0-8080-exec-10] ERROR org.hibernate.util.JDBCExceptionReporter- Table 'okmdb.okm_activity' doesn't exist
2014-06-23 14:19:40,342 [http-apr-0.0.0.0-8080-exec-10] ERROR com.openkm.util.UserActivity- could not insert: [com.openkm.dao.bean.Activity]

[emily.beckett]

I am also getting this error in the Catalina log, what version of MySQL is supported in Open KM 6.3? I have MySQL 5.6

2014-06-24 08:57:57,719 [pool-2-thread-1] INFO com.openkm.servlet.RepositoryStartupServlet- *** Initialize language detection engine... ***
2014-06-24 08:57:58,115 [pool-2-thread-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: 1146, SQLState: 42S02
2014-06-24 08:57:58,115 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter- Table 'okmdb.okm_config' doesn't exist
2014-06-24 08:57:58,116 [pool-2-thread-1] ERROR com.openkm.core.Config- ** Error reading configuration table **
2014-06-24 08:57:58,117 [pool-2-thread-1] INFO com.openkm.servlet.RepositoryStartupServlet- *** Repository initializing... ***
2014-06-24 08:57:58,135 [pool-2-thread-1] WARN org.hibernate.util.JDBCExceptionReporter- SQL Error: 1064, SQLState: 42000
2014-06-24 08:57:58,135 [pool-2-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 nodebase0_.NBS_UUID as col_0_0_ from OKM_NODE_BASE nodebase0_ where nodebase0_' at line 1
2014-06-24 08:57:58,135 [pool-2-thread-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 nodebase0_.NBS_UUID as col_0_0_ from OKM_NODE_BASE nodebase0_ where nodebase0_' at line 1

[pavila]

Have you modified the file $TOMCAT_HOME/conf/server.xml ?