search

BlackDemonZyT / BotSentry

Official repository for Bot-Sentry issues, information, etc..
6 stars 0 forks source link

SQL error 1213 for Multi Proxies #109

Open PanHaskins opened 1 year ago

PanHaskins commented 1 year ago

Proxies version: Flamecord 1.5.9 BotSentry 9.5.3

Each Bungeecord has this bug at different times. None is the same. No one even has to be on the server for it to do it.

Proxy Log 1: [20:55:17 INFO]: (!) SQL error is 1213. [20:56:17 INFO]: (!) SQL error is 1213. [13:29:17 INFO]: (!) SQL error is 1213. [13:30:17 INFO]: (!) SQL error is 1213.

Proxy Log 2: [00:32:52 INFO]: (!) SQL error is 1213. [00:33:53 INFO]: (!) SQL error is 1213. [00:35:53 INFO]: (!) SQL error is 1213. [03:03:28 INFO]: (!) SQL error is 1213. [03:06:29 INFO]: (!) SQL error is 1213.

Laurenshup commented 1 year ago

This message is not displayed at the same time? What is your database setup?

PanHaskins commented 1 year ago 
whitelist-database-sync:
  enabled: true
  cachetime: 120

mysql:
  settings:
    updateinterval: 60
  port: 3306
  username: "asfasafasf"
  database: "s1_databasename"
  password: "bestpasswordever"
  ip: "141.141.141.141"
  enabled: true
Laurenshup commented 9 months ago

Seems like the MySQL needs recoding in order to sync the servers with each other.

Laurenshup commented 6 months ago

Hmm, when investigating more, I am unsure if this is really is caused because of sync problems. Is this still happening, and can you tell me how the database looks like? This might be caused because of incorrect versions.