View Full Version : [SOLVED] Trinitycore Database 3.3.5
04-07-2015, 03:30 PM
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...
04-07-2015, 03:36 PM
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
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.
04-07-2015, 03:44 PM
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
04-07-2015, 03:55 PM
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
Powered by vBulletin® Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.