[DiscordArchive] I guess quick question here: I'm on Step 4 of setup for AzerothCore, and I've run into trouble with
[DiscordArchive] I guess quick question here: I'm on Step 4 of setup for AzerothCore, and I've run into trouble with
Original source
I guess quick question here: I'm on Step 4 of setup for AzerothCore, and I've run into trouble with trying to populate the databases. My authserver.exe pops up and goes away immediately, and the log is flagging ERROR 1064 to account.sql. There was a post about this on the support-forum, but it hasn't seen any activity in a little over a week, with no response fixing it. So... help?
rektbyfaith
08-14-2025, 01:20 PM #1Archived author: Himbo Jones • Posted: 2025-08-14T13:20:36.010000+00:00
Original source
I guess quick question here: I'm on Step 4 of setup for AzerothCore, and I've run into trouble with trying to populate the databases. My authserver.exe pops up and goes away immediately, and the log is flagging ERROR 1064 to account.sql. There was a post about this on the support-forum, but it hasn't seen any activity in a little over a week, with no response fixing it. So... help?
Original source
copy paste the error
rektbyfaith
08-14-2025, 01:24 PM #2Archived author: Nyeriah • Posted: 2025-08-14T13:24:49.569000+00:00
Original source
copy paste the error
Original source
Sure thing, stand by
rektbyfaith
08-14-2025, 01:25 PM #3Archived author: Himbo Jones • Posted: 2025-08-14T13:25:06.862000+00:00
Original source
Sure thing, stand by
Original source
```Database Auth is empty, auto populating it...
>> Applying 'account.sql'...
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SOURCE C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azer' at line 1♪◙
Applying of file 'C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azerothcore-wotlk-playerbots/data/sql/base/db_auth/account.sql' to database 'acore_auth' 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 populate the Login database, see log for details.
Closing down DatabasePool 'acore_world'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.```
rektbyfaith
08-14-2025, 01:25 PM #4Archived author: Himbo Jones • Posted: 2025-08-14T13:25:27.822000+00:00
Original source
```Database Auth is empty, auto populating it...
>> Applying 'account.sql'...
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SOURCE C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azer' at line 1♪◙
Applying of file 'C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azerothcore-wotlk-playerbots/data/sql/base/db_auth/account.sql' to database 'acore_auth' 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 populate the Login database, see log for details.
Closing down DatabasePool 'acore_world'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'. Waiting for 0 queries to finish...
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.```
Original source
I left out the front bit with the fancy AZEROTH CORE symbol, hope that's alright
rektbyfaith
08-14-2025, 01:25 PM #5Archived author: Himbo Jones • Posted: 2025-08-14T13:25:43.984000+00:00
Original source
I left out the front bit with the fancy AZEROTH CORE symbol, hope that's alright
Original source
Perhaps worth noting as well that I am using the Playerbots fork
rektbyfaith
08-14-2025, 01:27 PM #6Archived author: Himbo Jones • Posted: 2025-08-14T13:27:16.431000+00:00
Original source
Perhaps worth noting as well that I am using the Playerbots fork
Original source
"SOURCE C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azer" this shouldnt be inside the file
rektbyfaith
08-14-2025, 01:29 PM #7Archived author: Nyeriah • Posted: 2025-08-14T13:29:46.122000+00:00
Original source
"SOURCE C:/Private Servers/World of Warcraft/AzerothCore WotLK (Player Bots)/azer" this shouldnt be inside the file
Original source
Sorry, I'm unsure what you mean?
rektbyfaith
08-14-2025, 01:30 PM #8Archived author: Himbo Jones • Posted: 2025-08-14T13:30:58.494000+00:00
Original source
Sorry, I'm unsure what you mean?
Original source
it's trying to execute that what I just posted as if it was sql
rektbyfaith
08-14-2025, 01:31 PM #9Archived author: Nyeriah • Posted: 2025-08-14T13:31:13.073000+00:00
Original source
it's trying to execute that what I just posted as if it was sql
Original source
check your connection strings
rektbyfaith
08-14-2025, 01:31 PM #10Archived author: Nyeriah • Posted: 2025-08-14T13:31:26.800000+00:00
Original source
check your connection strings