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

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?

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

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.

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

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`".