Skript icon indicating copy to clipboard operation
Skript copied to clipboard

⚠ SQLibrary 7.1 no longer functions on newer Paper builds

Open Brickgard opened this issue 4 years ago • 5 comments

Description

As of Paper build #587 some MySQL elements have changed, requiring some sort of class update for anything that uses MySQL. Because of this, as of that build MySQL databases cannot be used by Skript.

Steps to Reproduce

Paper build #587+ Skript + SQLibrary 7.1 no longer connects to a MySQL Database Reverting to Paper build #586 still operates fine.

Errors

[13:02:25 WARN]: [Skript][MySQL] MySQL DataSource class missing: com.mysql.jdbc.jdbc2.optional.MysqlDataSource. [13:02:25 ERROR]: #!#! [13:02:25 ERROR]: #!#! ===!!!=== Skript variable load error ===!!!=== [13:02:25 ERROR]: #!#! Unable to load (all) variables: [13:02:25 ERROR]: #!#! Cannot connect to the database 'MySQL database'! Please make sure that all settings are correct and that the database software is running. [13:02:25 ERROR]: #!#! [13:02:25 ERROR]: #!#! Skript will work properly, but old variables might not be available at all and new ones may or may not be saved until Skript is able to create a backup of the old file and/or is able to connect to the database (which requires a restart of Skript)! [13:02:25 ERROR]: #!#!

Server Information

Paper build Latest (or any build past #587) Minecraft 1.16.5

Comments

I keep thinking there's a more "modern" solution to storing Skript variables in an SQL database, but my months of searching continually come up empty. If SQLibrary is depreciated, what replaced it?

Brickgard avatar May 06 '21 18:05 Brickgard

do we really need this 2 functions? i think SessionCommit(immediately:true|false) is all we need. Also this should be in against Lucee 7.1, not 7.0.

michaeloffner avatar Dec 01 '25 14:12 michaeloffner