What version of MySQL ?
Paste the output of these two commands:
Code:
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
mysql> describe inventory;
+------------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-----------------------+------+-----+---------+-------+
| charid | int(11) unsigned | NO | PRI | 0 | |
| slotid | mediumint(7) unsigned | NO | PRI | 0 | |
| itemid | int(11) unsigned | YES | | 0 | |
| charges | tinyint(3) unsigned | YES | | 0 | |
| color | int(11) unsigned | NO | | 0 | |
| augslot1 | mediumint(7) unsigned | NO | | 0 | |
| augslot2 | mediumint(7) unsigned | NO | | 0 | |
| augslot3 | mediumint(7) unsigned | NO | | 0 | |
| augslot4 | mediumint(7) unsigned | NO | | 0 | |
| augslot5 | mediumint(7) unsigned | YES | | 0 | |
| instnodrop | tinyint(1) unsigned | NO | | 0 | |
+------------+-----------------------+------+-----+---------+-------+
11 rows in set (0.01 sec)
mysql>