Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

joe90

Members
 View Profile  See their activity

  • Posts

    29

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by joe90

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

    in Help and Support

    Posted

    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 !!!!

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

    in Help and Support

    Posted

    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

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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?

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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.

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

    in Help and Support

    Posted

    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

×
×
  • Create New...