Missing ax_classic.name_filter

[Stormheart]

Hey all I have searched the forums under several topics for an answer to this but have been stymied!


I just started a fresh install of emu 7.0 1100
using ax_classic 3.0b6 db

I can logon to my server "Echoes of Eternity" under the public login but when I try to create a toon I get a missing ax_classic.name_filter doesn't exist which is true it is not in my ax_classic db tables.

How does one find a copy and or create this table?

[Angelox]

you first need the full install;
ax_classic_full_3.0b4.tar.gz
then the core update;
ax_classic_core_update_3.0b6.rar

After you full install once, core updates will work and should only be used, as full install gives you a clean user account set up.

[Stormheart]

Nice I reworked it and sourced a new ax_classic using the 3.0b4 full then cored it with the 3.0b6 and no longer get name rejections *DANCE*

Then I had an error about water and zone paths so I went to lakerathetear homepage and downloaded and installed the water maps.

Now I am getting a graveyard error (I am very very good at finding or creating errors) I searched the forums and found some graveyard posts but none that applied


The error I am getting in my zone box is:

Error in LoadingPlayerCorpses query 'SELECT id, charid, charname,x,y,z,heading,' #1054: Unknown column 'WasAtGraveyard from player_corpses WHERE zoneid='54'

Note that if your missing the 'rezzed' field you can add it with:
ALTER TABLE 'player_corpses' ADD 'rezzed' TINYINT UNSINGED DEFAULT "0";


Well I have a 'rezzed' field in my 'player_corpses' table

