mazu

Been away during the weekend and it seems my friend isn't home, i'll get back to this after we try it out later tonight, thanks for all the advice and help so far guys, hopefully this'll be solved soon

Thanks for the links he is currently downloading it, his internet is a bit slow compared to my 100mbit connection so it'll take some time.

He is currently repairing it, it seems, otherwise i'll direct him towards a torrent, used to be easier to get clients a year or two ago.

using the exact same client as he does and it's not hacked nor have we modded any mpq files nor any dbc files. But i'll tell him to try and re-download the client and try again, thanks for the answer, i'll get back to you guys with an answer.

Extremly sorry about not having spoiler tags on them, but i have no clue how to add that on here.

I'll post both my configs in code. hold on Auth: World:

Warden is off in the config.

Hi it seems that my friend keeps disconnecting on loadingscreens and we checked to see if it works normally on other servers and it did, the problem seems to lie within gm access for some reason, when the realmid is -1 it disconnects him, if it's 1 it keeps him on but disconnects when loading screens pop up, on 1 it just doesn't work, etc, could anyone help out? Ports: All are open and forwarded properly, checked on a portchecker. Dns is linked. ip is correct seeing as he is able to connect at certain points stated above. Don't know if this will help, but getting this error in server logs when he gets disconnected WorldSocket::handle_input_header(): client (account: 0, char [GUID: 0, name: <none>]) sent malformed packet (size: 36189, cmd: 718358803)

selected them properly.

Using heideisql...

Hey there i seem to be getting an error while importing the tdb_full, the most recent one (2 months old) here's the error u have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'world' at line 2 */ Can't seem to get my head around it

Alright, how about the mismatch is that a problem aswell, dunno how to fix that part. I'll search for 'em cheers for telling me mate. Any names to search for? tried searching for SQL import/importer but nothing showed up. ..i'm stupid, found it in utillities >.< works now, cheers mate.

think i updated everything, that was recently released in the pull.. so i'll try again and see if it works then. is there any programs that'll apply all the updates at once, instead of having to go into individual sql's and copy and paste? this is the error i get: 2012-04-13 10:21:22 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1. 2012-04-13 10:21:22 MySQL client library: 5.5.9 2012-04-13 10:21:22 MySQL server ver: 5.5.22 2012-04-13 10:21:22 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-04-13 10:21:22 MySQL client library: 5.5.9 2012-04-13 10:21:22 MySQL server ver: 5.5.22 2012-04-13 10:21:22 [WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements. 2012-04-13 10:21:22 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" 2012-04-13 10:21:22 [ERROR]: Unknown column 'HoverHeight' in 'field list' 2012-04-13 10:21:22 [ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1" 2012-04-13 10:21:22 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

Hey it seems that after i have configured my world.conf to the right mysql settings it won't connect for some reason, authserver is working perfectly without any problems with the same settings. here's the error 2012-04-13 09:08:50 Using configuration file worldserver.conf. 2012-04-13 09:08:50 Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.0b 16 Nov 2010) 2012-04-13 09:08:50 Using ACE version: 5.8.3 2012-04-13 09:08:51 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon) 2012-04-13 09:08:51 <Ctrl-C> to stop. 2012-04-13 09:08:51 ______ __ 2012-04-13 09:08:51 /\__ _\ __ __/\ \__ 2012-04-13 09:08:51 \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ 2012-04-13 09:08:51 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ 2012-04-13 09:08:51 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ 2012-04-13 09:08:51 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ 2012-04-13 09:08:51 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ 2012-04-13 09:08:51 C O R E /\___/ 2012-04-13 09:08:51 http://TrinityCore.org \/__/ 2012-04-13 09:08:51 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. 2012-04-13 09:08:51 ERROR: Cannot connect to world database 127.0.0.1;3306;root;ascent;world Bit new to the trinity, so would be great with some help on this issue.