Stefan1200's Forum

JTS3ServerMod Hosting Edition => JTS3ServerMod MySQL & WebInterface => Topic started by: edwald on July 24, 2016, 06:41:49 PM

Title: MySQL or Java error?
Post by: edwald on July 24, 2016, 06:41:49 PM
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?
Title: Re: MySQL or Java error?
Post by: 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.
Title: Re: MySQL or Java error?
Post by: edwald on July 24, 2016, 07:35:19 PM
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.