Looks like AAs (not just new) may be broken?!?

[wolfwalkereci]

Its working for me on my test environment.
Now if you totally wiped your server and did a brand new install it should work as well.
However I think you are saying that you started with rev2142, compiled the latest rev2197 source and only ran the Rev2197.sql from the peqdb\updates
folder.
If that is the case you missed the XXXX_required_XXX.sql from the source\trunk\EQEmuServer\utils\sql\svn folder.
Those are the sql updates that are released between revision updates, where you are not sourcing the entire db but only recompiling [world/zone/chatserver/queryserv/eqlaunch/emusharemem].

I'm tired so poke me if I'm wrong but thats what I get from reading this.

[cavedude]

No, all of the updates from EQEmu are always inclusive in the newest PEQ dump. Coming from 2142, one only needs to source updates/Rev2197.sql (if using bots, updates/Rev2165-Bots.sql as well) since they are the only updates after 2142. The updates on PEQ only update your player tables, since any updates to system tables are contained within the content DB. The content DB needs to be sourced in as well which in this case is peqdb_rev2197.sql.