[DiscordArchive] <@516689391247425545> I've had similar artik0 duplicate keys and permission issues as you linked and
[DiscordArchive] <@516689391247425545> I've had similar artik0 duplicate keys and permission issues as you linked and
Archived author: Sogla • Posted: 2022-08-08T11:10:06.399000+00:00
Original source
<@516689391247425545> I've had similar artik0 duplicate keys and permission issues as you linked and fixed them on my end, see diff below
The Docker setup breaks on the latest DB change again https://github.com/azerothcore/azerothco...fba4adc235 ```
ac-worldserver_1 | Updating Character database...
ac-worldserver_1 | >> Reapplying update "2022_08_07_00.sql" 'C4A7F10' -> '622251A' (it changed)...
ac-worldserver_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
ac-worldserver_1 | ERROR 1091 (42000) at line 3: Can't DROP 'taxiPath'; check that column/key exists
ac-worldserver_1 |
```
It's similar to the `Duplicate column name 'artkit0'` error and PR https://github.com/azerothcore/azerothco...pull/12419
I've solved the docker issue (+a `permission denied`) on my end with https://github.com/azerothcore/azerothco...otlk:dbfix. However, this is going to be a recurring thing every time a Table is altered. Any clue why update statements are ran more than once with the Docker setup?
[Embed: fix(Core): Crashfix. (#12643) · azerothcore/azerothcore-wotlk@1c6eab5]
https://github.com/azerothcore/azerothco...fba4adc235
[Embed: fix(DB/Installation): key duplicate during import of SQL by franc0...]
Changes Proposed:
multiple duplicate entry found during DB update
Issues Addressed:
#12097
SOURCE:
Tests Performed:
Installation ran fine now
How to Test the Changes:
Install application...
https://github.com/azerothcore/azerothco...pull/12419