SQL Query issue with new SVN server build...
Posted: Mon Mar 31, 2014 7:45 pm
EDIT: I found my answer at viewtopic.php?f=43&t=316 - guess it's not the server, but the wiki that needs to be updated!
Hi guys!
You may already be tracking this, and if so, feel free to delete - felt compelled to report just in case.
Pertinent information:
OS: Windows Server 2008 R2
MySQL Version: 5.5.37 x64
SVN Revision: 271
Error happens using build I did using VS2012 Express, and with pre-packaged WorldServer.exe
When trying to create a character, I go through the entire process, and once I pick starting location (tried IoD and normal), client sits there eternally displaying my new character. Server console reports an error inserting new character into database. Looks like perhaps a mismatch in some queries calling char_id column and others calling character_id. I dropped database multiple times and tried every combination of changing char_id to character_id and updating the foreign key to match - no dice.
Attached is a clean log from one launch and run of server. I can edit database table names quite easily, but when it comes to getting into the code, I fall a bit short.
--Jud
Hi guys!
You may already be tracking this, and if so, feel free to delete - felt compelled to report just in case.
Pertinent information:
OS: Windows Server 2008 R2
MySQL Version: 5.5.37 x64
SVN Revision: 271
Error happens using build I did using VS2012 Express, and with pre-packaged WorldServer.exe
When trying to create a character, I go through the entire process, and once I pick starting location (tried IoD and normal), client sits there eternally displaying my new character. Server console reports an error inserting new character into database. Looks like perhaps a mismatch in some queries calling char_id column and others calling character_id. I dropped database multiple times and tried every combination of changing char_id to character_id and updating the foreign key to match - no dice.
Attached is a clean log from one launch and run of server. I can edit database table names quite easily, but when it comes to getting into the code, I fall a bit short.
--Jud