medic
05-03-2007, 16:06
Sorry, i am sure i am bugging now:
mysql> explain history_text;
+--------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | 0 | |
shouldn't id maybe be auto-increment ?
because the server is trying to insert without giving ID field, which means it's null and cannot insert because of duplicate (primary uniq) key ..
best regards
Andreas
P.S.: and thank you for being so patient with me
mysql> explain history_text;
+--------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | 0 | |
shouldn't id maybe be auto-increment ?
because the server is trying to insert without giving ID field, which means it's null and cannot insert because of duplicate (primary uniq) key ..
best regards
Andreas
P.S.: and thank you for being so patient with me