Server problems

[Angelox]

I know I already emailed you this, but now I'm testing to see if I can post again,
and this might be of interest to someone else

You could try this but like I said, 256 mb is probably way to little ram
Run MSCONFIG, go to startup and services tabs, disable as much as you can there. I do this anyways, as it helps speed up my system and hopefully free up more ram. here's a starting point for this,
http://www.onecomputerguy.com/window...rvices_disable
Also, for example, if you have a router, then you don't really need the windows firewall, router has it's own firewall, disable it in MSCONFIG.
Everquest recomends you use at least 500 mb of ram to run the client, so you know if you run the client on your EQEMU server machine, it's going to hog up you memory also. You should try login from another machine in the LAN .

edit;
I got rid of all my parenthesis, and it finally posted.

[InsaneWallaby]

Toldya them parenthesis were the problem. Anywho, I have 256 SDRAM on my server, and it runs peachy, even if I'm doing Java programming (which, as we all know, chews through memory with a compiler) while waiting to regen. Yeah, my RAM sucks; it's not even DDR, and now they've got DDR2 and whatnot...accepting RAM donations, no live animals please =P...but seriously, my computer has a faster processor than that, but it is pretty crappy when it comes to RAM. Try the hilted version of the server out if you haven't. My server failed to work until I used it.

[mplostcause]

Just an update but Angelox and I have been exchanging emails and my server is on up and running. Many thanks to him =)

[njlinus]

how did you fix it? im having this problem now. i was fine until i updated it tonight. had my server up for 6 days straight no problems, and now i cant get any zones -(

[Angelox]

Originally Posted by njlinus

how did you fix it? im having this problem now. i was fine until i updated it tonight. had my server up for 6 days straight no problems, and now i cant get any zones -(

Have you updated before? What version EQEMU did you have before you updated? did you read the changelogs and add sourced the lines mentioned in them?

[njlinus]

I was using 3.52 that comes with the EQEmuServerPack. i have not updated before. I did try adding the Sourced line and that did not work, they were accepted just didnt help my problem. i just did a clean instal and its running fine. Im kinda hesitant to update it again incase i cant get it working again. but if you have any help i will definatly try it.
thanks

[Angelox]

Originally Posted by njlinus

I was using 3.52 that comes with the EQEmuServerPack. i have not updated before. I did try adding the Sourced line and that did not work, they were accepted just didnt help my problem. i just did a clean instal and its running fine. Im kinda hesitant to update it again incase i cant get it working again. but if you have any help i will definatly try it.
thanks

I think there's two changelogs that require lines sourced into the SQL database. It might have been that you need to re-boot the machine for changes from the database to take effect.
You should keep trying, the newest binaries have many improvements. The new stuff should work fine. before you do this, don't forget to back up your "eqemu_config_xml" file, as the new binarie package will over write what you have.
Also, if you are editing loots, npc's and such, you should download "MySQL Administrator" from the MySQL site and have a "back-up plan" for your database. It's already saved me from my "blunders" many times.

[njlinus]

Hey thanks for the quick replies. i will look into this tomorrow night and keep you updated. I never rebooted my machine before trying to log on so that might be it.
as for my database i started working on it this week and forgot to back it up..oh well. i only had a few ornate and epic merchants. so i didnt lose much that i cant redo quickly.

[Zandig]

If you are updating from Server Pack 3.52 to the latest build you must follow the changelogs: http://www.eqemulator.net/releases/l...-0.7.0-804.txt
and make the appropriate adjustments to your database.

So to update to the newest release: 0.7.0-804 (which is the newest as of this post) you must run these lines into your database:

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;

I'm using the PEQ database (works with Cavedude's as well) and it works great. If I didn't do exactly as I stated above it would not work properly and say the zone is unavailable. Trust me I've already found out

I also find that using MySQL Control Center is easiest for making database modifications. Load the control center, select your database, select the SQL/Query button, copy and paste the code and then execute the query.

[njlinus]

Yep that fixed it, was a little slow loading in the first time but it works, thanks guys!

[therealjjj77]

Everytime I enter the:
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT( UNSIGNED NOT
NULL DEFAULT '0';

I get this error that says I'm not using the right MYSQL syntax. I currently have 4.0.0.23.

Do I need MYSQL 5.0? And if I do how can I replace it without running into problems? I am trying to upgrade from the 3.52 Cavedude pack to the most recent binary. Thank you for the help in advance.

EDIT: I think I see the problem. lol. NM this post. (`) looks a lot like (')