EQEmulator Forums - Item issues

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Item issues (https://www.eqemulator.org/forums/showthread.php?t=24320)

iggi	02-04-2008 06:39 PM

Item issues

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

Quote:

"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:

Code:

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

02-04-2008 08:46 PM

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

Cripp

02-05-2008 03:42 AM

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

Code:

ALTER TABLE `items` CHANGE `UNK132` `UNK132` VARCHAR(11) NOT NULL DEFAULT '';

^^<-or try this

Code:

ALTER TABLE `items` CHANGE `UNK132` `UNK132` INT(11) NOT NULL DEFAULT '0';

^^<-or this..

iggi	02-05-2008 08:39 AM

First one returns this:

Quote:

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

Second one returns this:

Quote:

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

iggi	02-05-2008 08:44 AM

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

which has a value of:

00000400000000000000000000000000000000

After changing this to zero,

Code:

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.

All times are GMT -4. The time now is 11:53 AM.