Character_auras missing from fresh install.

[Akkadius]

Originally Posted by kwikmr2

I am experiencing the same issue with a little different query:
SELECT 'spell_id' FROM 'character_auras' WHERE 'id' = 4 ORDER BY 'slot'

Any news on this?

This has been resolved for a few months in new installs

mkdir -p /tmp/peq/ && cd /tmp/peq/ && wget http://edit.peqtgc.com/weekly/peq_beta.zip && unzip peq_beta.zip | cat *.sql | grep character_aura
--2019-03-28 16:02:53--  http://edit.peqtgc.com/weekly/peq_beta.zip
Resolving edit.peqtgc.com (edit.peqtgc.com)... 142.44.176.141
Connecting to edit.peqtgc.com (edit.peqtgc.com)|142.44.176.141|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 31338999 (30M) [application/zip]
Saving to: ‘peq_beta.zip’

peq_beta.zip                   100%[========================================================>]  29.89M  4.22MB/s    in 13s

2019-03-28 16:03:06 (2.25 MB/s) - ‘peq_beta.zip’ saved [31338999/31338999]

CREATE TABLE `character_auras` (

If you're still missing it, you can set your `db_version` back in your database to 100 versions or so and run the database schema upgrade tool again and it should pick up any deltas

https://github.com/EQEmu/Server/wiki...nance-commands

To Invoke

perl eqemu_server.pl check_db_updates