search

btk5h / skript-db

MIT License
5 stars 5 forks source link

Can't insert a new entry to my db #20

Open Toneq opened 5 years ago

Toneq commented 5 years ago

Hey! I have a problem with INSERT INTO because it doesn't insert a line in mysql. It does not work only with the variables entered. There are no errors in the console.

Plugin: Skript(2.4-beta5), SkQuery, WildSkript, ProtocolLib, WorldEdit, WorldGuard, skDragon, SkUtilities, skRayFall, skript-db

My database query: execute "INSERT INTO sk_guild (Name, Value, Player) VALUES ('%{_name}%::position', 'Lider', '%player%')" in {sql}

btk5h commented 5 years ago

You cannot interpolate expressions into SQL string literals.

Toneq commented 5 years ago

so how can I do that to work?

github-usrname commented 4 years ago

Obviously , the Owner of the " Skript-db " never Worked with PHP , what do you mean , " We cannot Interpolate expressions into SQL string " in PHP afcourse we can Sample: $PRO = "INSERT".$notPRO.'Limit 1;'; then SQL return >>> Affected 1 Row which means , Everything is Fine , and DB insert has been SUCCESSFULL ! and the Owner Must Find a way to Fix this , this is MAIN ISSUE if you ask me , OTherwise Go into your REPO and DELETE FULLY DYNAMIC QUERY because its not DYNAMIC OTHERWISE !!!!!!!!!!! this is Verry Important !!!!!!!!!

So i have the same ISSUE !!!!!!!!!!!!!