search

Sarjuuk / aowow

Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
204 stars 217 forks source link

MySQL 8.4 #413

Closed jackpoz closed 5 months ago

jackpoz commented 6 months ago

Describe the bug and how to reproduce it Upgrading to MySQL 8.4 showed this warning during the upgrade process:

Foreign key 'FK_acc_weightscales' on table 'aowow'.'aowow_account_weightscales' refers to non-unique key or partial key. This is deprecated and will be removed in a future release. Deprecated 'foreign key referring to a non-unique or partial key' used 1 times, last time used 'during upgrade'.

This showed up in the .err file which is located by default in the /data directory of MySQL.

Screenshots No screenshot available

System:

Sarjuuk commented 6 months ago

aowow_account_weightscale_data's FK_acc_weightscales REFERENCES aowow_account_weightscales (id) but aowow_account_weightscales PRIMARY KEY is (id,userId)

.. why tho..?

Sarjuuk commented 5 months ago

probably fixed in 7d5930865ca2348ba454ea401f1cd7ef3f269984

feel free to reopen if not.