MySQL or Java error?

Started by edwald, July 24, 2016, 06:41:49 PM

Previous topic - Next topic

edwald

Hello everyone,

I just reset my VPS reinstalling all applications that I use. I tried to start the process, but it show this error:

2016-07-24 18:37:00   START_MANAGER   JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016) Instance Manager started...
2016-07-24 18:37:00   CONFIG   Loading InstanceManager config file from: /home/jts3servermod/config/JTS3ServerMod_InstanceManager.cfg
2016-07-24 18:37:00   CONFIG   Bot chat command !exec is disabled!
2016-07-24 18:37:00   CONFIG   Multi IP Mode disabled!
2016-07-24 18:37:00   CONFIG   Automatic MySQL log delete for entries older than 28 days is activated!
2016-07-24 18:37:00   CONFIG   Automatic MySQL connection log delete for entries older than 28 days is activated!
2016-07-24 18:37:01   LOGGER_SQL_CONNECT   Successfully connected to MySQL server for logging!
2016-07-24 18:37:01   CONFIG   MySQL mode enabled!
2016-07-24 18:37:01   MYSQL_ERROR   Error while connecting to database: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'admin_jts3servermod.jts3servermod_instances' doesn't exist
2016-07-24 18:37:01   JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016): EXCEPTION
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'admin_jts3servermod.jts3servermod_instances' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.Util.getInstance(Util.java:387)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)
   at de.stefan1200.jts3servermod.f.e(Unknown Source)
   at de.stefan1200.jts3servermod.f.c(Unknown Source)
   at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
   at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
2016-07-24 18:37:01   QUIT_MANAGER   InstanceManager config file at "/home/jts3servermod/config/JTS3ServerMod_InstanceManager.cfg" does not exists, is not valid or an error while connecting to the database occurred, quitting now...

How can I solve this problem?

Stefan1200

Just import a backup of your database again. If this is not possible, just remove the config file of the web interface from the config directory and open the install.php again.

edwald

Quote from: Stefan1200 on July 24, 2016, 06:50:38 PM
Just import a backup of your database again. If this is not possible, just remove the config file of the web interface from the config directory and open the install.php again.

Solved.
I forgot to install the webinterface.

Thanks for the support.