[LF] Need DB developers for the Emucoach repack projects
What's new

World server couldnt open

D

destroz85

Verified Member
19
2016
0
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

____
/\ \ /\ \_
\/_/\ \/ /\_\ /\_\ \, \ _
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2h 3 May 2016 (library: OpenSSL 1.0.2h 3 May 2016)
Using Boost version: 1.59.0
Automatic database updates are disabled for all databases!
Could not prepare statements of the World database, see log for details.


Hello guys i have this server on compiling 4.3.4 i get this when i open world please help and thanks
 
Mr. Satan

Mr. Satan

Admiral Squatbar
Mythical User
Head Moderator
Gold Supporter
MoP Premium
Superior Member
1,012
2016
196
Location
World Martial Arts Championships
destroz85 said:
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

____
/\ \ /\ \_
\/_/\ \/ /\_\ /\_\ \, \ _
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2h 3 May 2016 (library: OpenSSL 1.0.2h 3 May 2016)
Using Boost version: 1.59.0
Automatic database updates are disabled for all databases!
Could not prepare statements of the World database, see log for details.


Hello guys i have this server on compiling 4.3.4 i get this when i open world please help and thanks
Click to expand...

Is your MySQL database open, along with your authserver?
And/or, are your IP's correct? If you're trying to play it locally, meaning it's not public, the IP's should be 127.0.0.1
 
Mr. Satan

Mr. Satan

Admiral Squatbar
Mythical User
Head Moderator
Gold Supporter
MoP Premium
Superior Member
1,012
2016
196
Location
World Martial Arts Championships
destroz85 said:
you can see that i have already set it to 127.0.0.1
http://img15.hostingpics.net/pics/651833database.png
Click to expand...

What about inside the database? I doubt this is the reason, but it's best to check to make sure. The IP for the realm should also be 127.0.0.1.

Try running the MySQL, Authserver, and Worldserver as admin and see if anything changes.
Also, what did the log files say? It says check the logs for details.
 
Rhisk

Rhisk

Senior User
Veteran Member
67
2016
4
Location
Cuba
Hi, i see this error in others servers of Trinity, is because your db not is for the core version that you run, post the errors in your logs here for more details.

Sorry my bad english.
 
ExO

ExO

Admin
5,119
2014
1,639
As you see on the error here: Could not prepare statements of the World database, see log for details.

Please go into your server log and paste the errors here, you have some kind of database error that stops worldserver from running.
 
D

destroz85

Verified Member
19
2016
0
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2h 3 May 2016 (library: OpenSSL 1.0.2h 3 May 2016)
Using Boost version: 1.59.0
Automatic database updates are disabled for all databases!
Could not prepare statements of the World database, see log for details.
 
Rhisk

Rhisk

Senior User
Veteran Member
67
2016
4
Location
Cuba
Lol, enter in Logs folder in your core and post here DBErrors.log, Auth.log and Server.log to see what error you have.
 
D

destroz85

Verified Member
19
2016
0
Could not connect to MySQL database at 127.0.0.1: Unknown database 'auth'
Could not connect to MySQL database at 127.0.0.1: Unknown database 'characters'
Could not connect to MySQL database at 127.0.0.1: Unknown database 'world'
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)"
Table 'world.graveyard_zone' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?"
Table 'world.graveyard_zone' doesn't exist
 
D

destroz85

Verified Member
19
2016
0
this is auth :


TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
Using SSL version: OpenSSL 1.0.2h 3 May 2016 (library: OpenSSL 1.0.2h 3 May 2016)
Using Boost version: 1.59.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.6.31
MySQL server ver: 5.6.31-log
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.6.31
MySQL server ver: 5.6.31-log
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
Started auth database connection pool.
Updating Realm List...
Added realm "Test " at 127.0.0.1:8085.
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Ping MySQL to keep connection alive
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Ping MySQL to keep connection alive
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Updating Realm List...
Ping MySQL to keep connection alive
Updating Realm List...
 
OMGhixD

OMGhixD

Gold Supporter
Epic Member
522
2014
58
World server wise. It's not up to date within the worlddb. Did u update it or did u perhaps forget them? :)
 
Mr. Satan

Mr. Satan

Admiral Squatbar
Mythical User
Head Moderator
Gold Supporter
MoP Premium
Superior Member
1,012
2016
196
Location
World Martial Arts Championships
For future reference, destroz85, please type the CODE tags around something that is going to be that long, such as log files. It saves screen space and scrolling time.
To do that, type: CODE and /CODE inside brackets.

Also, while I may not know much of these things, I would have to agree with Rhisk and OMGhiXD based on the log files.
 
Last edited:
Rhisk

Rhisk

Senior User
Veteran Member
67
2016
4
Location
Cuba
Open worldserver.conf and check if this line is correct in your config:
Code: 
LoginDatabaseInfo     = "127.0.0.1;3306;youruser;yourpass;auth"
WorldDatabaseInfo     = "127.0.0.1;3306;youruser;yourpass;world"
CharacterDatabaseInfo = "127.0.0.1;3306;youruser;yourpass;characters"

The user, pass and db name in your worldserver config must match with the db config. And the field in the table with the fields defined in the core.
 
You must log in or register to reply here.
Top