Error With World.exe

[Tarnien]

I tried everything that was said here, using fix.sql, factionfix.sql, and running a new db with addons, but still no luck... World.exe opens then closes immediatly. Using 0.4.3, mysql 1.4, and win98... Heres a pic of what it says, ive tried everything i can think of, any ideas?

http://www.rpgwh.net/Pics8/world.gif

Thanks





### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=Opki's Test
worldaddress=192.168.1.102
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=









# READ README.TXT!

[Database]
host=localhost
user=---------
password=--------
database=eq
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.







REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . 127.0.0.1 7995 192.168.1.102
start zone . 127.0.0.1 7996 192.168.1.102
start zone . 127.0.0.1 7997 192.168.1.102
start zone . 127.0.0.1 7998 192.168.1.102
start zone . 127.0.0.1 7999 192.168.1.102
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[rockocool]

in the 4.3 db.sql, there isnt a ts column in the variable table, in 4.2 db.sql, there is. So that's what the error message is about.

what i did was I used the 4.3 client for its new features, but i still used my old database, plus i did a 4.2to4.3 fix. I didnt bother to source in the new db.sql at all. works fine for me.

I am curious how can you find an addon for 4.3. since there isnt a new addon available at all, am i right? the latest addon is still the one comes with 4.1. With some fix that will still work though, just old. or you are using the telmet db?

[Tarnien]

Using Telmet DB... So just use that as source, then 42to43.sql, then fix.sql, factionfix.sql, and use all the new 0.4.3 files, and it should work? Will try when i get home

[Drawde]

Trumpcard just sent me some updated 4.3 binaries which seem to work OK - if anyone wants I'll post them on my site for download.
They also include the updated tradeskill code.

[Tarnien]

If you've gotten them to work with 0.4.3, please do :lol:
and whats url to ur webpage?

[Tarnien]

Tried everything that you said... fixed some of it, but still getting an error:

http://www.rpgwh.net/Pics8/emu2.gif

Anymore ideas? :\ and could someone post a DB they know works? Everyone i've tried still causes world.exe to crash immediatly upon opening.

[rockocool]

This error message could only mean you forgot to source the addon sql. so there is no items in the database at all.

so let me make it more clear, two ways to build the database that will work for the Eqemu4.3, both start from scratch:

1. drop your old database if it's not working, create database eq, source the db.sql from eqemu 4.1, then run the install program from eqemu 4.1 addon (remember command is "install eq"), then source 41to42fix.sql, and then source 42to43fix.sql, both sql can be found somewhere in the forum. now you got a working database.

2. drop your old database if it's not working, create database eq, source the db.sql from telmet download, then run the install program from telmet addon (again command is "install eq"), , then you are done. you got a working database that works with eqemu 4.3.

note: if you have a 4.2 compatible database, all you need to do is run the 42to43fix.sql.

[Tarnien]

Still not working.. i tried everything u said, and got same error everytime, except it says Error=120, instead of error=5070248.

1) Uninstalled mysql, deleted directory, deleted emu directory.
2) Installed mysql, unzipped emu 0.4.3
3) Unzipped db.sql from 0.4.1 to c:\mysql\bin
4) Created database eq, use eq, source db.sql
5) Unzipped 0.4.1 addon to C:\Temporary
6) Opened a dos window, did CD C:\Temporary, then install eq
7) Could not find a 0.4.1to0.4.2.sql file on forums, so i found the closest thing i could: ALTER TABLE variables ADD COLUMN ts timestamp NULL;

Im assuming this is just 41to42 in a text format? Found this here: http://forums.eqemu.net/viewtopic.ph...0+4+2+released

Anyway, i opened mysql.exe, typed in use eq, then ALTER TABLE variables ADD COLUMN ts timestamp NULL;
8) Sourced 42to43.sql
9) Edited loginserver.ini, db.ini, and boot5zones.bat
10) Ran World.exe.. got same error as before...

Am i missing something?
Tried #2

1) Unzipped 0.4.3
2) Unzipped telmet's db to c:\mysql\bin
3) Sourced db.sql
4) Ran Telmets 0.4.3 addon (Note: got about 30 seconds of errors saying something along the lines of "Error, line ### does not match up with line ###" or something.
5) Ran World.exe, got same error


What am i missing here?

Thanks

[Drawde]

The updated files can be downloaded from http://www.edwardpinniger.bctalk.net/eq/build.zip .
This zip includes an updated db.sql, but it might work with the existing DB.

[rockocool]

41to42fix.sql can be find at end of this post,
http://forums.eqemu.net/viewtopic.php?t=5240
or to save time for you, i copied it at end of this post. you need to add the 5 resist column.

as of why it doesnt work for you using the telmet db.sql and addon, The only guess I could make is you are using an older version of telmet's files, I think he updated them recently. try redownload them from his website, I was using the latest download to test it, which works. I dont know if his earlier version works or not, since only yesterday I gave telmet files a try:
http://www.darkangel.net/eqemunews/
I rebuilt my db exactly like what i suggested in my last reply, and it worked without any problem.


here is 41to42fix.sql:


-- Update EQEmu 4.1 DB to a 4.2 compatable DB

ALTER TABLE `account` CHANGE `password` `password` VARCHAR(50) NOT NULL;

ALTER TABLE `npc_types` CHANGE `npcspecialattks` `npcspecialattks` varchar(36) default '' NOT NULL;
ALTER TABLE `npc_types` ADD `MR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `CR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `DR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `FR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `PR` SMALLINT(5) DEFAULT "0" NOT NULL;


ALTER TABLE `variables` ADD `ts` timestamp;

INSERT INTO variables VALUES ('AILevel','0','');
INSERT INTO variables VALUES ('ZSPassword', 'EQEMu', '');

[Tarnien]

Thanks, i got everything working, cept for the spawns, when i ran telmet's addon, i got about 300 error lines saying "Value at line ### does not match up" or something, so now i have no npc's in my zones, anyone know why? Didnt have this when i tried it earlier. Everything else works though, have all spells/items and such.

1) downloaded drawde's files
2) Unzipped em, used his db.sql to create eq
3) ran telmet's addon db through dos (CD C:\Temp then install eq)
4) Got about 300 error lines, only for spawns.sql, nothin else.

Thanks again