joe90

hmk i guess i will avoid that then... ty lol

The files arent a repack. They are a full zip of the compile you get from the wiki. Its a read to go set up. I have checked all the files and the db files and there are no credits to the poster. He even confirms the files as full trinity core compile. Thats the only reason why i suggested them. The issues i have found on what i done and now have corrected are as follows:- Trinity version was dated back in febuary. The database was updated to april. Config and maps/vmaps where all april files. The trinity version was not displayed in game (it was blank) and not all the character sql updates where in the compile. These are the problems i found to have with the compile i had and have now corrected them. I do strongly recommend you guys take a look at that link i previously posted and check out the files and advise me on them because the whole post is about a latest version compile straight from trinity core "how-to-win" tutorial with both x64 and x86 versions. But at this time i dont need them files as i have sat down for the last 18 hours and shredded apart my compile and fixed all the missing issues. I thank you all for your advise and apreciate the efforts you ahve all made. I would not have gotten it working without you guys. YOU ROCK !!!!

http://www.ac-web.org/forums/showthread.php?t=142137 now this could solve alot of issues? LOL as it is a full compile of the files with all updates done cleanly. Would this be suitable?

2012-05-07 17:11:47 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. 2012-05-07 17:11:47 MySQL client library: 5.5.9 2012-05-07 17:11:47 MySQL server ver: 5.5.16 2012-05-07 17:11:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-05-07 17:11:47 [ERROR]: In mysql_stmt_prepare() id: 12, sql: "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE username = ?" 2012-05-07 17:11:47 [ERROR]: Unknown column 'os' in 'field list' 2012-05-07 17:11:47 MySQL client library: 5.5.9 2012-05-07 17:11:47 MySQL server ver: 5.5.16 2012-05-07 17:11:47 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-05-07 17:11:47 [ERROR]: In mysql_stmt_prepare() id: 0, sql: "SELECT id, name, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name" 2012-05-07 17:11:47 [ERROR]: Unknown column 'flag' in 'field list' 2012-05-07 17:11:47 [ERROR]: In mysql_stmt_prepare() id: 18, sql: "SELECT id, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale, recruiter, os FROM account WHERE username = ?" 2012-05-07 17:11:47 [ERROR]: Unknown column 'os' in 'field list' hmk 1st error LOL it seems i suck at doing DB creating....lmao

hmk i will redo the world db but its not the world db it crashes on its the auth process it freezes. When authenticating. But as i said before. The logging in does work i have flown around edited npc's and everything. But once i log out it will never allow a log back in unless i reboot the auth and world. But the realmlist point or just before it is where the issues seem to occur. I will redo the db's again and maybe even recompile a whole new server and see what happens. But this is my 7th attempt at rebuilding it and still same results.

Any links or directions to help me fix these issues? it will help me in learning how to correct bugs and issues. Thanks for your response.

This is getting annoying now. People get random access to server and only 1 person at a time seems to be able to log on even when the player limit is 50. Does anyone know why this is happening?

yes i did. I did transfer the sql dll's over as instructed in the tutorial. Also how do i fix this trinity core rev version? I am using the latest xamp sql version also yes.

http://pastebin.com/hMtQYt67 http://pastebin.com/h7zZdjFk http://pastebin.com/CvbwbPFH http://pastebin.com/Ynfr2KwH The are the paste bins of the logs from the server when it loads up im guessing the error for a unstable log in to the realm list is somewhere in the files. Any advice would be appreciated. I also cleaned up the db and removed excess db's it seemed to take no effect.

as i said before people do get to log on but it is random and if they disconnect they cant relog on. So the ports must be fine and settings are fine as they manage to log on in the first place. It just seems limited to 1 person and only on 1 occasion. The db's seem to have been loaded from the files i downloaded from github. What are the 6 main tables so i can delete the others in auth?

But they can connect but its random. They dont always seem to connect. and after they connect once i have to reboot the server to get them access again. So the settings seem ok. Just not stable. I have noticed there seems to be over 50 tables in my auth db im sure there is meant to be only 6? can you please confirm this and what tables should be in auth db so i know what to keep and what to delete.

they connect via internet and i connect via same computer.

OK i have done some looking around on my configs and found nothing that could be stopping people connecting. I have managed to get 1 friend to connect without an issue but then once they connect i cant, and get stuck at authenticating, and visa versa. Seems like only 1 person can connect cleanly and they have only 1 chance to connect aswell. If it fails i have to reboot server.

Also seems that other people try to connect to the server and just get it frozen at authenticating.

Seems now that i have it all working everything is great. Just 1 issue now. When i log off i cant log back on as the client seems to freeze. I have to shut down and reactivate the server to be able to reconnect to server. Is there a way to fix this?

Well thank you everyone for your information. The official fix for my errors was, i had the wronf db version and i was using v3 map extractor. I therefore used v4 map extractor and corrected the db version and build with fresh install and got the requird results. Everything functions as it should. Thank you all for your support.

so vmaps v4 is better?

ok i used the v3 map extractor and everything else i redone the db and used the updates from the sql folder for world and character. Also used https://github.com/downloads/TrinityCore/TrinityCore/TDB_full_335.11.46_2012_02_13.rar and Import ALL the sqls in /sql/updates/world to world database. Now all im getting is 2012-05-03 16:19:18 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1 2012-05-03 16:19:18 WORLD: VMap data directory is: ./vmaps 2012-05-03 16:19:18 ERROR: Map file './maps/0004331.map' is from an incompatible clientversion. Please recreate using the mapextractor. 2012-05-03 16:19:18 ERROR: Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map/*.vmtree/*.vmtile files in appropriate directories or correct the DataDir value in the worldserver.conf file.

Hmk i will redit the vmaps,maps, buildings and database and get back to you with the reults. Do i still use the update files for the DB?

it seems the 4x branch i recieved from the complie... so ermmm i am having to find other peoples compiles and take part from that as i have compiled 4 times now with same results, all the parts are 4x even the extractors....

this all came from the wiki i got everything from there. So is there another location i can get the db from if 4x is wrong?

ok i change the build and now it cant even retrieve the realm list table.. I reverted back to origional build 14480 and i can now view the table again just cant see the realms. So it seems the build is fine. http://i869.photobucket.com/albums/ab256/jenks1999/authdbrealmlist.png Thank you for your suggestions. I have actioned them all and found no results. I have paste binnned the config files previously with all configs.

Ty for the heads up there... pastebin for world updated ^^ lol the server is running off my computer and so i have it running on 127.0.0.1 or should i change it to the dyndns info? yes i have realm name set up on the auth DB and thats in the realmlist. Hmm i will look around for more info, although i have already tried im guessing i didnt try well enough lol... any further advice would be apreciated.

thank you for tidying it up lol

hmk here are my configs and i have obviously edited my login information to my database.... http://pastebin.com/4Uw73WpN http://pastebin.com/gq6HGkdk the database seems to be correct with a 127.0.0.1 for the realmlist. port is set to 8085 game build is 14480. and the name of the realm is Gladiator. Also thank you for the welcome and hope i dont cause too many issues LOL. apologiese for that it didnt refresh instantly i do apologise for that miss typing... i guess i am still learning the system here.... lol