EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Character Bind Source write issue (https://www.eqemulator.org/forums/showthread.php?t=40766)

Figback65 07-16-2016 08:57 PM

Character Bind Source write issue
 
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 07-16-2016 09:07 PM

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 07-16-2016 09:14 PM

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 09:15 PM

Code:

[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 07-17-2016 01:00 AM

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

Code:

[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 07-17-2016 03:11 AM

Maybe its a titanium thing?

demonstar55 07-17-2016 09:57 PM

Quote:

Originally Posted by Figback65 (Post 250054)
EDIT : It also puts in 5 entries per character in character_binds.

This is on purpose. Every toon has 5 binds.

demonstar55 07-17-2016 10:52 PM

This issue should be fixed.

Figback65 07-19-2016 04:48 PM

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 07-19-2016 04:57 PM

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

Figback65 07-20-2016 04:15 PM

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.


All times are GMT -4. The time now is 03:58 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.