spleee101
-
Posts
8 -
Joined
-
Last visited
Posts posted by spleee101
-
-
Hello everyone recentely i decided to move to 4.3.4 after getting tired of 3.5.5 anyways ive followed the new guide to make sure i did everything right and while compiling the server and all went well, when
i got to updating the world database i ran into problems, i downloaded the latest updates for 4.3.4 and i used command prompt to merge them all together, then i downloaded the latest TDB full for 4.3.4 and imported it into the world database. Finally i went to import the merged updates and at the very end i get an error ( i know this is not pastebin so i attatched error logs to post)
and if it helps any this is whaty worldserver.exe is saying
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, unit_flags2, 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, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'trainer_spell' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;spleee;world
i appreciate any advice, ive updated trinity dbs numerous times without error and seeing as this is a fresh compile i dont see how i can be seeing this error. thanks in advance.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted · Edited by spleee101
sorry to double post but after going through the errors over and over after manualling updating the db one sql at a time, i found anytime something attempts to modify the equipment id table it errors, i looked into this and equipment id is not even a table in the database?