Quote:
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
Code:
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
Code:
perl eqemu_server.pl check_db_updates