Trinitycore: Database Error

[rafaelrodrigosilveira]

Im trying update my trinitycore 3.3.5 from database 59 to last review. But im stack in this error above:

Applying of file '/home/kow/SOURCE/TrinityCore-14-04-2016/sql/old/3.3.5a/world/59_2015_11_07/2015_07_19_00_world_2015_07_18_04.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query.

How to fix this? This is a DataBase error? You will fix this?

Thanks guys

[TrinityCoreBot]

This issue is not considered valid because of the following reasons:

• No proper commit hash (revision)

Please read http://bit.ly/tc-issuetracker-and-you . Thanks.

[Aokromes]

That sql file is working fine you have modified your database?

[rafaelrodrigosilveira]

Yes it's work well in my server, but I have been installed my trinitycore server in 2015, and now I.ve try to update, but this don't work. The sql automatic update start, but when arrives in this sql (2015_07_19_00_world_2015_07_18_04.sql), this error occurs. Thanks for try to help me.

see my core e database version:

TrinityCore rev. 50cf74f0dbe1 2015-10-08 13:02:47 +0200 (3.3.5 branch) (Unix, Release),50cf74f0dbe1,"TDB 335.59",59

[ghost]

You cannot use the auto DB updater feature to update the world DB directly from a pre-autoupdater DB version to the current version of TDB. You have to completely empty your world DB (perform SQL backup first if you have got any custom content) and then let the auto DB updater load TDB_full_335.61_2016_04_11.sql from your core folder into the world DB followed by the new /sql/updates/world/*.sql files which are copied automatically into world to make your DB work.

This is also true for your auth and characters databases, so perform backups of your characters if you want to keep them before starting with a completely empty DB and let the auto DB updater do its job. If you want to restore your old characters, I am fairly certain that you need to do a step-by-step upgrade by running all the TDB 335.60 /sql/updates/characters/*.sql files manually on your old characters DB (assuming that you have already applied all the TDB 335.59 /sql/updates/characters/*.sql files) before it will be possible to export your characters from the old DB and import them to the new one.

To wait as long as you have, before adding all the DB updates, has some very obvious drawbacks.

[rafaelrodrigosilveira]

I've been try before, the manually sql updates, but this same error occors. I'll try to import one blank database full, and automatic update, and after i will to import only data from auth, characters and world databases. Thanks, and is somebody have any idea, please, help me.

[Aokromes]

Well, anyway, it's not TC bug. You may want to import TDB 61 on other database and export updates table and import it to your database and remove the rows you don't have applied. If you still have problems jump into irc.