Databases error - Githubissues

SbirTeo commented 2 years ago

Description of issue or feature request:

DELETE THIS SECTION IF YOU ARE SUBMITTING A FEATURE REQUEST

ERROR (DELETE IF YOU HAVE NO ERROR):

####################
[00:02:44 WARN]: java.sql.SQLSyntaxErrorException: Table 'MAGIC_CMI_Vanilla.CMI_users' doesn't exist
[00:02:44 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
[00:02:44 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
[00:02:44 WARN]:        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
[00:02:44 WARN]:        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)
[00:02:44 WARN]:        at CMI.jar//com.Zrips.CMI.Modules.DataBase.DBDAO.getId(DBDAO.java:1114)
[00:02:44 WARN]:        at CMI.jar//com.Zrips.CMI.Modules.DataBase.DBDAO.getUserIds(DBDAO.java:1442)
[00:02:44 WARN]:        at CMI.jar//com.Zrips.CMI.Modules.DataBase.DBManager.saveBatch(DBManager.java:530)
[00:02:44 WARN]:        at CMI.jar//com.Zrips.CMI.Modules.DataBase.DBManager$1$1.run(DBManager.java:342)
[00:02:44 WARN]:        at org.bukkit.craftbukkit.v1_18_R1.scheduler.CraftTask.run(CraftTask.java:101)
[00:02:44 WARN]:        at org.bukkit.craftbukkit.v1_18_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
[00:02:44 WARN]:        at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[00:02:44 WARN]:        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
[00:02:44 WARN]:        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[00:02:44 WARN]:        at java.base/java.lang.Thread.run(Thread.java:833)
####################

CONFIG SECTION (DELETE IF NOT RELEVANT):

#####################################
## PASTE RELEVANT CONFIG SECTION HERE ##
#####################################

Latest version of CMI and server 1.18.1

I created a new Database and happen this

Zrips commented 2 years ago

Check startup logs if server properly loaded up or not, this usually is a result of failed database table creation for one or another reason.

SbirTeo commented 2 years ago

The server startup log is clean. No errors. Database connection starter successfully. This error happens later...

Il Mer 16 Feb 2022, 12:23 Zrips @.***> ha scritto:

Check startup logs if server properly loaded up or not, this usually is a result of failed database table creation for one or another reason.

— Reply to this email directly, view it on GitHub https://github.com/Zrips/CMI/issues/6650#issuecomment-1041386705, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASCH4RRAIVDHZDGYYZ6DWM3U3OCLHANCNFSM5OJ3H74A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

Zrips commented 2 years ago

Could you confirm that your database contains database with name of MAGIC_CMI_Vanilla and table with name of CMI_users?

Zrips commented 2 years ago

Ok, while checking code, it looks more like you have set table prefix to be "MAGIC_CMIVanilla.CMI" in your dataBaseInfo.yml file. Is that correct?

SbirTeo commented 2 years ago

It doesn't create tables in the database. Mysql connection start witouth errors but it doesn't create tables. In my others server it works fine.

Il Mer 16 Feb 2022, 12:33 Zrips @.***> ha scritto:

Ok, while checking code, it looks more like you have set table prefix to be "MAGIC_CMIVanilla.CMI" in your dataBaseInfo.yml file. Is that correct?

— Reply to this email directly, view it on GitHub https://github.com/Zrips/CMI/issues/6650#issuecomment-1041395088, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASCH4RWSK3C5WNFUCFQDBKTU3ODQZANCNFSM5OJ3H74A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

Zrips commented 2 years ago

Check your dataBaseInfo.yml if its properly setup . But what i'm interested in would be to know what you have set for tablePrefix in dataBaseInfo.yml

SbirTeo commented 2 years ago

Table prefix is CMI_ It's the same of the others server but i use different databases. I had never errors.

Il Mer 16 Feb 2022, 12:56 Zrips @.***> ha scritto:

Check your dataBaseInfo.yml if its properly setup . But what i'm interested in would be to know what you have set for tablePrefix in dataBaseInfo.yml

— Reply to this email directly, view it on GitHub https://github.com/Zrips/CMI/issues/6650#issuecomment-1041412108, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASCH4RRF5IAHDGF63JRBTNDU3OGFNANCNFSM5OJ3H74A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

Zrips commented 2 years ago

Could be caused by outdated MySQL database on your new server in general. Could I see actual startup log for CMI? While there might not be actual errors, there still should be extra indicator when database is being created which might help out to figure out why its failing.

SbirTeo commented 2 years ago

[19:18:40] [Server thread/INFO]: [CMI] Enabling CMI v9.1.1.2 [19:18:41] [Server thread/INFO]: ┏━━━┓ ┏━┓┏━┓ ┏━━┓ [19:18:41] [Server thread/INFO]: ┃┏━┓┃ ┃ ┗┛ ┃ ┗┫┣┛ [19:18:41] [Server thread/INFO]: ┃┃ ┗┛ ┃┏┓┏┓┃ ┃┃ [19:18:41] [Server thread/INFO]: ┃┃ ┏┓ ┃┃┃┃┃┃ ┃┃ [19:18:41] [Server thread/INFO]: ┃┗━┛┃ ┃┃┃┃┃┃ ┏┫┣┓ [19:18:41] [Server thread/INFO]: ┗━━━┛ ┗┛┗┛┗┛ ┗━━┛ [19:18:41] [Server thread/INFO]: [19:18:41] [Server thread/INFO]: Integrating PaperSpigot async methods [19:18:41] [Server thread/INFO]: 55 Enabled and 1 Disabled modules [19:18:41] [Server thread/INFO]: Permission plugin: LuckPerms5.3.98 [19:18:41] [Server thread/INFO]: Initialized Cipher256 AES [19:18:41] [Server thread/INFO]: Loaded (59) regular alias into memory. Took 41ms [19:18:41] [Server thread/INFO]: Loaded (1) custom text's into memory. Took 0ms [19:18:41] [Server thread/INFO]: Detected Java17

data base type detected [19:18:41] [Server thread/INFO]: Started MySQL data base. Took 469ms [19:18:41] [Server thread/INFO]: Vault was found - Enabling capabilities. Economy: CMIEconomy [19:18:42] [Server thread/INFO]: Loaded (7) holograms into memory. Took 15ms [19:18:42] [Server thread/INFO]: Loaded (5) warning categories into memory. Took 0ms [19:18:42] [Server thread/INFO]: Loaded (3) warning commands into memory. Took 0ms [19:18:42] [Server thread/INFO]: Loaded (138) custom mob heads into memory. Took 14ms [19:18:42] [Server thread/INFO]: Loaded (0) cooldowns into memory. Took 20ms [19:18:42] [Server thread/INFO]: Enabling BungeeCord Support [19:18:42] [Server thread/INFO]: Initializing BungeeCord [19:18:42] [Server thread/INFO]: Loaded (5) kits into memory. Took 28ms [19:18:42] [Server thread/INFO]: Loaded (7) ranks into memory. Took 8ms [19:18:42] [Server thread/INFO]: Loaded (8) playtime rewards into memory. Took 1ms [19:18:42] [Server thread/WARN]: java.sql.SQLSyntaxErrorException: Table 'MAGIC_CMI_BedWars.CMI_users' doesn't exist

com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)

