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

Can't insert a new entry in my database #8

Open
Diamax10 opened this issue May 23, 2018 · 6 comments
Open

Can't insert a new entry in my database #8

Diamax10 opened this issue May 23, 2018 · 6 comments
Labels

Comments

@Diamax10
Copy link

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 :)

@btk5h
Copy link
Owner

btk5h commented May 24, 2018

Does the last database error contain anything after executing that statement?

@Diamax10
Copy link
Author

Yes, it says : Invalid argument value: java.io.NotSerializableException

@Diamax10
Copy link
Author

Diamax10 commented May 28, 2018

Hello, do you have anything new about the problem ?

If I execute SQL command in CLI it works perfectly

@btk5h btk5h added the bug label May 28, 2018
@btk5h
Copy link
Owner

btk5h commented May 28, 2018

Skript's date class cannot be stored directly in a database. I'll add a way to convert Skript dates into SQL dates.

@Diamax10
Copy link
Author

Yeah, it works perfectly when I convert date to text :)

@Hakim567
Copy link

any updates?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants