EQEmulator Forums

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 09:55 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.