Page 1 of 1

Problems with Navicat query

Posted: Tue Sep 11, 2012 9:54 am
by simian
Hello, I'm trying to set up a server to run on my own computer (just for me, so using 127.0.0.1 IP) and when I get to the step to configure the ZoneIP for the map server, I'm not getting the results that wiki says I'm supposed to be getting.

I open the dspdb table in Navicat, select and right-click Query, select New Query, and enter the following:

UPDATE zone_settings SET zoneip = '16777343';

However, when I select Run, instead of the "256 Queries should be successful" message that wiki says I should be getting, I get the following:

Affected rows:0
Time: 0.009ms

I tried to go ahead with the steps anyway, but the DSConnect_server.exe and DSGame_server.exe applications start up and then immediately close, with the message:
[11/Sep 09:05][1;35m[SQL][0m Unknown database 'dspdb'
in the log, so I'm assuming that I did something wrong setting up the database, or that the query was the problem.

any ideas or suggestions?

Thanks in advance!

Re: Problems with Navicat query

Posted: Tue Sep 11, 2012 12:24 pm
by whasf
Out of the box it is set to that value, so it's right, it didn't update because it didn't have to :)