Jump to content
TrinityCore

Bodolfo

Plebs
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Spain

Bodolfo's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I was also always wondering if the Server software needs to be recompiled to work with a 4.3.4 database, because I saw there are several changes in the database structure. I saw on the internet there are several 4.3.4 server running. I myself recently created a character on one of them and found they are working normally. So, is there anyone who managed to get a 4.3.4 server working or someone who even upgraded from a 3.3.5a Server? And how did he achieve it?
  2. Hi, there. I used to have a 3.3.5a Server running on my computer with my own character created and everything worked quite fine. Now I found that TrinityCore has advanced to version 4.3.4 and wanted to upgrade my Server as well. So I refered to the manual at http://collab.kpsn.org/pages/viewpage.action?pageId=1704351 I downloaded the DB Repository "TrinityCore_4.3.4_DB_Alpha.git" and also the TDB Full SQL Script "TDB_full_434.05_2013_07_17.sql" As it was described in the manual I created a new world database and imported first the TDB Full SQL Script and then generated the "world_update.sql" Script with the merge_linux.sh Script and imported it into the database. Then I configured my Server with the new database but on start-up it gives me a SQL 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, 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, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" Unknown column 'trainer_spell' in 'field list' 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" Table 'wow_world_4-3-4.ip2nationCountries' doesn't exist " Seems as if there is missing something. I would love if someone who knows or has experienced the same could give me a hint.
  3. Do you try to create a new table "CREATE TABLE `creature_temp`" or a procedure "CREATE*/ /*!50003 PROCEDURE `sp_dev_reguid_alter_tables`" ? if you want to create the procedure you should rethink your sql sentence but if you want to create the table just delete the first line until "CREATE TABLE `creature_temp`".
×
×
  • Create New...