[Release] Buildings for Ascent/Antrix

[Sprackle]

Apoligies,sorted

[warsheep]

Ah, great ^^

[Teri928]

hello everyone, ok warsheep you said to post your error message if something got screwed up when executing it. I use HeidiSQL and when i tried to execute the SQL file i imported this is what it have me

/* SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; insert into `gameobject_names` (`entry`, `Type`, `D */

i dont why it does this, i'm sure a just a noob that doesn't know what this means but if you could get back to me on it that would be awesome!=)

[Illidan1]

kk in HeidiSQL highlight on Sql at a time
And press Ctrl+F9

[Teri928]

ok Illidan1 i just tried that and to no avail...still gave me the same error =(
i dont know what is wrong with it...i might just need a new SQL program. If anyone can find it, i would really appreciate it if someone could post me the link for the cracked Navicat

[Teri928]

also...is it possible to have more than one repack? for the databases i mean, or can you download multiple ones and then pick and choose databases?

[warsheep]

First of all, I think that heidi SQL has another syntax and stuff for the DBs.

Second; Its not navicat that control your DB.
Its like your internet browser. Its not Firefox or Internet explorer that is the internet, they just connect to it.

I got no idea how to solve it, there is no syntax error in the thing I posted, try to download it, and re-execute. Perhaps you should un-install heidi SQL, and install Mysql?

[Denelly]

be great if it worked

[kate1]

extreme good, man =)

[kristian92]

the link u posted on your thread din't work... plz! have any1 uploaded it somewhere else?

[elitepower]

i doesnt work for me i get this:





[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000000','14','467','House','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000001','14','368','Moonwell','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000002','14','476','Ship','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000003','14','628','Guard Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000004','14','629','Orc Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000005','14','649','Gold Mine','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000006','14','2170','Bamboo Holding pen','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000007','14','3031','Zeppelin','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000008','14','7019','Tank','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000009','14','7087','NE Ship','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000010','14','7129','Human Siege Tower','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000011','14','7165','Orc Barracks','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000012','14','7246','Gold Altar','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000013','14','7280','Terrorkar Trees','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000014','14','7402','WC2 Dark Portal','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000015','14','471','Stormwind','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999980','5','6556','Elves Dock start','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999981','5','6557','Elves Dock','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999970','5','5975','Westfall tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999994','5','7329','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999995','5','7328','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999996','5','7327','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999997','5','7321','Emerald dream Tree','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0');
[Err] 1054 - Unknown column 'sound0' in 'field list'
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('999998','14','6637','Naxxramas','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0','0');
[Msg] Finished - Unsuccessfully

[kristian92]

I got this error when i executed: Query:
CREATE TABLE `account_overrides` (
`acct` int(20) unsigned NOT NULL default '0',
`gm` varchar(27) NOT NULL default '',
PRIMARY KEY (`acct`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Error occured at:2007-11-24 01:31:35
Line no.:19
Error Code: 1050 - Table 'account_overrides' already exists

Query:
insert into `items` values('33809','15','0','-1','Amani War Bear','Amani War Bear','Amani War Bear','Amani War Bear','37593','4','64','0','0','0','-1','-1','70','70','762','150','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','43 688','0','0','0','330','3000','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','0','','0','0','0','0','0','-1','0','0','0','0','0','0','0',NULL,'0',NULL,NULL,'0',NULL,'0',NULL,'0',NULL,NUL L,NULL,'0','-1','0')

Error occured at:2007-11-30 19:35:28
Line no.:1
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (666,2,7,-1,"Jarands sverd","Jarands sverd","Jarands sverd","Jarands sverd",35097,6,0,0001,9999999999999990000,13,-1,-1,100,255,0,0,0,0,0,0,0,2,1,0,30,50000,16,50000,31,50000,35,50000,12,50000,7,500 00,6,50000,5,50000,4,50000,3,50000,100000,100000,0,100000,100000,1,100000,100000 ,2,100000,100000,5,100000,100000,3,0,10000,10000,10000,10000,10000,10000,1111111 1,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,34696,2,0, 0,0,0,0,"Dette er det sverdet Jarand Nyland bruker når han blir Sinna! >.<",0,0,0,0,0,1,1,0,0,0,0,100000,0,0,0,0,4,0,8,0,0,0,2878,0,0,0,0)

Error occured at:2007-12-01 17:27:03
Line no.:2
Error Code: 1062 - Duplicate entry '666' for key 1

Query:
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (5,2,4,-1,"kristians lille slegge","kristians lille slegge","kristians lille slegge","kristians lille slegge",41558,6,0,0001,9999999999999990000,13,-1,-1,100,255,0,0,0,0,0,0,0,2,1,0,30,50000,16,50000,31,50000,35,50000,12,50000,7,500 00,6,50000,5,50000,4,50000,3,50000,100000,100000,0,100000,100000,1,100000,100000 ,2,100000,100000,5,100000,100000,3,0,10000,10000,10000,10000,10000,10000,9999999 9,0,0,34696,2,0,0,0,0,35844,1,0,0,0,0,18060,1,0,0,0,0,18060,1,0,0,0,0,34696,2,0, 0,0,0,2,"(4//|)!//4//5 lille slegge! du har ingen steder å gjemme deg",0,0,0,0,0,1,1,0,0,0,0,100000,0,0,0,0,4,0,8,0,0,0,2878,0,0,0,0)

Error occured at:2007-12-01 17:37:34
Line no.:2
Error Code: 1062 - Duplicate entry '5' for key 1

Query:
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000000','14','467','House','0','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','0','0','0')

Error occured at:2007-12-05 16:18:40
Line no.:1
Error Code: 1054 - Unknown column 'sound0' in 'field list'

[Succy]

Thanks!... Would rep you if I could(Sorry you cant rep this post...bla, bla!)

[edged]

aha great job man works great

[warsheep]

Great that it works. For kristian92, re-download. Do NOT edit it with your stuff just yet. Then, open the file in notepad, press CTRL+H
Search after:
sound0
Replace with:
spellfocus
Then just spam ok.

Then, when thats done, save it, then import.