Unable to run Rev 535

[ChaosSlayerZ]

When starting world and zones I am getting following error:

Zone.exe Entry Point Not Found: the procedure entry point Perl_sys_init3 could not be located in the dymanic link library perl58.dll

please advise

[vales]

What Perl version are you running?

[ChaosSlayerZ]

ActivePerl-5.8.7.813-MSWin32-x86-148120.msi

which was just recently updated like in febrary - you tellign devs moved up a new version again? i realy wish these things would get mentioned in changelog file

[ChaosSlayerZ]

ok the server runs, i connect, but when i try to log in my char from char selection screen I get following errors:

Error in GetCharacterInfo #1054 Uuknown collumn 'instanceid'

then i get disconected message.

I am telling you guys something STILL missing from requred sql updates for 535

[leslamarch]

ok the server runs, i connect, but when i try to log in my char from char selection screen I get following errors:

Error in GetCharacterInfo #1054 Uuknown collumn 'instanceid'

then i get disconected message.

I am telling you guys something STILL missing from requred sql updates for 535

Chaos run this query and see if it helps ya out
ALTER TABLE `character_` ADD `instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;
ALTER TABLE `character_` DROP `instZflagNum`;
ALTER TABLE `character_` DROP `instZOrgID`;

ALTER TABLE `player_corpses` ADD `instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;
ALTER TABLE `player_corpses` ADD INDEX `instanceid` (`instanceid`);

[ChaosSlayerZ]

run them

now i get this when trying to log char into zone:

Zone is unavailable (for new char/8 diffirent zones)

In World.exe window:

Recived unknown EQApplication packet
client_err opcode op_worldlgout 0x7718 size=0


Btw those sqls lines are simular to what i found here for un-official 535, perhaps i should run them all:

http://projecteqdb.googlecode.com/svn/trunk/peqdatabase/updates/Rev535.sql

[leslamarch]

run them

now i get this when trying to log char into zone:

Zone is unavailable (for new char/8 diffirent zones)

In World.exe window:

Recived unknown EQApplication packet
client_err opcode op_worldlgout 0x7718 size=0


Btw those sqls lines are simular to what i found here for un-official 535, perhaps i should run them all:

http://projecteqdb.googlecode.com/svn/trunk/peqdatabase/updates/Rev535.sql

Did you run these yet?
I would check your DB with these updates to see what ones you applied and what ones you did not.




ALTER TABLE `respawn_times` ADD `instance_id` SMALLINT DEFAULT '0' NOT NULL AFTER `duration`;
ALTER TABLE `respawn_times` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`, `instance_id`);

ALTER TABLE `character_` ADD `instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;
ALTER TABLE `character_` DROP `instZflagNum`;
ALTER TABLE `character_` DROP `instZOrgID`;

ALTER TABLE `npc_types` ADD COLUMN `version` smallint(5) unsigned NOT NULL DEFAULT '0' after `Accuracy`, COMMENT='';

ALTER TABLE `spawn2` ADD `version` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zone`;

ALTER TABLE `player_corpses` ADD `instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;
ALTER TABLE `player_corpses` ADD INDEX `instanceid` (`instanceid`);

ALTER TABLE `traps` ADD INDEX `zone` (`zone`);
ALTER TABLE `traps` ADD `version` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zone`;

ALTER TABLE `ground_spawns` ADD INDEX `zone` (`zoneid`);
ALTER TABLE `ground_spawns` ADD `version` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;

ALTER TABLE `object` ADD INDEX `zone` (`zoneid`);
ALTER TABLE `object` ADD `version` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zoneid`;
ALTER TABLE `object` DROP `linked_list_addr_01`;
ALTER TABLE `object` DROP `linked_list_addr_02`;
ALTER TABLE `object` DROP `unknown88`;
DELETE FROM object WHERE object.type=1 AND object.itemid!=0;

ALTER TABLE `doors` ADD `version` SMALLINT UNSIGNED DEFAULT '0' NOT NULL AFTER `zone`;

[ChaosSlayerZ]

ok I have run all the sql.
I am in game now =)

Running around trying to see if it will crash or give some other error =)

fine so far

btw found a new rule on that page

insert into rule_values values (1,'Combat:NPCBonusHitChance', 26.0);

[Brightstrider]

Hello,

I downloaded the latest build for EQEmu to update my Angelox Classic install of the game to fix spell problems. I upgraded my Perl version and did the SQL commands that leslamarch wrote, but when I run the client, the characters have no hair and are naked in the login character selection screen. When I log in, I get a message that there's a problem with zone.exe and it crashes.

