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

Yes.

http://www.fileplanet.com/100462/0/section/Patches

You need to get patched up to 12340 (335a) and then re-run the map extraction data tools and replace what you currently have.

Also, why are you using 50? You should have gotten 51, unless you are intentionally using an earlier revision.

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?

Open WoW.exe and note the text on the bottom left. (it should say Version X.X.X). This is your starting point. Patch up from there until you reach 3.3.5a or 12340. Feel free to use whatever patch source you want, I just provided the one that looked the most trustworthy on first google attempt.

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

Make sure you are specifically opening wow.exe from your /World of Warcraft/ directory. Do not launch using the desktop icon (delete that or change the exe it points to) and do not open “launcher.exe”. Doing either of these will force your client to update from official, which will bring you straight to 4.x 5.x.

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?

Yes, it’s a pain in the ass, and yes, you’re screwed. But it’s virtually impossible to make that mistake. Just download all the patches you need, and then apply them one by one. A patch applied out of order will refuse to patch.

My advice: once you’ve fully patched your client, make a copy of the folder (/World of Warcraft/). This way you will always have a good copy should you need to restore. I run mine from an external so it’s always there.

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

+Guybrush you mean straight to 5.x not 4.x.

+akrin05 you also need to go back and download TDB 51 instead of 50.

Nope. Refer to this post once you have completely patched up.

Oh yeah, right. /emoticons/default_smile.png So used to typing 4.x…

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?

Since the TDB was last created on 2/14, you will also need to apply all updates in “source/sql/updates/”. This process is pretty thoroughly explained in the wiki: http://collab.kpsn.org/display/tc/How-to_Win#How-to_Win-InstallingTheTrinityDatabases

Think a bit, if you have TDB_full_335.51_2013_02_14, what makes you think you need world_2013_01_14_2013_02_14 and auth_2013_01_14_2013_02_14?

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

So does this mean that there’s an sql file missing from the update folders?

I understand this isn’t being reported in the correct area im just trying to understand so i can attempt to try and fix it. Im also getting the same error /emoticons/default_smile.png

I would have started a new topic but people rip your head off when you’re trying to learn about the 4.3.4 source and ask a question they consider stupid.

It’s not exactly encouraging people to help with the trinitycore project when everytime someone attempts to compile the source to see how it can be improved and get errors and then ask for advise on these errors they get called stupid.

You say that 4.3.4 is unsupported for people who are struggling with an error that may be easily solved, but how are we meant to learn and not be that person if we’re not told or at least given advise on how to fix the issue.

4.3.4 is for ppl with knowledge of what they are doing, for developers, not to create servers. If they can’f fix basic errors, for sure they can’t fix real errors.

ok so, how do new users learn this knowledge. Personally as a new user trying to understand these errors i would attempt to compile the source and work on each error i ran into, improving my knowledge each time. Of course id normally look to forums for help but this project you just get told that if you’re not good enough leave. Well where am i meant to learn??

How do you know if you’re developing is working if you dont compile and test it??? :S

Here’s a real good question. If 4.3.4 is for people with knowledge then why haven’t they found a fix for this error and updated the files??

I may sound arrogant telling others they should be fixing it, but when ever i try and ask for advise on an error like this one i get shot down and told not to bother.

Master branch.

I get no errors compiling master branch, I do however with, 4.3.4. Can you at least attempt to explain what the error is and where you personally would look first to attempt to fix it, so that i can have a look. Or dont you know whats causing the error?

I don’t care of ppl trying to create servers on 4.3.4 branch, if you can’t fix yourself the startup, stay on master.

Tip: lack of resync.