COMPLETE PUBLIC SERVER SETUP - Jan-2011

[Emmeric]

I sampled an sql update, #106 Optional proc rules. It returned an unsuccessful update using Navicat.

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into rule_values values (0, 'Combat:AdjustProcPerMinute', 'true');
[Msg] Finished - Unsuccessfully

Using Visual C++, I can locate the lines and simply change them there. Would this work? If I make the changes through Vis C++, would I need to run anything again - the build? The mysql db commands?

[lerxst2112]

Your database is version 1900+, you wouldn't want to apply update 106 to it.

If you look in your rule_values table you should see all of those rules already there.

[Emmeric]

Yes, it appears most of them are already there, thank you.

I was able to login to the world server, though it showed my server locked. I was able to enter the character creation screen, as was my wife at the same time. This is a very large success considering my attempts last week that would only allow 1 person at a time to login.

However, I am receiving a couple of errors and neither myself nor my wife can actually enter the world as whatever zone is "unavailable."

Here are the errors in the exe windows:

[08.24. - 16:40:12] [WORLD__INIT] Loading items..
[08.24. - 16:40:12] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[08.24. - 16:40:12] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2792
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_world, and it did not match.
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2ec9
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_zone, and it did not match.
[08.24. - 16:42:50] [WORLD__CLIENT] xxxxxxx: Attempting autobootup of rivervale (19:0)
[08.24. - 16:42:50] [WORLD__CLIENT_ERR] xxxxxxx: No zoneserver available to boot up.

Still searching the forums, but if you see this while I'm looking, what might be the issue in the failure to load zones?


EDIT: Went into the rebuild of Visual and identified a couple problems. I had added a couple things to the exp race and class bonuses:

if(GetBaseRace() == DARK_ELF || GetBaseRace() == HALFLING) {
if(GetClass() == ROGUE) || GetClass() == WARRIOR || GetClass() == CLERIC) {


Apparently they don't like what I thought was a logical structure. Working on fixing it now.

[Emmeric]

Fixed all issues.

Now need to tweak.

Thank you everyone for your help.

[lerxst2112]

Make sure you're installing the 32 or 64 bit version to match your OS. You should see the Tortoise SVN Menu on any folder you right-click on. If not it's either installed incorrectly or there's something else wrong with your computer.

[keglo]

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

[werebat]

Originally Posted by keglo

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

[keglo]

Originally Posted by werebat

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

Yes. Installing 64 bit did work for me. Thanks for the help. Now I'm having anew problem at step 9 when I do the "Build">"Build Solution" I get the following:

Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped

I have tried it twice with the same results. Any ideas?

[lerxst2112]

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

[keglo]

Originally Posted by lerxst2112

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.

How do I post the errors without posting the whole huge log file? Id id double check my include/library directories and they where correct. I re-installed Mysql to make sure I followed all the steps. I still get the 3 succeed 2 fail.

[HolyCow]

Thanks for the great write up. Of note, people should search the forums for Perl 5.10 and use the link provided from your search results to download the correct version. As of today, 5.14 generated errors (5.10 is now only available via Pay per use). Reverting to 5.10 resolved my problems entirely, and it was free using the link buried in our forums.

[keglo]

Never mind this post

[lerxst2112]

How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

[keglo]

Originally Posted by lerxst2112

How many errors are there? The only way you will get help is to post them, otherwise we have no idea what they are. I would make a new thread for it.

Well the log file says I didn't have "errors"

0 error(s), 324 warning(s)

but I keep getting the following

3 succeeded, 2 failed, 0 skipped

I do not know how to post them or I already would have. I'm not sure what you want me to post. I tried pasting my entire log file in a new thread but it wouldn't let me. Sorry for being such a newb, but......

[keglo]

Ok lerxst2112. I found a post from you a couple of pages back.

Originally Posted by lerxst2112

Find the two lines in the source code that look like this:

#pragma comment(lib, "perl510.lib")

Change the 510 to whatever version of perl you are using, like 512.

What are the errors you get with Strawberry perl? What version were you trying to use?

I tried that solution for myself and it worked like a charm! Thank you!!