Brightstrider

[Brightstrider]

These are some errors in the log file:

[07.12. - 15:59:15] [RULES__ERROR] Unable to find rule 'Aggro:SlowAggroMod'
[07.12. - 15:59:15] [RULES__ERROR] Unable to interpret rule record for Aggro:SlowAggroMod
[07.12. - 15:59:15] [RULES__ERROR] Unable to find rule 'Aggro:IncapacitateAggroMod'
[07.12. - 15:59:15] [RULES__ERROR] Unable to interpret rule record for Aggro:IncapacitateAggroMod
[07.12. - 15:59:15] [RULES__ERROR] Unable to find rule 'Aggro:MovementImpairAggroMod'
[07.12. - 15:59:15] [RULES__ERROR] Unable to interpret rule record for Aggro:MovementImpairAggroMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:HitPerLevelDiff'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:HitPerLevelDiff
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'EQOffline:CreateBotCount'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for EQOffline:CreateBotCount
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'EQOffline:BotManaRegen'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for EQOffline:BotManaRegen
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'EQOffline:BotFinishBuffing'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for EQOffline:BotFinishBuffing
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'EQOffline:SpawnBotCount'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for EQOffline:SpawnBotCount
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'EQOffline:BotQuest'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for EQOffline:BotQuest
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:MeleeHitChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:MeleeHitChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:PriestHitChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:PriestHitChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:CasterHitChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:CasterHitChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:HeavyAvoidChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:HeavyAvoidChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:ModerateAvoidChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:ModerateAvoidChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:LightAvoidChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:LightAvoidChanceMod
[07.12. - 15:59:16] [RULES__ERROR] Unable to find rule 'Combat:UnarmoredAvoidChanceMod'
[07.12. - 15:59:16] [RULES__ERROR] Unable to interpret rule record for Combat:UnarmoredAvoidChanceMod
banned IPs check. Processing connection.
[07.12. - 16:00:33] [WORLD__CLIENT] Nasir: Logged in. Mode=(CharSel)
[07.12. - 16:00:33] [WORLD__CLIENT] Nasir: LS Account #1
[07.12. - 16:00:49] Unable to convert EQ opcode 0x22cf to an Application opcode.
[07.12. - 16:00:49] [WORLD__CLIENT_ERR] Nasir: Received unknown EQApplicationPacket

[07.12. - 16:01:41] [WORLD__CLIENT] Nasir: Client disconnected (not active in process)
[07.12. - 16:04:57] [WORLD__ZONE] New TCP connection from 127.0.0.1:1580
[07.12. - 16:04:57] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:1580
[07.12. - 16:04:57] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zones

[trevius]

All of those errors are normal. The rules errors are because of rules in your DB that no longer exist in the code. You can remove all of those rules from your table.

The error about 0x22CF opcode is because it is a checksum packet that we don't need to do anything with, so there is no code to support it since it isn't required. Looks like you are using the SoF client judging by that opcode. Here is the line from the patch file for SoF related to that opcode:

OP_SendSpellChecksum=0x22CF #SEQ 12/04/08

Try looking earlier in your logs to see if it says that the items loaded successfully or not. Also, make sure you have all of the latest SQL updates, including the most recent slow mitigation field for the npc_types table.

[Brightstrider]

Hello,

Where could I find the SQL updates? The log says there's unknown column called 'heroic_mr' in 'field list'. I searched for heroic_mr in the forums and online help, but found nothing.

Brightstrider

[trevius]

Try here:

http://code.google.com/p/projecteqemu/source/browse/#svn/trunk/EQEmuServer/utils/sql/svn

[Brightstrider]

Hello,

I did many of the SQL updates and I'm able to log in now. However, there seem to be no NPCs or monster spawns in the zone. I tried downloading the maps and replacing them, but that didn't change anything. The npc_type table is populated, and I don't have any errors in my log file concerning tables or anything. What could be causing the lack of spawns problem?

Brightstrider

[vales]

Did you source in the actual database? There's a new sticky with some useful links in the General section of the forums.

Here's the link to the PEQ database, quests and maps "how-to" with SVN.
http://www.eqemulator.net/wiki/wikka.php?wakka=ProjectEQSVN

If you're using Angelox's database, you might need to post on his forums for support on his version.

[Brightstrider]

Hello,

If I source the database, do I risk losing my characters saved before the upgrade?

Brightstrider

[Brightstrider]

Hello,

I did source the database using SVN from:

http://projecteqdb.googlecode.com/svn/trunk/peqdatabase

The spawns and npcs are still not showing up.

Brightstrider