Page 1 of 1

SQL Query issue with new SVN server build...

Posted: Mon Mar 31, 2014 7:45 pm
by jududdar
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

Re: SQL Query issue with new SVN server build...

Posted: Tue Apr 01, 2014 7:13 am
by John Adams
Whoops, yeah maintaining documentation at this point is a full-time job because things are changing so rapidly.

I updated the Wiki, let me know if this feels correct: http://wiki.vgoemulator.net/Docs/Guides ... The_Tables

Re: SQL Query issue with new SVN server build...

Posted: Tue Apr 01, 2014 2:11 pm
by jududdar
Looks good, while we're on initial documentation, I found another discrepancy (note: I'm not a nazi for these things, just something I had to ponder for a few last night). It's on the wiki page about the xml files: http://wiki.vgoemulator.net/Docs/Guides:WorldConfig

Your line looks like:

Code: Select all

<worldserver host="localhost" port="10100" name="[YOUR WORLD NAME HERE]" account="[YOUR ACCOUNT NAME HERE]" password="[YOUR PASSWORD HERE]" />
When in the current XML, there is an additional field at the end labeled "worldaddress" which I had to set to login.vgoemulator.net in order to make the console launch with no errors, so line on wiki should read (I guess?):

Code: Select all

<worldserver host="localhost" port="10100" name="[YOUR WORLD NAME HERE]" account="[YOUR ACCOUNT NAME HERE]" password="[YOUR PASSWORD HERE]" worldaddress="login.vgoemulator.net" />
Those were the only 2 differences I found in what the wiki said and what I had to do to successfully launch the server.

--Jud

Re: SQL Query issue with new SVN server build...

Posted: Tue Apr 01, 2014 2:56 pm
by Theeper
The worldserver variable was removed today. Delete it from that element and it should work.

Re: SQL Query issue with new SVN server build...

Posted: Tue Apr 01, 2014 3:27 pm
by John Adams
Yeah, new code on SVN too.