Anyone have this fixedz problem?

[solid11]

Hey all,

Just thought I would run this past anyone and see if there was a fix. I reinstalled 6.3DR1 with velious RC1 and ran the fix from FNW that corrected the unknown STR error to load NPCs. Well it removed the field Fixedz in the DB but when loading up it still says unknown Fixedz when trying to load NPCs for that zone. Why would it have the error if the field was takin out? Thanks guys.

[fathernitwit]

you running from cvs or the crappy zip on sourceforge?

fixedz does not appear anywhere in my source code...

[solid11]

I use the file from the wiki.

http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6

problem is it has that error loading NPCs from only RC1 and not cavedude's DB. I tried 6.3DR1 and 6.2 on that link from above. Even though the fixedz field has been successfully deleted from the DB it still says unknown Fixedz field error during loading of NPCs.

[Belfedia]

Last cvs is here : http://eqfroggy.ath.cx/download/EQEmuCVS-12-09-2005.rar
I don't know how compil it on windows.

[1Boppoom1]

run this query


ALTER TABLE ground_spawns ADD temp_x float NOT NULL;
UPDATE ground_spawns SET temp_x=min_x;
UPDATE ground_spawns SET min_x=min_y;
UPDATE ground_spawns SET min_y=temp_x;
UPDATE ground_spawns SET temp_x=max_x;
UPDATE ground_spawns SET max_x=max_y;
UPDATE ground_spawns SET max_y=temp_x;
ALTER TABLE ground_spawns DROP temp_x;
ALTER TABLE object ADD temp_x float NOT NULL;
UPDATE object SET temp_x=xpos;
UPDATE object SET xpos=ypos;
UPDATE object SET ypos=temp_x;
ALTER TABLE object DROP temp_x;
ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '80';
ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types DROP fixedz;
ALTER TABLE npc_types ADD fixedz float DEFAULT '0';
ALTER TABLE zone_points DROP keep_x;
ALTER TABLE zone_points DROP keep_y;

This will fix all your NPC errors...... Post if it works if so

Fix is a curtesy from http://support.eqemulogin.net

[solid11]

If that was the fix that FNW posted then I tried that, if not then I will give it a try. I noticed that one doens't have you drop pets. Does it matter if you don't and not resource the pets.sql? Thanks.

[solid11]

Actually that did work. Srange. It looks the same as FNW fix but without the remove pet part. I still get the following pet errors but hey the NPC are in now.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.3-DR1
[Status] Loading opcodes..
[Status] Mapping Incoming Opcodes
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] EMuShareMem loaded
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] EMuShareMem loaded
[Status] Loading Doors from database...
[Status] EMuShareMem loaded
[Status] Loading guilds
[Status] Loading guild list
[Status] EMuShareMem loaded
[Status] Loading factions
[Status] Loading titles
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 180 commands loaded
[Status] Loading embedded perl XS
[Status] Loading quests
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0xc9cd84)
[Quest] Creating EQEmuIO=HASH(0xcbf6f4)
[Quest] Loading perlemb plugins.
[Quest] Unable to read perl file 'plugin.pl'
[Quest] Loading perl commands...
[Quest] Unable to read perl file 'commands.pl'
[Status] Starting EQ Network server.
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map header: 36395 faces, 62 nodes, 42182 facelists
Loaded map: 109185 vertices, 36395 faces
Map BB: (-1273.50 -> 14.00, -321.88 -> 239.91, -88.97 -> 41.97)
Map ./Maps/neriakb.map loaded.
Path File ./Maps/neriakb.path not found.
[Status] Weather should change in 2336 seconds
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error in SpawngroupID: 41056
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for neriakb ...
[Status] Done loading doors for neriakb ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 41, Time Offset = 0
[Status] Zone Bootup: neriakb (41)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [01:06 pm]
[Quest] Unquoted string "on" may clash with future reserved word at quests/templ
ates/Priest_of_Discord.pl line 24.
[Status] 74719 New client from ip:127.0.0.1 port:1151
Unknown type/pettype of: 184,0. Using Default Formula...
Unknown type/pettype of: 181,0. Using Default Formula...
Unknown type/pettype of: 186,0. Using Default Formula...
Unknown type/pettype of: 185,0. Using Default Formula...
Unknown type/pettype of: 182,0. Using Default Formula...
Unknown type/pettype of: 181,0. Using Default Formula...
Unknown type/pettype of: 177,0. Using Default Formula...
Unknown type/pettype of: 181,0. Using Default Formula...
Unknown type/pettype of: 178,0. Using Default Formula...

Thanks for the help. Still wonder what the pettype thing is about.

[HurtinuDaily]

Not sure what the pet type errors are about or the incorrect spawngroupID error, what DB did you load??? I never got those errors wth the most recent peq DB and 6.3. I would be more worried about this error:

[Quest] Unable to read perl file 'plugin.pl'
[Quest] Loading perl commands...
[Quest] Unable to read perl file 'commands.pl'
[Status] Starting EQ Network server.

I would ensure that you have plugin.pl and commands.pl in your EQEMU directory or you will not be able to do quests. you can get the files from the 6.3 compiles I am pretty sure. With all the errors you have you may want to try dropping and reloading your DB as it may cause yuou probems in the future.

Gluck

[devn00b]

The unknown pet stuff is because some person on the dev team fucked with my pet code..and had no clue what they where doing, and broke stuff...

[HurtinuDaily]

Ahhh, gotta love it when stuff like that happens.... wierd tho cause I dont get those errors on my server. 6.3dr1 with peq + some CD DB

[solid11]

unable to read perl plugin.pl and command.pl doesn't affect my quests. They work fine. It did only start saying that once we switched to 6.0 and above I believe but my quests have always worked.

I don't think the DB of PEQ is updated regularly for the public, but I am using what ever the latest version that is posted on there, RC1.

[HurtinuDaily]

Wierd.... But wierd in a good way I guess if quests are working.