Open Source Document Management System | OpenKM

Open km works fine, no problem, but after setting MYSQL database, I get different errors :

1. language error
2. status1 error in your MySQL version statement
3. can not connect database
4. can not execute

I am just getting these errors randomly after playing with configuration for more than 20 hours .

Can you suggest me good MySQL script. I think the error is MySQL setting only.

You might restart entire OpenKM database configuration, it's quite easy, only take in consideration you will lost anything you have into the OpenKM now.
Steps:
1- Stop OpenKM
2- Delete folder $TOMCAT_HOME/repository
3- Edit OpenKM.cfg and set hibernate.hbm2ddl=create
4- Start OpenKM

I did it, now this is the error:

localhost showing this:
org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Tue May 30 10:31:30 PDT 2017

startup is showing this in various areas:
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 'select1' at line 1

Seems you have something wrong in your server.xml section where is set the connection.

ok i check it.

First tell me there is wiki of community 5 or 6 version mysql which have okmdb setup method. I tried it.

Sometimes, if I get error of okm_language or okmdb.users n something like this, those table data are created automatically when I enable the openkm.cfg is equal to create n delete respiratory and start openkm or I am missing table creation from wiki as well.

You must follow the new documentation https://docs.openkm.com/kcenter/view/ok ... riadb.html

I downloaded the open dev version of 1.2 gb, when I try to run GWt from eclipse or startup of tomcat.

I get reverse heap object space error. What's that!

Did you download portable dev into 64 bits computer ( you should do it ).
You need to install jdk 64 bits and use it to starting the server, etc... the problem in deep is portable eclipse edition only works with 32 bits, that means the embeded jdk what comes with portable is also 32 bit, but 32 bits JVM have problem to use more than 2GB RAM and others related with free memory, that might be the reason why you have this issue.