[DataBase][Releases] everytime update with changelog

DjAligator to fix it, and thank you very much for everything you do for the people of wow,
from Spain Canary Islands.
Thank you and congratulations.:thumbup:

ok, i have downloaded and installed WhyDB 244 and ArcEmu 1753, configured evertythin and everything seems to be ok. updated my client to 3.0.3

now, when im trying to play on my server i get this message:

"the computer you are playing on, does not contain wow Wotlk information... bla bla bla"

and, whenever i try to play on any other server i can login fine...

is this a problem with my client or with the server that i made???

Hey guys I just upgraded my server but im getting stuck on a realm selection loop. I am Using ArcEmu1753 and WhyDB24. I am patched to 2.4.3 is this the problem are these for the newer patches? Any help would be appreciated and great work DJ!

I am also missing some tables in the database here is a screenshot of the world.exe

you don't restore the server_settings. here should work now
server_setting.sql - 0.2 Kb

K im at 3.0.3 patch and used the serversetting.sql u gave and I can log on but when i create a character and finish my character is not there like i never made him

maybe some sql files you don'y updated, updade that files. Don't ask me what files don't know update from character folder. But maybe you have other structure of characters that are not good. In sql it's all what you need downloaded and restore. From there i use and me and it work very good

I downloaded arcemu1753 and whydb244 and top 3 sql files all from your qsaves. But there are no account, or character sqls in any of the files. Do u know where i can download the ones that will be compatable with ur files. The only ones I could find came from whydb220.

it is character_structure.sql

K I went into db deleted all matching table then restored dump from character_structure.sql, but I still do not have a account table. I have account_data, account_forced_permissons

Sorry for double post I found the logon structure but still same problem make a character when done it brings me back to character selection screen but i have no characters.. Thanks for the help btw

you do something wrong but i don't know what maybe you insert something wrong i don't have any problems with this

Alright I'm gonna give u some info on how i set it up just did a completely new install.

world of warcraft (tbc) updated to patch 3.0.3 (9183)
SQLyog
ArcEmu1753(The second from top of your qsaves)
WhyDB244(3rd from the top of your qsaves)
.sql( the first 3)

K first i dumped the character_structure.sql from your sql(537.9 kb 3rd sql file in the list)
then dumped every file in whydb244
then dumped Logon_structure from the same sql file (537.9)
created 1 admin account
exited sqlyog
started logon server
started world server
logged into server and created random character and accepted
goes to back to character selection but there is no character there.

I did only these steps in this exact order there were no problems everything dumped perfect.
the only thing wrong is when world.exe is loading it give a major error creature_spawn has a table in it that is too large so it skipped loading it.

Is there anything else i didnt dump that needs to be dumped or did I miss a step anywhere along the way?

Thanks again man u rock!!!!

Again I'm sorry for the double post just giving u the update! So i just went ahead and dumped every sql in the sql(537.9kb) pack and it loaded saved my char and works great. The only thing that i noticed is ALL npc run and run really fast, including all creatures. How do i fix that. Other then that it seems to work flawless u are truely a god. Anyway thanks for being so dedicated and your work is greatly appricated I gave u credit for everything in the MOTD!! =)

it must be creature_spawns because you say is skip. You update creature_spawn?

I applied all the sqls in the fullpack u released but some were already there and some gave me errors the creature_spawn sql in the world_updates folder gives me this error


Query:
ALTER TABLE creature_spawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0'

Error occured at:2006-01-02 18:34:03
Line no.:1
Error Code: 1054 - Unknown column 'bytes' in 'creature_spawns'

So I dont know what files actually fixed the orginal problem.

I also made it to Orgrimmar but when i enter it I fall through to the ground its like that in every main city and npc that don't move look like there stuck in a walking position..
real weird

I came across that buildings file u had do i need to put that somewhere or is that for something else

Thanks again