-
Notifications
You must be signed in to change notification settings - Fork 5
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
Can't insert a new entry in my database #8
Comments
Does |
Yes, it says : |
Hello, do you have anything new about the problem ? If I execute SQL command in CLI it works perfectly |
Skript's date class cannot be stored directly in a database. I'll add a way to convert Skript dates into SQL dates. |
Yeah, it works perfectly when I convert date to text :) |
any updates? |
Hello,
I have a problem when I want to do an "INSERT INTO" query to my SQL server it does nothing. I've tested with 1.11.2 - 1.12.1 - 1.12.2 Minecraft's version but it does not work :/ I can do a "SELECT" query it works but not an insert ... In the past it worked perfectly (in another server).
No errors in the console. I tested my server's mysql user and root user.
Informations:
Skript dev35b (tested with dev34)
Skript code :
execute "INSERT INTO `players` (`name`, `uuid`, `rank`, `works`, `friend_invitation`, `register_date`, `last_seen`, `last_ip`) VALUES (%name of player%, %UUID of player%, 'Joueur', '', 'allow', %now%, %now%, %ip of player%)" in {sql}
Plugins: Skript, skript-db, skript-mirror
Thanks for your help :)
The text was updated successfully, but these errors were encountered: