Character_auras missing from fresh install.

[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?

[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

[kwikmr2]

Thanks for the quick reply!

Silly question though, how do I set my 'db_version' back?

[Akkadius]

Originally Posted by kwikmr2

Thanks for the quick reply!

Silly question though, how do I set my 'db_version' back?

This is done in the database via table `db_version`

MariaDB [peq]> select * from db_version;
+---------+
| version |
+---------+
|    9138 |
+---------+
1 row in set (0.00 sec)

You can set it back manually yourself using a DB browser or you can simply run the following query

UPDATE db_version set version = 9130;

[kwikmr2]

Okay, I feel silly for overlooking that table.

My version was at 9132 so I rolled it back to 9130 and ran the db update. Here is my result:

Enter a command #> check_db_updates
[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubuser
content.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
[Database] Reading manifest...
[Database] has update (9130) '2018_11_25_name_filter_update.sql'
[Database] has update (9131) '2018_12_13_spell_buckets.sql'
[Database] has update (9132) '2018_12_16_global_base_scaling.sql'

[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubuser
content.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
[Database] has update (9130) '2018_11_25_name_filter_update.sql'
[Database] has update (9131) '2018_12_13_spell_buckets.sql'
[Database] has update (9132) '2018_12_16_global_base_scaling.sql'

[Database] No updates need to be run...
[Database] Setting Database to Binary Version (9132) if not already...

Thoughts?

[kwikmr2]

Oh, and this is a Windows deploy if that matters.

[Akkadius]

Try setting it back to 9100