Errors when executing...

[Kirsebaer]

I always get errors when executing batch files (.sql) files into world db.
I am using ArcEmu, the sql is made for arcemu, so what the hell is happening xD?

[Pedregon]

What are the errors? Can you copy and paste the sql in code tags, please? Need some more info before we can help. ^.^

[Kirsebaer]

What are the errors? Can you copy and paste the sql in code tags, please? Need some more info before we can help. ^.^

[Err] 1054 - Unknown column 'unk4' in 'field list'
[Err] insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('76666', "Taxi", "Teleporter NPC", '', '0', '7', '0', '3', '0', '0', '27545', '0', '0', '0', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully

Trying to make an NPC for my LUA script...
The LUA is fine, but the NPC can't even make it to theDB lol

[Pedregon]

Can you post the SQL that you are executing?

[stoneharry]

The SQL you are executing is not compatible with your database, basically.

[Pedregon]

All you need to do is remove the entry "unk4".

[Ground Zero]

All you need to do is remove the entry "unk4".

Not really, then you have the incorrect amount of info for that row, so you could be giving the npc 400000 damage instead of health if the structure has changed.

[myran2]

[Err] 1054 - Unknown column 'unk4' in 'field list'
[Err] insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('76666', "Taxi", "Teleporter NPC", '', '0', '7', '0', '3', '0', '0', '27545', '0', '0', '0', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully

Trying to make an NPC for my LUA script...
The LUA is fine, but the NPC can't even make it to theDB lol

INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('76666', "Taxi", "Teleporter NPC", '', '0', '7', '0', '3',  '0', '27545', '0', '0', '0', '1', '1', '1', '0');

All I did was remove the unk4 column (9th from the front) then remove the 9th value from the front