COMPLETE PUBLIC SERVER SETUP - Jan-2011

[gr1m.a1ch3m157]

I having trouble with the C++ Rebuild part of the tutorial... I have followed this tutorial to the absolute T and I get 3 success and 2 failed every time.. why is this? I have windows 7 64bit. Any help would be awesome. Cleaning it I get 5 success and 0 failed though. I went to the build log and found the 2 errors.

EQWParser.cpp
.\EQWParser.cpp(116) : error C2106: '=' : left operand must be l-value
.\EQWParser.cpp(123) : error C2106: '=' : left operand must be l-value

What do I do?

[werebat]

I had those same errors before and it was perl related. I dropped back from 5.14 to 5.12 and then it worked. There is another thread specifically for x64 compiles, check there.

[gr1m.a1ch3m157]

I changed the Perl version but still nothing, any other ideas?

[Malpercio]

So i started following the tutorial today, and, using all the links/programs listed in the first post, it can't compile because it can't find zlib.lib. I checked in the folders and it doesn't exist, so I'm wondering if it's supposed to point at zdll.lib or zlib.def, or if I really am missing a file

[werebat]

Make sure you have the VC++ directories in the exact order as shown in the guide. If you are using XP 32 bit then you can use the programs I listed above, I know that combination works.

[Malpercio]

The problem is that it's looking for, but not finding, a file called zlib.lib (which makes perfect sense, as that file doesn't exist, and isn't supposed to, as it's not in either 1.2.3 or 1.2.5)
Example build log, using world specifically: http://dl.dropbox.com/u/9192467/BuildLog.htm

[lerxst2112]

Change the projects to link zdll.lib, or rename the file.

[Malpercio]

http://dl.dropbox.com/u/9192467/BuildLog.htm Same general problem, different specific error.

[joligario]

Are you using MySQL 5.5 lib/includes to compile? You should be able to get 5.1 folders for the compile while still running 5.5.

[Malpercio]

no, I'm using MySQL 5.1 (the full complete pack, not just essentials) and ActivePerl 5.10 build 1007, VC++ 2008 express edition.

[werebat]

You should not have to rename the file. My is zlib1.dll and works perfectly. Make sure a copy of it is in the system32 directory. I am usng zlib125-dll.zip from the zlib site. www.zlib.net

[Malpercio]

Okay, I have no explanation for this whatsoever, but renaming the file back to zdll.lib fixed everything.
Originally, it failed looking for zlib.lib
Then, giving it a zlib.lib to find caused collisons and broke stuff.
Then, giving it zdll.lib back somehow worked.
¯\_(ツ)_/¯

[lerxst2112]

Because it's finding zlib.lib in your mysql directory.

[helman]

I don't know if this has been said and i don't want to look through 18 pages to see. But instead of WinRAR how about 7zip? Its free and can open ever thing. Just a suggestion.

[Valdis01]

Hey guys, I had a quick question, so when doing the said updates using Navicat, the current DB that's out (As of... 10:25 PST January, 08 -2012) is, peqdb_rev2092... So, when opening the command prompt, and type 'source peqdb_rev2092.sql - it goes through all of it's files (Records, Query's etc) all of it's okay, gives me NO errors, at all... same with source load_player.sql (No errors) as well as the bots....

But then I get to the next part, where I have to update them through Navi, Since the PEQ DB is 2092... Wouldn't I need a higher one then 1711? At least, I thought that, but since the highest one there is 2087, I just clicked 1711 anyway... It gave me this,

[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I followed the guide to a T, went over it 30 times + to make sure everything was right... and I got nothing... Help?