fix duplicate key errors
any time a feed is updated, i see these messages:
user warning: Duplicate entry '149-0' for key 1 query: INSERT INTO content_field_images_m (vid, nid, delta, field_images_m_value) VALUES (149, 149, 0, NULL) in /Users/bjd/Sites/tattler/sites/all/modules/cck/content.module on line 1213.
3 comments
-
abdullah ali
commented
pullman
-
nelsonic
commented
Standard LAMP Stack (Ubuntu + PHP 5.2 + MySQL 5.0 + Drupal 6.15)
Same error..."user warning: Duplicate entry '283-0' for key 'PRIMARY' query: INSERT INTO content_field_images_m (vid, nid, delta, field_images_m_value) VALUES (283, 283, 0, NULL) in /var/www/beta/sites/all/modules/cck/content.module on line 1213."
worse still it gives Ugly errors to Un-Athenticated users! :-(
E.g:
"user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) GROUP BY nid, node_title, node_revisions_teaser, node_revisions_format, node' at line 35 query: SELECT COUNT(*) FROM (SELECT node.nid AS nid"
Screen shots on file if required...
Let us know how we can help Fix this...
Thanks again. -
Tim J Kirby
commented
Mac OSX with WAMP:
user warning: Duplicate entry '335-0' for key 'PRIMARY' query: INSERT INTO content_field_images_m (vid, nid, delta, field_images_m_value) VALUES (335, 335, 0, NULL) in /Applications/MAMP/htdocs/tattler/sites/all/modules/cck/content.module on line 1213.