Grzegorz Paszka <[EMAIL PROTECTED]> wrote: > 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. >
Please, upload gzipped dump and insert query to the ftp://support.mysql.com/pub/mysql/Incoming and let me know a filename. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
