["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

yes very true .. been working on this WAY to long trying to get everything working so I can start playing with the game itself and learn more

about it .. get good at this and start contrib to trinitycore

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

I guess when I went to download the TBD i grabbed the wrong ones or something

TDB_full_335.51_2013_02_14.7z correct?

 

I thought thats the one I used ...

 

opening this i have the following:

auth_2013_01_14_2013_02_14

TDB_full_335.51_2013_02_14

world_2013_01_14_2013_02_14

 

I used the auth and characters from the trinitycore base

then did the auth_2013_01_14_2013_02_14

then did the world_2013_01_14_2013_02_14

 

This correct?

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

by patching this to 3.3.5a it should fix all those errors in the worldserver ?

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

yea noticed that it tried to update and like like whoa there dont be doing that .. so I got to go in order of these patches from 3.0.1 to 3.3.5a?  If so, crap thats

ALOT of patching .. if you go out of order then your client is screwed?

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

when i start the wow it says .. downloading updated tools ...

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

im not sure if you all can answer this or not about the patches .. if i was to start patching my client from 3.01 onward, it says I need to do the

2.4.3 patch first before I go to the 3.02 .. has anyone did this or should I just start with the 3.01 to 3.02?

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

im not sure haha after I compiled the authserver and worldserver and ran worldserver it said the following:

Using World DB: TDB 335.50

 

I downloaded the full (i guess so) Wrath of the Lich King .. 6.53GB from the internet ..

 

The startup screen .. where its trying to patch the game says:  3.0.1.8874

 

.. Do I need the patches to patch my way up to 3.3.5a like I see on WoWWiki (which I cant seem to find where to download the

patches) or what?

 

Thanks

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

When running the worldserver this is what I get at the very top:

 

http://TrinityCore.org

Realm running as realm ID 1
Using World DB: TDB 335.50

When I run my WOW client it says:

 

Wrath of the Lich King 3.0.1.8874 ??

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

ok just as a progress note .. I removed the auth, world and character databases, redownloaded the TDB_full_335.51_2013_02_14.  I also,

as following the How-To guide i did the following:

 

1. Create the three databases by importing C:Trinitysqlcreatecreate_mysql.sql. You now have three databases - auth, characters, and world. You may need to refresh your program in order to see the new databases.
2. Click on the "auth" database and import the auth database structure by importing C:Trinitysqlbaseauth_database.sql.
3. Click on the "characters" database and import the characters database structure by importing C:Trinitysqlbasecharacter_database.sql.
4. Click on the "world" database and import the world database structure by extracting and importing the "TDB_full" .sql file you downloaded from the downloading the database section.

Now, the TDB that I downloaded had its own auth, world and TDB_Full, but I followed the How-To directions and used the auth and characters from the

trinitycore not from the TDB itsself.  I also then added the TDB_Full to the "world" database

 

None producted errors but hoping this will fix the problem

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

After starting the WorldServer I'm getting this error message .. Sorry for the long post

I wanted to make sure I got the entire message

 

Database is 3.3.5a taken from trinitycore

Windows Vista

Dbc files taken from the World of Warcraft Wrath of the Lich King

 

Thanks in advance!

 

 

Initialize data stores...
Some required *.dbc files (28 from 96) not found or not compatible:
./dbc/Achievement_Criteria.dbc exists, and has 28 field(s) (expected 31). Extrac
ted file might be from wrong client version or a database-update has been forgot
ten.
./dbc/AreaPOI.dbc exists, and has 46 field(s) (expected 54). Extracted file migh
t be from wrong client version or a database-update has been forgotten.
./dbc/BattlemasterList.dbc exists, and has 33 field(s) (expected 32). Extracted
file might be from wrong client version or a database-update has been forgotten.

./dbc/CreatureModelData.dbc exists, and has 26 field(s) (expected 28). Extracted
 file might be from wrong client version or a database-update has been forgotten
.
./dbc/DestructibleModelData.dbc
./dbc/DungeonEncounter.dbc
./dbc/Faction.dbc exists, and has 53 field(s) (expected 57). Extracted file migh
t be from wrong client version or a database-update has been forgotten.
./dbc/gtOCTClassCombatRatingScalar.dbc
./dbc/Holidays.dbc exists, and has 54 field(s) (expected 55). Extracted file mig
ht be from wrong client version or a database-update has been forgotten.
./dbc/Item.dbc exists, and has 4 field(s) (expected 8). Extracted file might be
from wrong client version or a database-update has been forgotten.
./dbc/ItemExtendedCost.dbc exists, and has 15 field(s) (expected 16). Extracted
file might be from wrong client version or a database-update has been forgotten.

./dbc/LFGDungeons.dbc exists, and has 24 field(s) (expected 49). Extracted file
might be from wrong client version or a database-update has been forgotten.
./dbc/LiquidType.dbc exists, and has 46 field(s) (expected 45). Extracted file m
ight be from wrong client version or a database-update has been forgotten.
./dbc/Map.dbc exists, and has 126 field(s) (expected 66). Extracted file might b
e from wrong client version or a database-update has been forgotten.
./dbc/MapDifficulty.dbc
./dbc/OverrideSpellData.dbc
./dbc/PvpDifficulty.dbc
./dbc/QuestXP.dbc
./dbc/QuestFactionReward.dbc
./dbc/ScalingStatValues.dbc exists, and has 20 field(s) (expected 24). Extracted
 file might be from wrong client version or a database-update has been forgotten
.
./dbc/SoundEntries.dbc exists, and has 29 field(s) (expected 30). Extracted file
 might be from wrong client version or a database-update has been forgotten.
./dbc/Spell.dbc exists, and has 222 field(s) (expected 234). Extracted file migh
t be from wrong client version or a database-update has been forgotten.
./dbc/SpellDifficulty.dbc
./dbc/SpellItemEnchantment.dbc exists, and has 37 field(s) (expected 38). Extrac
ted file might be from wrong client version or a database-update has been forgot
ten.
./dbc/TeamContributionPoints.dbc
./dbc/Vehicle.dbc exists, and has 43 field(s) (expected 40). Extracted file migh
t be from wrong client version or a database-update has been forgotten.
./dbc/VehicleSeat.dbc exists, and has 45 field(s) (expected 58). Extracted file
might be from wrong client version or a database-update has been forgotten.
./dbc/WorldMapArea.dbc exists, and has 10 field(s) (expected 11). Extracted file
 might be from wrong client version or a database-update has been forgotten.