Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

Aokromes

Moderators
 View Profile  See their activity

  • Posts

    4497

  • Joined

  • Last visited

  • Days Won

    229

 Content Type 

Posts posted by Aokromes

  22. Trouble with your Trinity Install / Starting / Login / Readme 1st / FAQs

    in Help and Support

    Posted

    Database install errors

    Please note that the software called Navicat is NOT supported due to issues with how it handles SQL-files with "/* */"-style comments. We advise all users to stay well clear of this program unless they really are looking for issues.

    TCE00001 My core don't starts i get: 

    [1146] Table 'world.updates_include' doesn't exist
Your database structure is not up to date. Please make sure you've executed all
queries in the sql/updates folders.

Maybe you are updating one very ancient core and missed some sql, easy way is drop all your trinitycore databases (auth, character, hotfixes, world) and leave core to import the databases if you don't care about data.
Another way can be create temporally the needed databases and allow core to import the sql files, then export the updates and updates_include tables from those databases and import them to your production core (be sure you have updated your databases to max before import the updates tables to your production core).

    REMEMBER: core needs one user with create table/alter table/drop table permisions.

    TCE00002 My core don't starts i get: 

    2012-07-11 16:47:10 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
2012-07-11 16:47:10 ERROR: Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world
	 
Unknown column 'level' in 'field list'
	 
2012-07-03 23:01:12 ERROR:
E:TrinitysrcserversharedDatabaseMySQLConnection.cpp:531 in MySQLConnection::_HandleMySQLErrno FATAL ERROR:
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
	 
This means DB structure was changed, you need to apply the sql files found at sql/updates (this also can mean you have updated your db structure but you forgot to install the updated core)
If you use the most updated master branch and you don't have custom things DROP your world database and get the most updated TDB from GET TDB then apply the sql files found at sql/updates.
If you can't or you don't want to drop your world database or droping world database don't fixes your problem enable SQLDriverLogFile on your worldserver.conf file.

If you get those errors whatever you are trying on world database, use http://www.trinitycore.org/f/topic/43-windowslinux-combine-sql-updates/ to create a 2 files instalation system to be sure you don't miss any sql file.
Under Linux you can use rgrep <insert here the missing column name> sql/updates/*.sql to see what file you miss.
Under Windows you can use notepad++ or ultraedit 32 to search the file you miss.
Anyway if you have world db structure problems, we sugest you to DROP world db and leave core to import the files, because maybe you have missed some.

    TCE00003 My server don't starts, i get: 

    >> Loaded 0 trinity strings. DB table `trinity_string` is empty.

This is because you forgot to import world database or you have enabled autoupdater but missed to put world database on the worldserver directory or imported travis world database instead proper database.

If you get "unknown column" or "unknown table" error it can be because 10 reasons:
	 
1) You have cloned master repository (3.3.5a) and installed TDB, but you forgot to apply the files present on sql/updates/world you need to run those to properly start core.
2) You have updated your database, but you forgot to update your binary files, you usually can't run older cores with newer databases.
3) You have updated your core, but you forgot to update your database, you usually can't run older databases with newer cores. MOST COMMON CASE
4) You have download 4.3.4/6.x databases, but you cloned 3.3.5a repository you can't use 6.x/4.3.4 databases with 3.3.5a core.
NOTICE use one very high range to avoid to get your spawns/scripts deleted when a new TDB is released unless you drop the full DB when updating.
NOTICE2: if you don't drop your world database you will end with double spawns.
8) You are trying to use a custom patch and you forgot to apply the sql files for it or they don't exist.
9) You are trying to use one sql for another project or deprecated sql files.
10) You are trying to apply the same update 2 times.
    • Upvote 4
×
×
  • Create New...