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

Too long nick #13

Closed
SmigloNPC opened this issue Dec 23, 2020 · 1 comment
Closed

Too long nick #13

SmigloNPC opened this issue Dec 23, 2020 · 1 comment
Labels
bug Something isn't working

Comments

@SmigloNPC
Copy link

Hello
I notice that when player's nickname is 16 characters long console send error:
[21:48:44 ERROR]: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'Name' at row 1 [21:48:44 ERROR]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3931) [21:48:44 ERROR]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) [21:48:44 ERROR]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) [21:48:44 ERROR]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) [21:48:44 ERROR]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) [21:48:44 ERROR]: at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1536) [21:48:44 ERROR]: at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2585) [21:48:44 ERROR]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1464) [21:48:44 ERROR]: at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120) [21:48:44 ERROR]: at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java) [21:48:44 ERROR]: at eu.horyzon.premiumconnector.session.PlayerSession.update(PlayerSession.java:46) [21:48:44 ERROR]: at eu.horyzon.premiumconnector.task.PremiumCheck.run(PremiumCheck.java:65) [21:48:44 ERROR]: at net.md_5.bungee.scheduler.BungeeTask.run(BungeeTask.java:66) [21:48:44 ERROR]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [21:48:44 ERROR]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [21:48:44 ERROR]: at java.base/java.lang.Thread.run(Thread.java:834) [21:48:44 WARN] [PremiumConnector]: SQL exception when trying to load TrevorPLLLLLLLLL account.

Why is "Name" column limited to 15 characters?

@Corenb
Copy link
Owner

Corenb commented Dec 27, 2020

This varchar length is the default length used in (almost) all plugins cause Mojang limits Minecraft username to 15 chars.

You can modify yourself the database structure to allow more than 15 chars.

@Corenb Corenb closed this as completed Dec 27, 2020
@Corenb Corenb added bug Something isn't working wontfix This will not be worked on labels Dec 28, 2020
@Corenb Corenb removed the wontfix This will not be worked on label Jan 27, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants