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 Character:DeathExpLossLevel 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 Character:DeathItemLossLevel 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 (http://dev.mysql.com/downloads/gui-tools/5.0.html). 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 (http://dev.mysql.com/downloads/gui-tools/5.0.html), 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]

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