Duplicate entry errors, system module

There's a concurrency issue, which causes those. It does not affect content - you should still see everything working, but is very annoying, indeed. We are trying to get rid of this.

Thank you

Not sure if this is the same problem. It is somewhat similar message but occurring at different location. displayed next page no problem. PLus expected page came out OK below these errors. Error was in HTML output when accessing. http://beta.example.com/admin/content/feed

    * user warning: Duplicate entry 'sites/all/themes/rootcandy/rootcandy_dark/rootcandy_dark.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('rootcandy_dark', 'themes/engines/phptemplate/phptemplate.engine', 'a:15:{s:4:\"name\";s:14:\"RootCandy Dark\";s:11:\"description\";s:27:\"Administration theme - dark\";s:10:\"screenshot\";s:56:\"sites/all/themes/rootcandy/rootcandy_dark/screenshot.png\";s:10:\"base theme\";s:9:\"rootcandy\";s:6:\"engine\";s:11:\"phptemplate\";s:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:8:\"dark.css\";s:50:\"sites/all/themes/rootcandy/rootcandy_dark/dark.css\";}}s:7:\"regions\";a:7:{s:10:\"admin_left\";s:12:\"Left sidebar\";s:11:\"admin_right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";s:14:\"dashboard_left\";s:14:\"Dashboard Left\";s:15:\"dashboard_right\";s:15:\"Dashboard Right\";}s:4:\"core\";s:3:\"6.x\";s:8:\"settings\";a:8:{s:26:\"rootcandy_navigation_icons\";s:1:\"0\";s:31:\"rootcandy_navigation_icons_size\";s:2:\"24\";s:24:\"rootcandy_header_display\";s:1:\"0\";s:33:\"rootcandy_navigation_custom_icons\";s:0:\"\";s:27:\"rootcandy_dashboard_display\";s:1:\"0\";s:24:\"rootcandy_dashboard_help\";s:4:\"left\";s:28:\"rootcandy_dashboard_messages\";s:5:\"right\";s:35:\"rootcandy_dashboard_content_display\";s:1:\"0\";}s:7:\"version\";s:11:\"6.x-1.0-rc3\";s:7:\"project\";s:9:\"rootcandy\";s:9:\"datestamp\";s:10:\"1224960017\";s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:51:\"sites/all/themes/rootcandy/rootcandy_dark/script.js\";}s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'sites/all/themes/rootcandy/rootcandy_dark/rootcandy_dark.info', 0, 0, 0) in /var/[...]/Beta/httpdocs/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'sites/all/themes/rootcandy/rootcandy.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('rootcandy', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:\"name\";s:9:\"RootCandy\";s:11:\"description\";s:20:\"Administration theme\";s:10:\"screenshot\";s:41:\"sites/all/themes/rootcandy/screenshot.png\";s:6:\"engine\";s:11:\"phptemplate\";s:11:\"stylesheets\";a:3:{s:3:\"all\";a:1:{s:9:\"style.css\";s:36:\"sites/all/themes/rootcandy/style.css\";}s:5:\"print\";a:1:{s:9:\"print.css\";s:36:\"sites/all/themes/rootcandy/print.css\";}s:6:\"screen\";a:1:{s:9:\"icons.css\";s:36:\"sites/all/themes/rootcandy/icons.css\";}}s:7:\"regions\";a:7:{s:10:\"admin_left\";s:12:\"Left sidebar\";s:11:\"admin_right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";s:14:\"dashboard_left\";s:14:\"Dashboard Left\";s:15:\"dashboard_right\";s:15:\"Dashboard Right\";}s:4:\"core\";s:3:\"6.x\";s:8:\"settings\";a:8:{s:26:\"rootcandy_navigation_icons\";s:1:\"0\";s:31:\"rootcandy_navigation_icons_size\";s:2:\"24\";s:24:\"rootcandy_header_display\";s:1:\"0\";s:33:\"rootcandy_navigation_custom_icons\";s:0:\"\";s:27:\"rootcandy_dashboard_display\";s:1:\"0\";s:24:\"rootcandy_dashboard_help\";s:4:\"left\";s:28:\"rootcandy_dashboard_messages\";s:5:\"right\";s:35:\"rootcandy_dashboard_content_display\";s:1:\"0\";}s:7:\"version\";s:11:\"6.x-1.0-rc3\";s:7:\"project\";s:9:\"rootcandy\";s:9:\"datestamp\";s:10:\"1224960017\";s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:36:\"sites/all/themes/rootcandy/script.js\";}s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'sites/all/themes/rootcandy/rootcandy.info', 0, 0, 0) in /var/[...]/Beta/httpdocs/modules/system/system.module on line 822.
    * user warning: Duplicate entry 'sites/all/themes/tattler_theme/tattler_theme.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('tattler_theme', 'themes/engines/phptemplate/phptemplate.engine', 'a:11:{s:4:\"name\";s:7:\"Tattler\";s:11:\"description\";s:22:\"Tattler Default Theme.\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"version\";s:7:\"6.x-1.0\";s:11:\"stylesheets\";a:2:{s:3:\"all\";a:4:{s:9:\"style.css\";s:40:\"sites/all/themes/tattler_theme/style.css\";s:24:\"css/jquery.selectbox.css\";s:55:\"sites/all/themes/tattler_theme/css/jquery.selectbox.css\";s:23:\"css/overlay-minimal.css\";s:54:\"sites/all/themes/tattler_theme/css/overlay-minimal.css\";s:19:\"facebox/facebox.css\";s:50:\"sites/all/themes/tattler_theme/facebox/facebox.css\";}s:5:\"print\";a:1:{s:9:\"print.css\";s:40:\"sites/all/themes/tattler_theme/print.css\";}}s:7:\"scripts\";a:4:{s:22:\"js/jquery.tools.min.js\";s:53:\"sites/all/themes/tattler_theme/js/jquery.tools.min.js\";s:23:\"facebox/facebox.pack.js\";s:54:\"sites/all/themes/tattler_theme/facebox/facebox.pack.js\";s:13:\"js/tattler.js\";s:44:\"sites/all/themes/tattler_theme/js/tattler.js\";s:13:\"js/retweet.js\";s:44:\"sites/all/themes/tattler_theme/js/retweet.js\";}s:7:\"regions\";a:1:{s:13:\"right_sidebar\";s:13:\"Right Sidebar\";}s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:10:\"screenshot\";s:45:\"sites/all/themes/tattler_theme/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'sites/all/themes/tattler_theme/tattler_theme.info', 0, 0, 0) in /var/[...]/Beta/httpdocs/modules/system/system.module on line 822.

having the same problem too

I just came across this issue searching for an error message I have - personally I had it visiting admin/reports/status

Edited error:

duplicate entry 'sites/all/themes/klassik/klassik.info' for key 1 query: INSERT INTO system (HUGE-QUERY) in /var/www/d6/modules/system/system.module on line 822.

BUT I'm not using Tattler. So it's possible this error has little to do with Tattler per se.

Ah, I just found this: http://drupal.org/node/614648

I think this issue is a duplicate. Marking as duplicate and moving to Drupal.

I need coffee. The other issues are support issues. Sigh...

Setting status as active. Making title more generic.

My full error:

duplicate entry 'sites/all/themes/klassik/klassik.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('klassik', 'themes/engines/phptemplate/phptemplate.engine', 'a:12:{s:4:\"name\";s:7:\"klassik\";s:11:\"description\";s:35:\"Custom theme for Klassikmobelkunst.\";s:7:\"version\";s:4:\"6.14\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:11:\"stylesheets\";a:2:{s:17:\"screen,projection\";a:2:{s:23:\"druprint/typography.css\";s:48:\"sites/all/themes/klassik/druprint/typography.css\";s:9:\"style.css\";s:34:\"sites/all/themes/klassik/style.css\";}s:5:\"print\";a:1:{s:18:\"druprint/print.css\";s:43:\"sites/all/themes/klassik/druprint/print.css\";}}s:7:\"scripts\";a:1:{s:18:\"scripts/general.js\";s:43:\"sites/all/themes/klassik/scripts/general.js\";}s:7:\"regions\";a:7:{s:4:\"left\";s:12:\"Left sidebar\";s:12:\"contentright\";s:13:\"Right content\";s:7:\"content\";s:7:\"Content\";s:10:\"contentsub\";s:11:\"Sub content\";s:10:\"contentnav\";s:11:\"Content nav\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";}s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:10:\"screenshot\";s:39:\"sites/all/themes/klassik/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";s:7:\"project\";s:0:\"\";}', 'theme', 'sites/all/themes/klassik/klassik.info', 1, 0, 0) in /var/www/d6/modules/system/system.module on line 822.

Support issues that seem to be duplicates of this issue:
http://drupal.org/node/614648
http://drupal.org/node/602428

Getting the same issue. 6-14

...any updates or progress on this yet?

Upgraded another site from 6.13 to 6.14; afterward, updated modules that required updating, and got this error:

user warning: Duplicate entry 'sites/all/modules/seo_checklist/seochecklist.module' for key 1 query: INSERT INTO system (name, info, type, filename, status, throttle, bootstrap) VALUES ('seochecklist', 'a:10:{s:4:\"name\";s:15:\"\"SEO\" Checklist\";s:11:\"description\";s:52:\"A Search Engine Optimization checklist for Drupal 6.\";s:4:\"core\";s:3:\"6.x\";s:7:\"package\";s:15:\"\"SEO\" Checklist\";s:7:\"version\";s:7:\"6.x-2.0\";s:7:\"project\";s:13:\"seo_checklist\";s:9:\"datestamp\";s:10:\"1249685460\";s:12:\"dependencies\";a:0:{}s:10:\"dependents\";a:0:{}s:3:\"php\";s:5:\"4.3.5\";}', 'module', 'sites/all/modules/seo_checklist/seochecklist.module', 0, 0, 0) in /var/www/vhosts/mysite.com/subdomains/services/httpdocs/drupal/includes/module.inc on line 147.

...related...?

Also having this problem - subscribing.

Also have this error. Very annoying. subscribing

For me solved, as I find out, that there is one theme twice uploaded: once in sites/themes, once in themes. I've deleted one of them, and the message disappears.

Hope helps.

Getting a similar error. Subscribing.

sub'ing. thanks.

sangus & kovel -- I removed all unused themes and unused modules that I'd had, and the theme clean-out seemed to make the difference, similar to what pal_ur suggested.

Try giving that a shot...and good luck. It was a very, very annoying problem.

Same error, on all themes, from CRON. However, other themes are all Drupal standard distribution, so I can't clean out the other themes.

Subscribing.

For my case, same error occurs after I change my default language in admin/settings/language.

When I change back to the original language, the error gone. So my question is how to avoid this errors after changing default language.

+1, subscribing... also noted cron has run at the time of this error

oeps..wrong thread..

+1 subscribing

Running Drupal-6.15 with all modules and themes up to date.

There are only two errors in my drupal logs, this one, and another for a missing bullet.png in a client created theme. If anyone could give me a heads up on how to diagnose this I would sure appreciate it.

My VPS error logs are not showing any errors for that site and time??

Is there a snippet that I could place anywhere that would give me an idea of the sql script that keep trying to run? I assume it's some kind of mysql error because I see the same type of error when re-running an mysql script an already installed script.

Would a module list and site report be helpful?

Same problem as others seem to be describing. Navigation menus appear but links yield no information.

Subscribing, same error with all modules and themes up to date (standard)

subscribe

I am having the same problem, which seems to occur after a cron run. Subscribing.

Same issue here with 6.15 and multiple themes (acquia prosper and rootcandy) ... subscribing ...

Noticed this problem on one of my sites to. Drupal 6.15 Multisite configuration, but only one site active at this moment with one custom theme. Happened after cronjob.

Found a couple of related issues like these ones:
- http://drupal.org/node/307756
- http://drupal.org/node/147000

Quick (and dirty) fix -> http://drupal.org/node/307756#comment-2550872

But better wait for http://drupal.org/node/251792 which will be part of D 6.16.

Subscribing. Same issue with chameleon.info and a custom theme.

This is caused by a race condition. I got around this issue by adding some extra conditions before writing the content to the database.

This is an example I added to the Calais module, in the file opencalais.module

        if($node->is_new && !$node->title && !$node->body) {
//        if($node->is_new) {
          content_insert($node);
        }
        else {
          content_update($node);
        }

It has solved the issue for me. Just reapply the same logic to any module which is causing the issue.

same issue, subscribing

subs

subscribing

Seeing the same message, it's still in there. Race condition sounds like part of it, what I did was, I had added a role and before the post completed I refreshed the roles page. Haven't seen the message but once, though.

Same problem here. Subscribing.

Since this problem did not affect the functionality and occured only when using poormanscron, I did the following.

I installed the curl port for Win32 and nncron. Now nncron is calling curl with c:\xampp\curl-7.21.3\curl.exe --silent --compressed http://127.0.0.1/tattler/cron.php" every ten minutes. No probs at all so far.

subscribing: same error as in comment #2