INSERT INTO BUG? #13

New Issue

2021-06-26T02:43:45Z

PMencrp commented

2021-06-26 02:43:45 +00:00

(Migrated from github.com)

execute "INSERT INTO user (playeruuid,playerid) VALUES (%uuid of player%,%player%) ON DUPLICATE KEY UPDATE playeruuid=VALUES(playeruuid),playerid=VALUES(playerid)" in {-sql}

This is my code and this code doesn't work
The reason is because my values contain variables
If my value is 123 or ""abc"" today, there will be no error
Here is a screenshot of my error

My version is the latest version

execute "INSERT INTO `user` (`playeruuid`,`playerid`) VALUES (%uuid of player%,%player%) ON DUPLICATE KEY UPDATE `playeruuid`=VALUES(`playeruuid`),`playerid`=VALUES(`playerid`)" in {-sql} This is my code and this code doesn't work The reason is because my values contain variables If my value is 123 or ""abc"" today, there will be no error Here is a screenshot of my error ![image](https://user-images.githubusercontent.com/37236933/123499726-5c1a3c00-d66b-11eb-8fd6-69ec2778da72.png) My version is the latest version

PMencrp commented

2021-06-26 03:37:15 +00:00

(Migrated from github.com)

i was try change the player to a var or name of player but still don't work

PMencrp commented

2021-06-26 03:41:54 +00:00

(Migrated from github.com)

execute "INSERT INTO user (playeruuid, playerid) VALUES (%uuid of player%,%name of player%)" in {-sql}

still don't work

execute "INSERT INTO user (playeruuid, playerid) VALUES (%uuid of player%,%name of player%)" in {-sql} still don't work

PMencrp commented

2021-06-26 03:42:46 +00:00

(Migrated from github.com)

![image](https://user-images.githubusercontent.com/37236933/123500867-9e477b80-d673-11eb-8df6-2df1f0422607.png)

ham1255 commented

2021-06-26 04:15:11 +00:00

(Migrated from github.com)

try using this version
https://github.com/Limework/skript-db/releases/tag/1.3.2

try using this version https://github.com/Limework/skript-db/releases/tag/1.3.2

PMencrp commented

2021-06-26 05:02:22 +00:00

(Migrated from github.com)

yep i am use this version

PMencrp commented

2021-06-26 05:11:21 +00:00

(Migrated from github.com)

aww I tried to drop the skript version back to 2.5 and amazingly it worked!

ham1255 commented

2021-06-26 07:05:58 +00:00

(Migrated from github.com)

yes skript 2.6 broke something
@GovindasOM you might need to look at this

yes skript 2.6 broke something @GovindasOM you might need to look at this

GovindasOM commented

2021-06-26 10:13:18 +00:00

(Migrated from github.com)

I wasn't sure how to fix this so I asked TPGamesNL for help, could you try this jar if it solves your issue? (I do not have time to test it myself right now)
skript-db.zip

I wasn't sure how to fix this so I asked TPGamesNL for help, could you try this jar if it solves your issue? (I do not have time to test it myself right now) [skript-db.zip](https://github.com/Limework/skript-db/files/6719929/skript-db.zip)

Sign in to join this conversation.