no npcs showing

[crom]

morning guys.

i set up a server whit 5.7 DR4 and used the ProjectEQ.com Alpha 1 database. evrything so fare works. i can log in and make a char and run around. only problem is that the world is very empty. and i get this error msg from zone.exe



[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR4
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5426
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
[Status] Weather should change in 5926 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 34; Time Offset = 0
Reading zhdr file './cfg/nro.cfg'
Using database for safe coords.
Zone safe coords are x = 299.12; y = 3537.9; z= -24.5
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for nro ...
[Status] Done loading doors for nro ...
[Status] Zone Bootup: nro (34)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Status] 242720 New client from ip:192.168.2.3 port:1778
Unknown opcode: 0x01e4 size:8 Client:Test
0: 0A 00 00 00 C0 02 EF C3 | ........




i have no clue how to fix this. i tryd to add some updates witch i found wile reading and searching true the posts. but nothing helped.

[wize_one]

you didnt follow the directions to set the maxnpcs to 400000

[crom]

no i did checked it befor compiling and its allrdy changed in the cvs



#define MMF_MAX_NPCTYPE_ID 400000



i even uped the value to 600000 , dident change anything :(

crom

[masteryoda]

Try this and source into your DB.


ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;

[crom]

W00t .. it worked. thx masteryoda

[pheer]

#define MMF_MAX_NPCTYPE_ID 400000

What do you do this this, like where do you put it :D

[Virus11]

Wasn't that allready edited in the source?

[Kode Black]

General Support
Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

World Building
World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.
http://www.eqemulator.net/forums/viewforum.php?f=19

[Kronusx77]

can someone please tell me where i type

"#define MMF_MAX_NPCTYPE_ID 400000"

and

"ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0; "

in?

im having the same exact problem with the empty world thing and am anxious to try these "fixes" although i have no clue where to type them in... thanks ahead of time for any help and patience with my lack of knowledge.

[sotonin]

the first one is a code change you dont just type it in somewhere. you type it in and recompile the binaries.

the second you can type into mysql console.

[Kronusx77]

again... pardon my lack of knowledge... recompile the binaries? i did type the other one into mysql and it went through but i still have no clue what to do with the define npcs thing... and typing in alter table into mysql didnt fix my empty world....

[sotonin]

You have to have the source code for the emulator and you have to compile it yourself with a compiler.

[lbc9999]

I am having the same error. I have tried logging using the mini login and I was able to enter the world but no npcs and the doors didnt work correctly. I am using the PEQ_Kunark_RC1.sql database and I had to source in tributes.sql and tribute_levels.sql.
I laso had to do the door fix. but I am still getting "Error loading NPCs from database. Bad query." or the zone crashes and the client will say discommected.

Before that it wouldnt even load and i was gettin " Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away"

I had to uninstall the 4.0 of mysql and install the 3.23.58 version to get past that. The MySQL server has gone away thing may have something to do with the new security and service pack 2 for xp