Quote:
Originally Posted by Wizardanim
Sry bout double post... cant edit last one.
I do notice one error in the dynamic list here. (above)
>>Store character inventory failed. Query '<null>' #1264: out of range value adjusted for column 'color' at row 1
will mess with this error and the character inventory tables in the next few days... hopefully this fixes the issue. Exact same setup on both ... just one is dynamic and one is static. Strange how one shows the error but not the other, no? with same server versions.
|
well this error is confusing... apparently it cant save the characters invintory... where the querry was <NULL> ... heres the default schema for invintory
CREATE TABLE inventory (
charid int(11) unsigned NOT NULL default '0',
slotid mediumint(7) unsigned NOT NULL default '0',
itemid int(11) unsigned default '0',
charges tinyint(3) unsigned default '0',
color int(11) unsigned NOT NULL default '0',
augslot1 mediumint(7) unsigned NOT NULL default '0',
augslot2 mediumint(7) unsigned NOT NULL default '0',
augslot3 mediumint(7) unsigned NOT NULL default '0',
augslot4 mediumint(7) unsigned NOT NULL default '0',
augslot5 mediumint(7) unsigned default '0',
instnodrop tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (charid,slotid)
) TYPE=MyISAM;
and this is what i have (double checked) - any ideas? all the values in the table right now are set to 0, dosent seem to be able to save data there.