sql vs SH tool error

[GMCronus]

i'm so lost.

I been running this for years. I even changed to a really old PS_GameDefs to see. BUT


i keep getting this error from my monster.sql

Column name or number of supplied values does not match table definition

i only added some items to some mobs and this happens. i even tried to delete the monster.sql. i tried using 0.7.5.5 and 0.7.0.1 to make new.

what happends?

well this is the setup




ok so i run it. what happends?

MobItems work. there all there

BUt Mobs? 0 mobs. What have i done wrong now?




what is wrong?

 Spoiler

TRUNCATE TABLE [PS_GameDefs].[dbo].[Mobs];
TRUNCATE TABLE [PS_GameDefs].[dbo].[MobItems];
GO
INSERT INTO [PS_GameDefs].[dbo].[Mobs] values (0,'Error Monster',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,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

How my script starts

[XareL]

I see your MapName column in db.
I used to encounter this problem.
You try delete MapName column because MapName for dbo.Mobs not original column
and i think you installed

[GMCronus]

lol thanks. that's it. but it hade allow null . strange. but thanks a lot