[DiscordArchive] I'm still getting this error when launching worldserver for the first time after building:
[DiscordArchive] I'm still getting this error when launching worldserver for the first time after building:
Original source
I'm still getting this error when launching worldserver for the first time after building:
```
ERROR 1091 (42000) at line 2 in file: '/root/TrinityCore/sql/updates/characters/master/2022_12_16_00_characters.sql': Can't DROP 'guid'; check that column/key exists
Applying of file '/root/TrinityCore/sql/updates/characters/master/2022_12_16_00_characters.sql' to database '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 TrinityCore 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.
```
any idea what that may be, or what I should try to get it to continue?
rektbyfaith
12-17-2022, 07:42 PM #1Archived author: Psynaps • Posted: 2022-12-17T19:42:49.414000+00:00
Original source
I'm still getting this error when launching worldserver for the first time after building:
```
ERROR 1091 (42000) at line 2 in file: '/root/TrinityCore/sql/updates/characters/master/2022_12_16_00_characters.sql': Can't DROP 'guid'; check that column/key exists
Applying of file '/root/TrinityCore/sql/updates/characters/master/2022_12_16_00_characters.sql' to database '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 TrinityCore 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.
```
any idea what that may be, or what I should try to get it to continue?
Original source
mysql version
rektbyfaith
12-17-2022, 07:44 PM #2Archived author: Tea • Posted: 2022-12-17T19:44:20.261000+00:00
Original source
mysql version
Original source
also run this query `SHOW CREATE TABLE character_inventory;` and paste output
rektbyfaith
12-17-2022, 07:44 PM #3Archived author: Tea • Posted: 2022-12-17T19:44:41.613000+00:00
Original source
also run this query `SHOW CREATE TABLE character_inventory;` and paste output
Original source
ubuntu 22.04
rektbyfaith
12-17-2022, 07:44 PM #4Archived author: Psynaps • Posted: 2022-12-17T19:44:45.162000+00:00
Original source
ubuntu 22.04
Original source
ok
rektbyfaith
12-17-2022, 07:44 PM #5Archived author: Psynaps • Posted: 2022-12-17T19:44:46.018000+00:00
Original source
ok
Original source
MYSQL version, not OS version
rektbyfaith
12-17-2022, 07:44 PM #6Archived author: Tea • Posted: 2022-12-17T19:44:52.125000+00:00
Original source
MYSQL version, not OS version
Original source
mysql> SHOW CREATE TABLE character_inventory;
ERROR 1046 (3D000): No database selected
rektbyfaith
12-17-2022, 07:45 PM #7Archived author: Psynaps • Posted: 2022-12-17T19:45:33.330000+00:00
Original source
mysql> SHOW CREATE TABLE character_inventory;
ERROR 1046 (3D000): No database selected
Original source
mysql Ver 8.0.31
rektbyfaith
12-17-2022, 07:46 PM #8Archived author: Psynaps • Posted: 2022-12-17T19:46:11.882000+00:00
Original source
mysql Ver 8.0.31
Original source
did you create databases?
sql\create\create_mysql.sql
rektbyfaith
12-17-2022, 07:50 PM #9Archived author: Wòóz • Posted: 2022-12-17T19:50:55.240000+00:00
Original source
did you create databases?
sql\create\create_mysql.sql
Original source
no i just let worldserver create them.
rektbyfaith
12-17-2022, 07:52 PM #10Archived author: Psynaps • Posted: 2022-12-17T19:52:41.029000+00:00
Original source
no i just let worldserver create them.
1 Guest(s)
1 Guest(s)