[SOLVED] Triinity 4.3.4 DB error

[Troya]

Hello today i start work on trinity 4.3.4
i downloaded DB (world) from some onother site.. so i dont have updates sql.

here is my problem. i never worked on 4.3.4 patch so idk how to fix it.

Here is pic:
http://picpaste.com/Trinity_4.3.4_DBC_error-YHnaa0zo.jpg

if you dont see good on pic here is error:

SQL and DBC format strings are not matching for table: 'spell_dbc'
[1146] Table 'cata_world.spelleffect_dbc' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

and there is my DB error:

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

 

[Tommy]

Can't even see your worldserver in that image, even if you maximize it. Regardless, the errors are obvious and tells you what to do.

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

Here is the commit with the sql you want: https://github.com/TrinityCore/TrinityCore/commit/492c695021a220a1e6089db0cf3d734e2d664e87

 

[Troya]

Can't even see your worldserver in that image, even if you maximize it. Regardless, the errors are obvious and tells you what to do.




Here is the commit with the sql you want: https://github.com/TrinityCore/TrinityCore/commit/492c695021a220a1e6089db0cf3d734e2d664e87

Thanks alot it is fixed.
But i got new error and it say:
[1146] Table 'cata_world.creature_summon_groups' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

 

[Tommy]

Thanks alot it is fixed.
But i got new error and it say:
[1146] Table 'cata_world.creature_summon_groups' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

If you look in sql/updates/world, you will find the needed sql. If it isn't in that directory, go to sql/old/4.3.4/ directory. IF you still can't find it, search the repo. If that doesn't solve the issue still, guess that's why you're here, huh?

Surprisingly, I cannot find it anywhere on their repo, unless it is in another unrelated SQL file. Luckily I have a 4.3.4 database, but I'm not sure if the table structures are consistent. Anyway:

 

[Troya]

If you look in sql/updates/world, you will find the needed sql. If it isn't in that directory, go to sql/old/4.3.4/ directory. IF you still can't find it, search the repo. If that doesn't solve the issue still, guess that's why you're here, huh?

Surprisingly, I cannot find it anywhere on their repo, unless it is in another unrelated SQL file. Luckily I have a 4.3.4 database, but I'm not sure if the table structures are consistent. Anyway:

thanks man i downloaded this Source but i cant find some sql-s

the error is new
[1054] Unknown column 'racemask' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

 

[Troya]

IT IS FIXED. YOU CAN CLOSE THIS POST