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?