TFS 1.X+ No character Save - MySQL Error

Forkz

Member
Joined
Jun 29, 2020
Messages
138
Reaction score
21
Hi otlanders,
This error is showing up when I switch off the character, and he doesn't save.

C++:
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` =
1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody`
 = 106,`lookfeet` = 95,`lookhead` = 78,`looklegs` = 116,`looktype` = 128,`lookad
dons` = 0,`maglevel` = 0,`mana` = 40,`manamax` = 4
Message: You have an error in your SQL syntax; check the manual that corresponds
 to your MariaDB server version for the right syntax to use near '☺,`lastlogin`
= 1595887819,`lastip` = 16777343,`conditions` = '',`skulltime` = 0' at line 1
 

Evil Puncker

prolonged absenteeism
TFS Developer
Joined
May 30, 2009
Messages
7,757
Solutions
186
Reaction score
3,554
`skulltime` = 0'

it is missing a quote before the zero, you need to fix that query wherever it is located
 
Top