Unable to run Rev 535

ChaosSlayerZ · #1 05-20-2009, 06:03 PM

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 · #2 05-20-2009, 06:47 PM

Quote:

Originally Posted by 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

Chaos run this query and see if it helps ya out

Code:

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 · #3 05-20-2009, 07:16 PM

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/sv...tes/Rev535.sql

leslamarch · #4 05-20-2009, 07:37 PM

Quote:

Originally Posted by 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/sv...tes/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.

Code:


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 · #5 05-20-2009, 08:49 PM

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 · #6 07-12-2009, 02:11 PM

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 · #7 07-12-2009, 06:23 PM

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