[DiscordArchive] Should I replace this file in my local codebase or run it on the server itself?
[DiscordArchive] Should I replace this file in my local codebase or run it on the server itself?
Original source
Should I replace this file in my local codebase or run it on the server itself?
rektbyfaith
01-08-2023, 12:50 AM #1Archived author: Veltrix • Posted: 2023-01-08T00:50:56.656000+00:00
Original source
Should I replace this file in my local codebase or run it on the server itself?
Original source
I've been stuck here for a while, maybe I'll be done by next year
![[Image: image.png?ex=690bf0fe&is=690a9f7e&hm=35b...10721d77f&]](https://cdn.discordapp.com/attachments/369084351129845760/1061446934927245312/image.png?ex=690bf0fe&is=690a9f7e&hm=35b4a766b0258cb1a2b536b9c4fd069f118c82cd11ee7c30c2888bd10721d77f&)
rektbyfaith
01-08-2023, 12:51 AM #2Archived author: Anchy • Posted: 2023-01-08T00:51:10.085000+00:00
Original source
I've been stuck here for a while, maybe I'll be done by next year
Original source
the cursed 2022_11_03_07
rektbyfaith
01-08-2023, 12:51 AM #3Archived author: Anchy • Posted: 2023-01-08T00:51:32.029000+00:00
Original source
the cursed 2022_11_03_07
Original source
It was a date
rektbyfaith
01-08-2023, 12:51 AM #4Archived author: Foe • Posted: 2023-01-08T00:51:41.977000+00:00
Original source
It was a date
Original source
just run it on the sql character db and then re-run the world and see if that works
rektbyfaith
01-08-2023, 12:52 AM #5Archived author: M'Dic • Posted: 2023-01-08T00:52:08.746000+00:00
Original source
just run it on the sql character db and then re-run the world and see if that works
Original source
Alright
rektbyfaith
01-08-2023, 12:52 AM #6Archived author: Veltrix • Posted: 2023-01-08T00:52:15.106000+00:00
Original source
Alright
Original source
<@209317995057643521> New error returned:
```
>> Applying update "2022_10_13_00.sql" '7121BF9'...
ERROR 1060 (42S21) at line 5 in file: 'C:\Users\root\OneDrive\Documents\GitHub\azerothcore-wotlk\data\sql\updates\db_characters\2022_10_13_00.sql': Duplicate column name 'posO'♪◙
Applying of file 'C:/Users/root/OneDrive/Documents/GitHub/azerothcore-wotlk/data/sql/updates/db_characters/2022_10_13_00.sql' to database 'acore_characters' 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 Character database, see log for details.
```
rektbyfaith
01-08-2023, 12:56 AM #7Archived author: Veltrix • Posted: 2023-01-08T00:56:49.116000+00:00
Original source
<@209317995057643521> New error returned:
```
>> Applying update "2022_10_13_00.sql" '7121BF9'...
ERROR 1060 (42S21) at line 5 in file: 'C:\Users\root\OneDrive\Documents\GitHub\azerothcore-wotlk\data\sql\updates\db_characters\2022_10_13_00.sql': Duplicate column name 'posO'♪◙
Applying of file 'C:/Users/root/OneDrive/Documents/GitHub/azerothcore-wotlk/data/sql/updates/db_characters/2022_10_13_00.sql' to database 'acore_characters' 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 Character database, see log for details.
```
Original source
Line 5 of the file:
```sql
ALTER TABLE `character_homebind`
```
rektbyfaith
01-08-2023, 12:58 AM #8Archived author: Veltrix • Posted: 2023-01-08T00:58:10.851000+00:00
Original source
Line 5 of the file:
```sql
ALTER TABLE `character_homebind`
```
Original source
Alrighty. Now delete the posO collumn and rerun the world one more time
rektbyfaith
01-08-2023, 12:58 AM #9Archived author: M'Dic • Posted: 2023-01-08T00:58:57.859000+00:00
Original source
Alrighty. Now delete the posO collumn and rerun the world one more time
Original source
```
Updating Character database...
>> Applying update "2022_10_13_00.sql" '7121BF9'...
>> Applying update "2022_10_20_00.sql" 'BD0C6FF'...
ERROR 1146 (42S02) at line 3 in file: 'C:\Users\root\OneDrive\Documents\GitHub\azerothcore-wotlk\data\sql\updates\db_characters\2022_10_20_00.sql': Table 'acore_characters.worldstates' doesn't exist♪◙
Applying of file 'C:/Users/root/OneDrive/Documents/GitHub/azerothcore-wotlk/data/sql/updates/db_characters/2022_10_20_00.sql' to database 'acore_characters' 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 Character database, see log for details.
```
***ERR: 1146***
*File: sql/updates/db_characters/2022_10_20_00.sql*
rektbyfaith
01-08-2023, 01:01 AM #10Archived author: Veltrix • Posted: 2023-01-08T01:01:59.041000+00:00
Original source
```
Updating Character database...
>> Applying update "2022_10_13_00.sql" '7121BF9'...
>> Applying update "2022_10_20_00.sql" 'BD0C6FF'...
ERROR 1146 (42S02) at line 3 in file: 'C:\Users\root\OneDrive\Documents\GitHub\azerothcore-wotlk\data\sql\updates\db_characters\2022_10_20_00.sql': Table 'acore_characters.worldstates' doesn't exist♪◙
Applying of file 'C:/Users/root/OneDrive/Documents/GitHub/azerothcore-wotlk/data/sql/updates/db_characters/2022_10_20_00.sql' to database 'acore_characters' 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 Character database, see log for details.
```
***ERR: 1146***
*File: sql/updates/db_characters/2022_10_20_00.sql*