enabled MySQL break whole groups.yml file

[xNikees911]

Server version

Spigot 1.17.1 (paper latest)

TAB version

3.1.0

Describe the bug

Hi, I have enabled MySQL support, setup whole groups.yml file and after enabled mysql all not working from this file per rank. Only header and footer from config.yml work fine. But when I disable one more time mysql support all gonna work fine. I have weight in in LuckPerms, also I have primary-group-finding-list feature with same weights like in LuckPerms. I my opinion MySQL breaks whole groups.yml and there is problem. Also when I have enabled mysql I have blank tables in tab_groups database.

Expected behavior

None

Steps to reproduce

I wrote above

Additional info

No response

Checklist

• I am running latest version of the plugin
• I have read the wiki to make sure it's not an issue with configuration
• I have read the Compatibility wiki page and am not trying to run the plugin on an unsupported server version / platform

[Tanguygab]

well the whole point of the MySQL feature is to store properties in a remote database instead of local files.... so of course groups.yml is completely ignroed, as specified on the wiki

[xNikees911]

well the whole point of the MySQL feature is to store properties in a remote database instead of local files.... so of course groups.yml is completely ignroed, as specified on the wiki

Okey, but when mysql support is enabled my TAB per rank not work :) when mysql is disabled all work fine so it's error there :)

[NEZNAMY]

Error that your mysql table is empty and therefore nothing can be displayed?

[xNikees911]

Error that your mysql table is empty and therefore nothing can be displayed?

In the config.yml file at the very bottom, MySQL options are turned ON. I have all ranks set in the groups.yml file. When the MySQL option is ON, when I click the tab button, my nickname does not change in relation to any rank that I set in your plugin. When MySQL is OFF, when I click the tab button all ranks will display correctly with their prefixes and others. This is what the problem is all about here. I don't know how to explain it better.

MySQL turned ON (tab view)

and all not work there (I don't have any prefix, colors etc.)

MySQL turned OFF (tab view)

all there work fine but the sork list not work good.
xNikees911 should be first (on top)
Krzysztof2013 (second)
DeCanecorso (third)
I have weights in LuckPerms and also primary-group-finding-list like below:

[NEZNAMY]

Run /tab mysql upload and /tab reload and all of your problems will be magically solved.

[xNikees911]

Still same, also got only 6 ranks from 16 like in groups.yml file

TAB view still not work

[NEZNAMY]

So upload command didn't upload everything? It looks like you didn't even read the mysql wiki page in the first place, despite saying you did. Support is only provided to buyers on discord. What you said so far is not a bug, but the way mysql function works.

[xNikees911]

Bro, I got also error in your errors file

In groups file I have 16 ranks

but in database I have only 6 ranks, so how?
Your /tab mysql upload and after /tab reload work fine, but not uploading all ranks :)

[NEZNAMY]

Error shows upload command failed due to an error. Will be fixed in the next version.

[xNikees911]

Why I don't see any prefix, colors on tab from setup ranks? like for Wlasciciel rank from screenshot above.

[xNikees911]

Why I don't see any prefix, colors on tab from setup ranks? like for Wlasciciel rank from screenshot above.

any help for that? or it's bug

[NEZNAMY]

Conversion bug will be fixed in the next version. Casual help is not provided here.

[NEZNAMY]

Turns out group names are case-sensitive when loading from MySQL. I will solve that too.

[xNikees911]

Turns out group names are case-sensitive when loading from MySQL. I will solve that too.

And you see :) It was better to write that this is not a mistake and you will not help me, and it was enough to check ...

But I would like you to answer me too, does the fact that I do not see any colors / rank prefixes from mysql (which is set after e.g. the rank I test is in the database) does not work because of this next error? And if I set it wrong, can you tell me how to fix it? According to the wiki, I'm doing everything right and I have no idea why it doesn't work.

[NEZNAMY]

I already said it's a bug which will be fixed in the next version.