[DiscordArchive] Hi my worldserver keeps closing the second i open it, I managed to fix my authserver but still got t
[DiscordArchive] Hi my worldserver keeps closing the second i open it, I managed to fix my authserver but still got t
Original source
Hi my worldserver keeps closing the second i open it, I managed to fix my authserver but still got the issue with world. any ideas on how to fix this? or what may be the cause?
rektbyfaith
07-12-2022, 11:03 PM #1Archived author: Luke • Posted: 2022-07-12T23:03:15.520000+00:00
Original source
Hi my worldserver keeps closing the second i open it, I managed to fix my authserver but still got the issue with world. any ideas on how to fix this? or what may be the cause?
Original source
Open the worldserver using command prompt, then let us know the error it gives you
rektbyfaith
07-12-2022, 11:04 PM #2Archived author: Bench • Posted: 2022-07-12T23:04:22.111000+00:00
Original source
Open the worldserver using command prompt, then let us know the error it gives you
Original source
```cmd
In mysql_stmt_prepare() id: 444, sql: "SELECT source, data FROM character_settings WHERE guid = ?"
Table 'acore_characters.character_settings' doesn't exist
In mysql_stmt_prepare() id: 445, sql: "REPLACE INTO character_settings (guid, source, data) VALUES (?, ?, ?)"
Table 'acore_characters.character_settings' doesn't exist
In mysql_stmt_prepare() id: 446, sql: "DELETE FROM character_settings WHERE guid = ?"
Table 'acore_characters.character_settings' doesn't exist
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Could not prepare statements of the Character database, see log for details.
Closing down DatabasePool 'acore_world'.
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
```
rektbyfaith
07-12-2022, 11:08 PM #3Archived author: Luke • Posted: 2022-07-12T23:08:50.480000+00:00
Original source
```cmd
In mysql_stmt_prepare() id: 444, sql: "SELECT source, data FROM character_settings WHERE guid = ?"
Table 'acore_characters.character_settings' doesn't exist
In mysql_stmt_prepare() id: 445, sql: "REPLACE INTO character_settings (guid, source, data) VALUES (?, ?, ?)"
Table 'acore_characters.character_settings' doesn't exist
In mysql_stmt_prepare() id: 446, sql: "DELETE FROM character_settings WHERE guid = ?"
Table 'acore_characters.character_settings' doesn't exist
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Could not prepare statements of the Character database, see log for details.
Closing down DatabasePool 'acore_world'.
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
```
Original source
something went wrong while applying sql files/importing database or your database is out of sync with your core
rektbyfaith
07-12-2022, 11:11 PM #4Archived author: Nyeriah • Posted: 2022-07-12T23:11:38.143000+00:00
Original source
something went wrong while applying sql files/importing database or your database is out of sync with your core
Original source
What would that mean as my auth opens no issues? would it have been because i bulk added the files from sql dir into my heidi instead of individually like i did auth and chars?
rektbyfaith
07-12-2022, 11:12 PM #5Archived author: Luke • Posted: 2022-07-12T23:12:25.385000+00:00
Original source
What would that mean as my auth opens no issues? would it have been because i bulk added the files from sql dir into my heidi instead of individually like i did auth and chars?
Original source
After i added them all from sql dir into the DB with heidi my auth then opened but world still fails to open?
rektbyfaith
07-12-2022, 11:12 PM #6Archived author: Luke • Posted: 2022-07-12T23:12:55.673000+00:00
Original source
After i added them all from sql dir into the DB with heidi my auth then opened but world still fails to open?
Original source
yes, you shouldn't need to be doing that, you should just start up your world server and press "yes" once it asks you to load the databases
rektbyfaith
07-12-2022, 11:13 PM #7Archived author: Nyeriah • Posted: 2022-07-12T23:13:00.824000+00:00
Original source
yes, you shouldn't need to be doing that, you should just start up your world server and press "yes" once it asks you to load the databases
Original source
from a fresh compiled core?
rektbyfaith
07-12-2022, 11:13 PM #8Archived author: Luke • Posted: 2022-07-12T23:13:13.564000+00:00
Original source
from a fresh compiled core?
Original source
it's very likely you missed a file when copying them
rektbyfaith
07-12-2022, 11:13 PM #9Archived author: Nyeriah • Posted: 2022-07-12T23:13:22.370000+00:00
Original source
it's very likely you missed a file when copying them
Original source
if your databases are empty, the core will ask you if you wish to load them automatically the first time you start up, if you press yes it will do everything for you
rektbyfaith
07-12-2022, 11:13 PM #10Archived author: Nyeriah • Posted: 2022-07-12T23:13:59.442000+00:00
Original source
if your databases are empty, the core will ask you if you wish to load them automatically the first time you start up, if you press yes it will do everything for you
1 Guest(s)
1 Guest(s)