com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)

CMI.jar//com.Zrips.CMI.Modules.DataBase.DBDAO.loadAllUsers(DBDAO.java:1211)

CMI.jar//com.Zrips.CMI.PlayerManager.loadData(PlayerManager.java:587)

CMI.jar//com.Zrips.CMI.CMI.onEnable(CMI.java:1516)

org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)

org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:370)

org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:500)

org.bukkit.craftbukkit.v1_18_R1.CraftServer.enablePlugin(CraftServer.java:564)

org.bukkit.craftbukkit.v1_18_R1.CraftServer.enablePlugins(CraftServer.java:478)

net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:727)

net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:503)

net.minecraft.server.dedicated.DedicatedServer.e(DedicatedServer.java:313)

net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1202)

net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:317)

java.base/java.lang.Thread.run(Thread.java:833) [19:18:42] [Server thread/INFO]: Loaded (0) player data into memory. Took 6ms [19:18:42] [Server thread/WARN]: java.sql.SQLSyntaxErrorException: Table 'MAGIC_CMI_BedWars.CMI_playtime' doesn't exist

com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)

com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)

CMI.jar//com.Zrips.CMI.Modules.DataBase.DBDAO.loadPlayTimes(DBDAO.java:1235)

CMI.jar//com.Zrips.CMI.PlayerManager.loadData(PlayerManager.java:610)