Forums WoW Modding Support Archives Azerothcore Discord Archives [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

[DiscordArchive] <@516689391247425545> I've had similar artik0 duplicate keys and permission issues as you linked and

rektbyfaith
Administrator
0
08-08-2022, 11:10 AM
#1
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
rektbyfaith
08-08-2022, 11:10 AM #1

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

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)