The error to me ( and I don't know Jack ) seems to be saying it does'nt recognize a column or field called "WasAtGraveyard" or maybe that was a query and it does'nt understand the zoneid=54?


No real info in my log file

[03.03. - 19:44:47] Starting Log: logs/eqemu_zone_4048.log
[03.03. - 19:44:47] Using database 'ax_classic' at localhost:3306
[03.03. - 19:44:47] EMuShareMem loaded

[Stormheart]

Here is the real error log no idea what that last thing I had posted was:

---------------------------------------------
[03.03. - 19:44:47] Starting Log: logs/eqemu_debug_zone_4048.log
[03.03. - 19:44:47] [ZONE__INIT] Loading server configuration..
[03.03. - 19:44:47] [ZONE__INIT] Log settings loaded from log.ini
[03.03. - 19:44:47] [ZONE__INIT] Connecting to MySQL...
[03.03. - 19:44:47] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[03.03. - 19:44:47] [ZONE__INIT] Log settings loaded from ./log.ini
[03.03. - 19:44:47] [ZONE__INIT] Mapping Incoming Opcodes
[03.03. - 19:44:47] [ZONE__INIT] Loading Variables
[03.03. - 19:44:47] [ZONE__INIT] Loading zone names
[03.03. - 19:44:47] [ZONE__INIT] Loading items
[03.03. - 19:44:47] [ZONE__INIT] Loading npc faction lists
[03.03. - 19:44:47] [ZONE__INIT] Loading loot tables
[03.03. - 19:44:47] [ZONE__INIT] Loading skill caps
[03.03. - 19:44:47] [ZONE__INIT] Loading guilds
[03.03. - 19:44:47] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter FROM guilds': #1146: Table 'ax_classic.guilds' doesn't exist
[03.03. - 19:44:47] [ZONE__INIT] Loading factions
[03.03. - 19:44:47] [ZONE__INIT] Loading titles
[03.03. - 19:44:47] [ZONE__INIT] Loading AA effects
[03.03. - 19:44:47] [ZONE__INIT] Loading tributes
[03.03. - 19:44:47] [ZONE__INIT] Loading corpse timers
[03.03. - 19:44:47] [ZONE__INIT] Loading commands
[03.03. - 19:44:47] [ZONE__INIT] 200 commands loaded
[03.03. - 19:44:47] [RULES__CHANGE] Loading rule set 'default' (0)
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 10800000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule CharactereathExpLossLevel to value 6
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 1.0000000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value false
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0600000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0300000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 200
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[03.03. - 19:44:47] [RULES__ERROR] Unable to find rule 'Spells:BardSpellAggroMod'
[03.03. - 19:44:47] [RULES__ERROR] Unable to interpret rule record for Spells:BardSpellAggroMod
[03.03. - 19:44:47] [RULES__ERROR] Unable to find rule 'Spells:PetSpellAggroMod'
[03.03. - 19:44:47] [RULES__ERROR] Unable to interpret rule record for Spells:PetSpellAggroMod
[03.03. - 19:44:47] [RULES__ERROR] Unable to find rule 'Spells:SpellAggroModifier'
[03.03. - 19:44:47] [RULES__ERROR] Unable to interpret rule record for Spells:SpellAggroModifier
[03.03. - 19:44:47] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 65000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 60000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value false
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.0000000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:HealOnLevel to value true
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[03.03. - 19:44:47] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.0000000000000
[03.03. - 19:44:47] [RULES__CHANGE] Set rule CharactereathItemLossLevel to value 10
[03.03. - 19:44:47] [ZONE__INIT] Loaded default rule set 'default'
[03.03. - 19:44:47] [ZONE__INIT] Loading embedded perl XS
[03.03. - 19:44:47] [ZONE__INIT] Loading quests
[03.03. - 19:44:47] [ZONE__INIT] Entering sleep mode
[03.03. - 19:44:47] [NET__IDENTIFY] Registered patch 6.2
[03.03. - 19:44:47] [NET__IDENTIFY] Registered patch Titanium
[03.03. - 19:44:47] [NET__IDENTIFY] Registered patch Anniversary
[03.03. - 19:44:47] [NET__IDENTIFY] Registered patch Live
[03.03. - 19:44:47] [NET__WORLD] Connected to World: 127.0.0.1:9000
[03.03. - 19:44:47] [ZONE__WORLD] World indicated port 7002 for this zone.
[03.03. - 19:44:47] [ZONE__INIT] Starting EQ Network server on port 7002

[Stormheart]

Ok I found in the changelog file this sql data I used mysql browser to insert it.


alter table player_corpses add column WasAtGraveyard TINYINT(3) NOT NULL default 0;


After that was placed I was able to zone in!!!!!

4 days of dorking around and I it's actually starting to come together.

Thnks Angelox and lesslamarch for all your help the last few days

[Angelox]

I tried to keep everything as simple as possible by providing backups from MySql-Administrator. You can source in a shell, but you can better use the "Restore" option with MySql-admin, which is very easy to use, and auto-deletes tables you are replacing. You can also easily set users, permissions, etc. with this tool (and make your own backups).
I also have and use MySql Query Browser, which aside from being very easy to use, keeps history of you queries (so you can re-use), bookmarks, and bottom right corner window for help with commands, functions, etc.

[Silenteer]

So the solution to this is.. ?

mysql> ALTER TABLE player_corpses ADD COLUMN WasAtGraveyard TINYINT(3) NOT NULL default 0;

Is that what is to be executed into the Mysql console word for word?

Whats the " (3) " ??

PS. Regarding zone servers.. The more if zone.exe i have open, the higher number of players a zone will support before lagging?

[Stormheart]

I am not an sql programmer so my guess is that the "(3)" defines the TINYINT command to some degree either in decimals or places . Again that is a guess.

The fix to my error "WasAtGraveyard" was this code


"ALTER TABLE player_corpses ADD COLUMN WasAtGraveyard TINYINT(3) NOT NULL default 0;"


It created a field that was previously missing in the "player_corpses" table of the ax_classic database.

[Angelox]

All that exists on AX_CLASSIC - you should have been able to restore and use, as-is. if something didn't work, since no one else as complained, I figure you must have done something wrong, or made a bad download. I currently have it running with the newest executables.

[Silenteer]

I'm just having the same issue as Stormheart, i'll try what he did to resolve the issue. Thanks Angelox.

[Angelox]

Originally Posted by Silenteer

I'm just having the same issue as Stormheart, i'll try what he did to resolve the issue. Thanks Angelox.

Did you use the "full" version of the "core update"?

[Hao3w]

I using the peq database, there is the same error,but execute ALTER TABLE player_corpses ADD COLUMN WasAtGraveyard TINYINT(3) NOT NULL default 0; no useful,still cannot zone in...

anyone has any idea? Thanks a lot!

[cavedude]

Trying using the newest server pack: http://eqemulator.net/forums/showthread.php?t=24611