By cercamon on

I've update to 5.1 and only have a problem when I preview and submit the comment, in this action I have the following message.

user warning: Duplicate entry '42' for key 1 query: INSERT INTO comments (cid, nid, pid, uid, subject, comment, format, hostname, timestamp, status, score, users, thread, name, mail, homepage) VALUES (42, 73, 0, 1, 'asd asdsa das das das das', 'asd asdsa das das das das das das d', 4, '217.148.68.113', 1181565855, 0, 0, 'a:1:{i:0;i:0;}', '01/', 'admin_test', '', '') in /home/content/o/p/i/opina2005/html/test_opina/includes/database.mysql.inc on line 172.

Anyone can help me what can I do to solve this error.

Thanks in advance

⋅ Categories: Drupal 5.x

Comments

cmsproducer’s picture

cmsproducer commented

I ran into the same issue with an upgrade because a field int he database that was meant to auto_increment was not doing so, and that was making it have duplicate fields where values were meant to be unique. Here is http://cmsproducer.com/incompatibility_mysql_database_SQL_import_auto_increment_primary-key_uid_pid" title="Incompatibility in MYSQL 4.1 to 4.0 database SQL import - Lacking auto_increment setting in the primary key">solution that worked for me in solving the Warning: Duplicate entry '0' for key 1 query: INSERT INTO issue

Let me know if you need more input troubleshooting your unique case.

-----
iDonny Productions: Accessibility & Web Standards-based Design & Devt., CMS & Web Branding