[SOLVED] Trinitycore Database 3.3.5

[Tonzyx]

Heya everyone, well.. I havent been doing private servers for a long time and now i am seting up an 3.3.5a Trinitycore server for me and a few friends to fool around on..
I have pulled the core and everything, maps, dbc, vmaps all that working, but somewhy the World Database will not work.
Here is what the Server.log says:

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.0q 15 Jan 2015 (library: OpenSSL 1.0.0q 15 Jan 2015)
Using Boost version: 1.57.0
Could not prepare statements of the World database, see log for details.

When i try to open the Worldserver it says somthing about "Table World.Graveyard_Zone' doesn't exist."
I have tryed the last trinity tdb also emudevs world db...

 

[Rochet2]

How did you install the DB?
What tools are you using?
Do you get errors?


I install them like this and I use mysqlcli:

I run this:

DROP DATABASE IF EXISTS `tc_335_a`;
DROP DATABASE IF EXISTS `tc_335_c`;
DROP DATABASE IF EXISTS `tc_335_w`;

CREATE DATABASE `tc_335_a`;
CREATE DATABASE `tc_335_c`;
CREATE DATABASE `tc_335_w`;

Then I run
sql/base/auth_database.sql to tc_335_a
sql/base/characters_database.sql to tc_335_w

Then I download latest TDB (58 atm) and execute it to tc_335_w
Then I use this .bat to sum up the updates:

copy *.sql mrg.sql /Y

and I run that to tc_335_w


ps.
I am not entirely sure how we should do it on the latest rev, since this change was made: https://github.com/TrinityCore/TrinityCore/commit/352012e53173372ebc82898e1b6854c983b01b25
I havent read about it much yet..
However I tested on weekend and the old method works just fine anyways - The new changes should just automate the manual steps for updates I guess.

 

[Tonzyx]

Well, i use the auth and characters from the sql/Base then i use the latest tdb from trinitycore currently tdb 58--TDB_full_335.58_2015_03_21.7z
Which did not work, so i pulled world from Github EMUDEVS (https://github.com/EmuDevs/EDB) and i still get the same error

Using Mysql server 5.5.42 and latest heidisql didnt get any errors on any sql i ran

 

[Rochet2]

Are you running anything else than the TDB.sql (one file)?
Can you get the exagt error message?
It seems that CREATE TABLE `game_graveyard_zone` is included in the 58 TDB and thus if you only ran the TDB, you should not have that error.
Check that the DB looks ok. Should have 150~ tables. Check for any graveyard tables etc.
Make sure your core is from 3.3.5 branch of TC, as the master is 6.x