[DiscordArchive] So, I've been getting an odd error since I started doing this project. I'm considering deleting the
[DiscordArchive] So, I've been getting an odd error since I started doing this project. I'm considering deleting the
Original source
So, I've been getting an odd error since I started doing this project. I'm considering deleting the VM and starting over just to see if it happens again.
Updating World database...
>> Applying update "2022_06_14_01.sql" '90B07D9'...
ERROR 1060 (42S21) at line 3: Duplicate column name 'artkit0'
Applying of file '/home/core/azerothcore/data/sql/updates/db_world/2022_06_14_01.sql' to database 'acore_world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.
I'm not good in mysql, and can't find the duplicate that it's speaking of. Should I just delete that particular database and try again?
rektbyfaith
07-14-2022, 11:33 PM #1Archived author: brightboyit • Posted: 2022-07-14T23:33:39.122000+00:00
Original source
So, I've been getting an odd error since I started doing this project. I'm considering deleting the VM and starting over just to see if it happens again.
Updating World database...
>> Applying update "2022_06_14_01.sql" '90B07D9'...
ERROR 1060 (42S21) at line 3: Duplicate column name 'artkit0'
Applying of file '/home/core/azerothcore/data/sql/updates/db_world/2022_06_14_01.sql' to database 'acore_world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the World database, see log for details.
I'm not good in mysql, and can't find the duplicate that it's speaking of. Should I just delete that particular database and try again?
Original source
Actually, deleting the database acore_world, creating a new database with that name (but empty), then running the ./worldserver command and allowing the automatic updater to repopulate the db worked fantastically.
rektbyfaith
07-15-2022, 12:06 AM #2Archived author: brightboyit • Posted: 2022-07-15T00:06:55.046000+00:00
Original source
Actually, deleting the database acore_world, creating a new database with that name (but empty), then running the ./worldserver command and allowing the automatic updater to repopulate the db worked fantastically.
1 Guest(s)
1 Guest(s)