Hi. I use MySQL 4.0.17 from rpm. When I want insert new row by perl script to one of my table I get such error : DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by .......' for key 3 Table looks : mysql> desc spak; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | id_lacz | int(11) | YES | MUL | NULL | | | selektor | int(4) | YES | MUL | NULL | | | data | mediumtext | YES | MUL | NULL | | +----------+------------+------+-----+---------+-------+ 3 rows in set (0.01 sec)
mysql> show index from spak; +-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | spak | 1 | spak_id_lacz | 1 | id_lacz | A | 206999 | NULL | NULL | YES | BTREE | | | spak | 1 | spak_selektor | 1 | selektor | A | 5 | NULL | NULL | YES | BTREE | | | spak | 1 | spak_data | 1 | data | A | 344999 | 200 | NULL | YES | BTREE | | | spak | 1 | spak_fdata | 1 | data | A | 1034998 | 1 | NULL | YES | FULLTEXT | | +-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 4 rows in set (0.04 sec) mysql> select count(*) from spak; +----------+ | count(*) | +----------+ | 1034998 | +----------+ 1 row in set (0.00 sec) Data length in "data" column is rather big; I did myisamchk -r , optimize table, repair table, mysqldump and insert it again, but problem still exists. I read that such error occurs when I insert no unique value to column with unique property. But as you can see I haven't UNIQUE key anywhere. I need help becouse I don't know what to do. Regards. -- Grzegorz Paszka -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
