mysql problem with new skill

[Dran Ryszard]

Hi, i have this error when i login/logout to my local server, im use this tutorial to add new skill New skill by EPuncker · Pull Request #4503 · otland/forgottenserver (https://github.com/otland/forgottenserver/pull/4503/files)

[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 999,`group_id` = 5,`vocation` = 8,`health` = 150,`healthmax` = 150,`experience` = 16517199400,`lookbody` = 0,`lookfeet` = 0,`lookhead` = 0,`looklegs` = 0,`looktype` = 136,`lookaddons` = 0,`maglevel` = 130,`mana` = 0,`manamax`
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''skill_runecraft' = 10,'skill_runecraft_tries' = 0,`direction` = 2,`onlineti' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 999,`group_id` = 5,`vocation` = 8,`health` = 150,`healthmax` = 150,`experience` = 16517199400,`lookbody` = 0,`lookfeet` = 0,`lookhead` = 0,`looklegs` = 0,`looktype` = 136,`lookaddons` = 0,`maglevel` = 130,`mana` = 0,`manamax`
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''skill_runecraft' = 10,'skill_runecraft_tries' = 0,`direction` = 2,`onlineti' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 999,`group_id` = 5,`vocation` = 8,`health` = 150,`healthmax` = 150,`experience` = 16517199400,`lookbody` = 0,`lookfeet` = 0,`lookhead` = 0,`looklegs` = 0,`looktype` = 136,`lookaddons` = 0,`maglevel` = 130,`mana` = 0,`manamax`
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''skill_runecraft' = 10,'skill_runecraft_tries' = 0,`direction` = 2,`onlineti' at line 1
Error while saving player: Admin

 

[lursky]

Most likely you're mixing grawis wit apostrophe. Do it exactly as on PR you linked to.

 

[Dran Ryszard]

Most likely you're mixing grawis wit apostrophe. Do it exactly as on PR you linked to.

Thanks, i check all lines again and i found what's be wrong.

You have right.