Item issues

[iggi]

I have been trying to create items, but I always get this error:

"Run-time error '-2147217871 (80040e31)' : field 'UNK132' doesn't have a default value"

I made a makeshift fix, but I fear in my lack of knowledge I messed something up worse than what it was, this is the query I ran:

ALTER TABLE `items` CHANGE `UNK132` `UNK132` TEXT NULL;

it no longer gives me the error when I use navicat, but it will still tell me the same thing when I use the item editor it gives me the same error. Could someone help me with what I did wrong? Thanks.

[Inspiration]

I think the default is 0, not null. See how that goes.

[Cripp]

i dont even see an UNK132 in my items table.. i would try deleting it.

ALTER TABLE `items` CHANGE `UNK132` `UNK132` VARCHAR(11) NOT NULL DEFAULT ''; ^^<-or try this

ALTER TABLE `items` CHANGE `UNK132` `UNK132` INT(11) NOT NULL DEFAULT '0'; ^^<-or this..

[iggi]

First one returns this:

ERROR 1406 : Data too long for column 'UNK132' at row 1

Second one returns this:

ERROR 1264 : Out of range value adjusted for column 'UNK132' at row 34260

[iggi]

I used navicat to find if any cells had a value to them (sort descending) I came up with only one item:

Battered Silver Runed War Shield (http://everquest.allakhazam.com/db/item.html?item=56383)

which has a value of:

00000400000000000000000000000000000000

After changing this to zero,

ALTER TABLE `items` CHANGE `UNK132` `UNK132` INT(11) NOT NULL DEFAULT '0';
works!
and it apparently gives me no error when coping an item! WOOT!
Thanks a lot. I'm just hoping I didn't brick anything important heh.