I've compiled and got the current OTservBR running from this thread:
It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm recieving in console is:
I have searched for hours looking for which file these errors are coming from with no success at all. Could someone at least point me in the right direction or have some miracle quick fix? I've tried swapping from UniServZ to XAMPP and from ZNoteACC to Gesior to MYACC since I thought they might have something to do with it. Any help would be greatly appreciated. Thanks.
[12.x] OTServBR-Global
Hello everybody! Today we introduce you a different project that we called Canary. Canary aims to be the definitive and end engine for running a server, and along with that we are also sharing our otservbr-global datapack that runs on top of Canary. Why canary? The goal of this engine is to...
otland.net
It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm recieving in console is:
Code:
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 128,`lookaddons` = 0,`maglevel` = 0,`mana` = 40,`manamax` = 40
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 ',`lastlogin` = 1561115244,`lastip` = 16843018,`conditions` = '',`skulltime` = 0' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 128,`lookaddons` = 0,`maglevel` = 0,`mana` = 40,`manamax` = 40
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 ',`lastlogin` = 1561115244,`lastip` = 16843018,`conditions` = '',`skulltime` = 0' at line 1
[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 76,`lookhead` = 78,`looklegs` = 58,`looktype` = 128,`lookaddons` = 0,`maglevel` = 0,`mana` = 40,`manamax` = 40
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 ',`lastlogin` = 1561115244,`lastip` = 16843018,`conditions` = '',`skulltime` = 0' at line 1
Error while saving player: Tarien
I have searched for hours looking for which file these errors are coming from with no success at all. Could someone at least point me in the right direction or have some miracle quick fix? I've tried swapping from UniServZ to XAMPP and from ZNoteACC to Gesior to MYACC since I thought they might have something to do with it. Any help would be greatly appreciated. Thanks.