EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   no npcs showing (https://www.eqemulator.org/forums/showthread.php?t=14329)

crom 06-14-2004 12:35 PM

no npcs showing
 
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

Quote:


[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 06-14-2004 03:13 PM

you didnt follow the directions to set the maxnpcs to 400000

crom 06-14-2004 04:24 PM

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

Quote:


#define MMF_MAX_NPCTYPE_ID 400000

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

crom

masteryoda 06-14-2004 05:39 PM

Try this and source into your DB.

Quote:

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

crom 06-15-2004 12:23 AM

W00t .. it worked. thx masteryoda

pheer 06-23-2004 03:56 AM

#define
 
#define MMF_MAX_NPCTYPE_ID 400000

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

Virus11 06-23-2004 04:48 AM

Wasn't that allready edited in the source?

Kode Black 06-23-2004 11:50 AM

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 08-17-2004 03:25 PM

Where do i type it in?
 
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 08-17-2004 03:51 PM

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 08-17-2004 04:18 PM

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 08-17-2004 05:18 PM

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

lbc9999 11-12-2004 09:02 AM

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


All times are GMT -4. The time now is 12:03 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.