FastLogin: Connection is not available

What happened?

When players try to log in, an error is displayed on the console saying that the connection is not available, but this only happens if the players do not have /premium activated. I tried increasing the timeout or using another database, but it didn’t work. The plugin starts correctly and does not show any errors but when someone tries to join it happens that.

All this started to happen after updating the waterfall to the latest version

What did you expect?

That the plugin works correctly

Steps to reproduce

connect with a non-premium account to server waterfall #520

Plugin list

floodgate, Geyser, ServerUtils, minimotd, LuckPerms, SkinsRestorer, FastLogin

Configuration file

https://hastebin.com/share/biyewupuyo.yaml

Server log

https://hastebin.com/share/ovijozemov.csharp

Plugin version

1.12-SNAPSHOT-7d7d91f

Platform

BungeeCord

Relevance

I tried the latest build (build refers to development builds not necessary a release version)
I checked for existing tickets - If there are, please vote them with a thumps reaction and not create new ones

About this issue

Original URL
State: open
Created a year ago
Comments: 16 (6 by maintainers)

Commits related to this issue

Based on #1022, using only one conection, closing and oppening property, and don't return the profiles before resultset and statement closes — committed to FabioZumbi12/FastLogin by deleted user a year ago

Most upvoted comments

Your database structure is incorrect. Do you imported or manually created the table? Please let FastLogin create the table again or manually adjust it using:. FastLogin depends on the behavior of the database system.

ALTER TABLE premium CHANGE UserID int(11) AUTO_INCREMENT PRIMARY KEY; ADD CONSTRAINT UNIQUE(Name)`

+-----------+--------------+------+-----+---------------------+----------------+
| Field     | Type         | Null | Key | Default             | Extra          |
+-----------+--------------+------+-----+---------------------+----------------+
| UserID    | int(11)      | NO   | PRI | NULL                | auto_increment |
| UUID      | char(36)     | YES  |     | NULL                |                |
| Name      | varchar(16)  | NO   | UNI | NULL                |                |
| Premium   | tinyint(1)   | NO   |     | NULL                |                |
| LastIp    | varchar(255) | NO   |     | NULL                |                |
| LastLogin | timestamp    | NO   |     | current_timestamp() |                |
+-----------+--------------+------+-----+---------------------+----------------+

games647 on Apr 13, 2023