Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error 1213 for Multi Proxies #109

Open
PanHaskins opened this issue Aug 9, 2023 · 4 comments
Open

SQL error 1213 for Multi Proxies #109

PanHaskins opened this issue Aug 9, 2023 · 4 comments
Assignees
Labels
good first issue Good for newcomers medium priority This bug/suggestion needs medium priority question Further information is requested

Comments

@PanHaskins
Copy link

PanHaskins commented Aug 9, 2023

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
Copy link
Collaborator

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

@PanHaskins
Copy link
Author

PanHaskins commented Aug 14, 2023

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
Copy link
Collaborator

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

@Laurenshup Laurenshup self-assigned this Dec 13, 2023
@Laurenshup Laurenshup added this to the 9.6-THANATOS milestone Dec 13, 2023
@Laurenshup Laurenshup added good first issue Good for newcomers medium priority This bug/suggestion needs medium priority labels Dec 13, 2023
@Laurenshup
Copy link
Collaborator

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.

@Laurenshup Laurenshup added the question Further information is requested label Mar 16, 2024
@Laurenshup Laurenshup removed this from the 9.6-THANATOS milestone Mar 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers medium priority This bug/suggestion needs medium priority question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants