#Connecting Skript to MySQL

1 messages · Page 1 of 1 (latest)

uneven sable
#

I am trying to connect some of my Skript variables on a velocity network together so I can save some variables across multiple servers. I read all I could in the config of Skript. I set up the MySQL database (that I know is working) and I got SQLibrary from this link I found in the config.sk: https://dev.bukkit.org/projects/sqlibrary/files

It does not work. I get an error when I restart the servers. I know the MySQL database is up and working and I have the correct credentials. The only thing I saw that was weird is that the SQLibrary says it is for minecraft version 1.7...

I looked up answers online but couldn't really find anything.

Anyone know how I can fix this?

quaint venture
#

you are right in thinking the sqlibrary dep is outdated, that is likely the source of this issue
there is an effort to get SQL support working again (see this pr) but it looks like until the pr is merged, SQL support is broken
i have heard that using skript-db is broken on recent versions too

uneven sable
#

so are you just saying its not possible on the later versions of minecraft?

#

@quaint venture

quaint venture
#

unless someone suggests a different method, all my ideas would not work on 1.18+ servers until the pr is merged
i am personally looking forward to SQL database integration for better integration between my servers (without a proxy/redisbungee, using just transfer packets) and i have unfortunately not found a way

uneven sable
#

okay

uneven sable
quaint venture
#

Skript is an open source plugin, anyone can make a pull request (pr) to add or fix the code
currently, Skript is using an outdated library for its SQL system
LimeGlass (the author of this pull request who wants to fix this: https://github.com/SkriptLang/Skript/pull/5646) made an update to fix the code, however it has not been accepted by the skript maintainers yet
when the pr is accepted (and merged) then the feature will work
nobody knows when the feature will be accepted and merged, we will just have to be patient

uneven sable
#

epic

#

thanks for explaining

uneven sable
#

didnt work for me

#

1.20.6

quaint venture
#

heard that it didnt work past 1.20.5 (even as low as 1.20 for some people)

ionic gull
#

tbf 20.5 changed a lot of stuff

ionic gull
#

or did you change shit

#

i had to change a lot of stuff to actually get it to work

quaint venture
#

what did you change in the config to make it work?

uneven sable
uneven sable
ionic gull