Character Bind Source write issue

[Figback65]

Hi all,

So I took a few months off and I come back and update to newest source and and all that jazz, With default everything I am getting a SQL write error on the character_binds table.

I looked at my old one and at the new one and the columns have changed. I have tried using all defaults and everything, of course all updates done through the world.exe

It has the new column named slot and my source does not want to write to it nor recognize it. I tried searching but came up with nothing under character_bind

Any known fix?

Thanks all

[Uleat]

So, your source code is using the new table and your database has the new table..but, you are getting an error when writing to it?

Can you post the error that MySQL is kicking out?

[Figback65]

nevermind, I guess I had some old restored DB saves in there and they are not compatable. So 100% default works, anyway around using 100% default bc now ill have to go back and do all my edits all over again :(

[Figback65]

[07-16-2016 :: 17:32:38] [MySQL Error] 1064: 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 '' at line 1 
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (6292724, 6292688, 6292652, 0.000000, 0.000000, 0.000000, 0.000000, 1077870592), (0, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, 1077870592), 
[07-16-2016 :: 17:32:38] [MySQL Error] 1054: Unknown column 'slot' in 'field list' 
 SELECT `zone_id`, `instance_id`, `x`, `y`, `z`, `heading`, `slot` FROM `character_bind`  WHERE `id` = 6 LIMIT 5

was the error I was getting, I really don't wanna have to edit stuff again lol

[Figback65]

Ok I guess I was wrong, it still is messed up. I downloaded the source again and peqbeta, rebuilt everything, 0 errors on the compile, pushed 3 on the world bootup to patch the sql, pushed 3 a few times to make sure it all got updated.

I make the 1st character on the server and I get no errors.

After I make the 2nd character I get this error and any character after

[07-16-2016 :: 21:53:24] [World Server] Found 'TitaniumStartZoneID' rule setting: -1
[07-16-2016 :: 21:53:24] [Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id FROM start_zones WHERE zone_id = 9 AND player_class = 4 AND player_deity = 215 AND player_race = 4

[07-16-2016 :: 21:53:24] [MySQL Error] 1064: 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 '' at line 1 
 REPLACE INTO `character_bind` (id, zone_id, instance_id, x, y, z, heading, slot) VALUES (6161652, 6161616, 6161580, 0.000000, 0.000000, 0.000000, 0.000000, 0), (0, 0, 0, 0.000000, 0.000000, 0.000000, 0.000000, 0),

The only thing I changed was tutorial start zone to -1 and I also tried 0.

EDIT : I dunno its weird, I test dieing and it still works but I keep getting that error everytime I make a character.

EDIT : It also puts in 5 entries per character in character_binds.

[Figback65]

Maybe its a titanium thing?

[demonstar55]

Originally Posted by Figback65

EDIT : It also puts in 5 entries per character in character_binds.

This is on purpose. Every toon has 5 binds.

[demonstar55]

This issue should be fixed.

[Figback65]

Ya, I dunno Demon. I redownloaded all the source a few times, recompiled a few times, always 0 errors, sourced in latest peqbeta and playertables, like always, configured the config file, start up the server, see it on server list, connect to it, make a toon and check logs in the cmd prompt windows and boom sql writing error lol

[Uleat]

Post the new error that you received, if you would.

[Figback65]

I will do that today, I formatted my server to clean out any issues. I will reinstall everything and not even move any backups or anything old to X out any conflicts and then I will post.