How to get rid of this warning?

By Muskwa on 2 Feb 2009 at 14:03 UTC

Hello,

I regularly see this warning on my Drupal 6.9 site. Could anybody tell what the problem is?

* user warning: Duplicate entry 'themes/garland/minnelli/minnelli.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('minnelli', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:\"name\";s:8:\"Minnelli\";s:11:\"description\";s:56:\"Tableless, recolorable, multi-column, fixed width theme.\";s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:10:\"base theme\";s:7:\"garland\";s:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:12:\"minnelli.css\";s:36:\"themes/garland/minnelli/minnelli.css\";}}s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";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:7:\"scripts\";a:1:{s:9:\"script.js\";s:33:\"themes/garland/minnelli/script.js\";}s:10:\"screenshot\";s:38:\"themes/garland/minnelli/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";s:6:\"engine\";s:11:\"phptemplate\";}', 'theme', 'themes/garland/minnelli/minnelli.info', 0, 0, 0) in /hosting/www/example.com/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'themes/garland/garland.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('garland', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:7:\"Garland\";s:11:\"description\";s:66:\"Tableless, recolorable, multi-column, fluid width theme (default).\";s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:11:\"stylesheets\";a:2:{s:3:\"all\";a:1:{s:9:\"style.css\";s:24:\"themes/garland/style.css\";}s:5:\"print\";a:1:{s:9:\"print.css\";s:24:\"themes/garland/print.css\";}}s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";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:7:\"scripts\";a:1:{s:9:\"script.js\";s:24:\"themes/garland/script.js\";}s:10:\"screenshot\";s:29:\"themes/garland/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'themes/garland/garland.info', 1, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'themes/pushbutton/pushbutton.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('pushbutton', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:10:\"Pushbutton\";s:11:\"description\";s:52:\"Tabled, multi-column theme in blue and orange tones.\";s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";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:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:9:\"style.css\";s:27:\"themes/pushbutton/style.css\";}}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:27:\"themes/pushbutton/script.js\";}s:10:\"screenshot\";s:32:\"themes/pushbutton/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'themes/pushbutton/pushbutton.info', 0, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'themes/chameleon/marvin/marvin.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('marvin', '', 'a:13:{s:4:\"name\";s:6:\"Marvin\";s:11:\"description\";s:31:\"Boxy tabled theme in all grays.\";s:7:\"regions\";a:2:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";}s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:10:\"base theme\";s:9:\"chameleon\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";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:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:9:\"style.css\";s:33:\"themes/chameleon/marvin/style.css\";}}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:33:\"themes/chameleon/marvin/script.js\";}s:10:\"screenshot\";s:38:\"themes/chameleon/marvin/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'themes/chameleon/marvin/marvin.info', 0, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'themes/chameleon/chameleon.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('chameleon', 'themes/chameleon/chameleon.theme', 'a:12:{s:4:\"name\";s:9:\"Chameleon\";s:11:\"description\";s:42:\"Minimalist tabled theme with light colors.\";s:7:\"regions\";a:2:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";}s:8:\"features\";a:4:{i:0;s:4:\"logo\";i:1;s:7:\"favicon\";i:2;s:4:\"name\";i:3;s:6:\"slogan\";}s:11:\"stylesheets\";a:1:{s:3:\"all\";a:2:{s:9:\"style.css\";s:26:\"themes/chameleon/style.css\";s:10:\"common.css\";s:27:\"themes/chameleon/common.css\";}}s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";s:7:\"scripts\";a:1:{s:9:\"script.js\";s:26:\"themes/chameleon/script.js\";}s:10:\"screenshot\";s:31:\"themes/chameleon/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'themes/chameleon/chameleon.info', 0, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'themes/bluemarine/bluemarine.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('bluemarine', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:10:\"Bluemarine\";s:11:\"description\";s:66:\"Table-based multi-column theme with a marine and ash color scheme.\";s:7:\"version\";s:3:\"6.9\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1231976413\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";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:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:9:\"style.css\";s:27:\"themes/bluemarine/style.css\";}}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:27:\"themes/bluemarine/script.js\";}s:10:\"screenshot\";s:32:\"themes/bluemarine/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'themes/bluemarine/bluemarine.info', 0, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.
* user warning: Duplicate entry 'sites/default/themes/painted/painted.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('painted', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:12:\"Painted Wall\";s:11:\"description\";s:20:\"Like paint on a wall\";s:10:\"screenshot\";s:43:\"sites/default/themes/painted/screenshot.png\";s:7:\"version\";s:7:\"6.x-1.3\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"regions\";a:4:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:11:\"content_top\";s:11:\"Content Top\";s:14:\"content_bottom\";s:14:\"Content Bottom\";}s:8:\"features\";a:9:{i:0;s:4:\"logo\";i:1;s:4:\"name\";i:2;s:6:\"slogan\";i:3;s:7:\"mission\";i:4;s:17:\"node_user_picture\";i:5;s:20:\"comment_user_picture\";i:6;s:7:\"favicon\";i:7;s:13:\"primary_links\";i:8;s:15:\"secondary_links\";}s:11:\"stylesheets\";a:3:{s:3:\"all\";a:1:{s:9:\"style.css\";s:38:\"sites/default/themes/painted/style.css\";}s:6:\"screen\";a:2:{s:12:\"css/tabs.css\";s:41:\"sites/default/themes/painted/css/tabs.css\";s:20:\"css/layout-fixed.css\";s:49:\"sites/default/themes/painted/css/layout-fixed.css\";}s:5:\"print\";a:1:{s:13:\"css/print.css\";s:42:\"sites/default/themes/painted/css/print.css\";}}s:3:\"php\";s:5:\"4.3.3\";s:7:\"project\";s:7:\"painted\";s:9:\"datestamp\";s:10:\"1229194524\";s:7:\"scripts\";a:1:{s:9:\"script.js\";s:38:\"sites/default/themes/painted/script.js\";}}', 'theme', 'sites/default/themes/painted/painted.info', 1, 0, 0) in /hosting/www/example.cz/www/modules/system/system.module on line 821.

Comments

firstly have you ran

timmillwood

English

🏴󠁧󠁢󠁷󠁬󠁳󠁿 Wales, UK

commented 2 February 2009 at 14:23

firstly have you ran update.php?

It looks like a theme error, try changing your theme.

then report back.

----------------------------------------------------------------

Millwood Online http://www.millwoodonline.co.uk
Blog to it http://blog.to.it
Spun Designs http://www.spundesigns.net
IB Community Theme http://communitytheme.ibo.org

Thanks for reply

Muskwa commented 2 February 2009 at 16:14

I have run update.php after update 5.8->5.9, but this error occured few times before update, too. It doesn't appear constantly, just now and then. I will try to change the theme asap (as I find a suitable one) and will report back.

Thank you for your help!

Same problem

sjz commented 8 February 2009 at 20:39

I've been seeing this more and more since the 6.9 upgrade ... It's certainly not a "theme problem" - because the error is being thrown by system.module on the built-in themes as well. So the problem lies elsewhere.

A look at system.module function containing line 821 is:

/**
 * Collect data about all currently available themes.
 *
 * @return
 *   Array of all available themes and their data.
 */
function system_theme_data() {
  // Scan the installation theme .info files and their engines.
  $themes = _system_theme_data();

  // Extract current files from database.
  system_get_files_database($themes, 'theme');

  db_query("DELETE FROM {system} WHERE type = 'theme'");

  foreach ($themes as $theme) {
    if (!isset($theme->owner)) {
      $theme->owner = '';
    }

    db_query("INSERT INTO {system} (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('%s', '%s', '%s', '%s', '%s', %d, %d, %d)", $theme->name, $theme->owner, serialize($theme->info), 'theme', $theme->filename, isset($theme->status) ? $theme->status : 0, 0, 0);
  }

  return $themes;
}

With line 821 being:

 db_query("INSERT INTO {system} (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('%s', '%s', '%s', '%s', '%s', %d, %d, %d)", $theme->name, $theme->owner, serialize($theme->info), 'theme', $theme->filename, isset($theme->status) ? $theme->status : 0, 0, 0);
  }

This means that the line:

  db_query("DELETE FROM {system} WHERE type = 'theme'");

*must* be failing silently or not achieving the desired effect due to some other issue or the subsequent code would work correctly without throwing a "Duplicate Entry" error.

Since there is nothing wrong with the query and it's highly unlikely that it's failing, then it must be a race condition. There are many times in Drupal (esp on a heavily loaded multi-threaded processors) where firing off pages in rapid succession can cause one process to start doing the work that another process is also performing.

I've been able to reproduce the effect by using /index.php?q=admin/reports/status:

Without digging further into the specifics, the scenario probably looks like this

Process A invokes: /index.php?q=admin/reports/status
Process A calls the function system_theme_data
Process B invokes: /index.php?q=admin/reports/status
Process B calls the function system_theme_data
Process A has deleted the "theme" records
Process B also deletes the "theme" records
Process A re-creates all of the "theme" records while Process B is gathering the data to replace them on the database
Process B then attempts to re-create the "theme" records but gets an error because Process A has already succeeded in doing so

This can be avoided if the function were to keep track of its execution state and "block" accordingly during the "delete"/"re-create" phase of execution.

It doesn't appear to so this is probably the cause of the warnings...

In any case - you may safely disregard them.

Can we ignore the warning?

pareen commented 19 February 2009 at 04:10

Hi sjz,

I dont understand any of the technicalities. Are you saying that we can ignore the message without worrying about our databases or files?

Thanks a lot man...

I am getting the same warning...

pareen commented 19 February 2009 at 04:08

At first I got scared. But now it seems to be same problem with many people.

Please someone look into it. I hope its nothing major.

===

farald commented 26 February 2009 at 08:51

Have someone created a bug report for this problem? If yes, please post a link here.

Have lived with this error for six months, using newswire theme. There are no side effects, only a scary page of warnings now and then.

I'm experiencing the same

smithn.nc commented 21 February 2009 at 05:57

I'm experiencing the same issue here. Kinda relieved to hear that it probably isn't serious, but it is a little awkward explaining that to my boss when it shows up. Does anyone have any ideas how to fix it? The first time I saw it was tonight, after enabling a previously hidden menu item for the first time.

I get this message about once

DjC4 commented 1 March 2009 at 23:12

I get this message about once a week to. I cant figure out what causes it to happen, I can never recreate it on purpose.

Well...

asak commented 6 March 2009 at 22:09

This is an interesting one...

Another note on this issue

smithn.nc commented 9 March 2009 at 20:31

I narrowed things down a bit, and I only experienced the problem after enabling the Statistics module. Disabling the module made the issue go away. Can anyone confirm this for their own site?

Not related to statistics for e

basserc999 commented 5 April 2009 at 19:02

Personally, I have the same issue from time to time, with or without the Statistics module enabled.

Subscribing... This group of

Apollo610 commented 8 April 2009 at 22:42

Subscribing...

This group of errors seems to get thrown when cron is running, during UPDATE STATUS's call. This is causing my cron to churn and churn, taking up to more than an hour before finally completing.

Turning off the UPDATE STATUS module fixes the problem for me, but makes checking for module updates more manual and isn't really desired (nor does it actually fix the underlying problem).

Anyone have any ideas on how to fix this?

(You can see where CRON is dying by adding this code to module.inc.

same error. am using Zen.

nirvanajyothi commented 24 April 2009 at 15:54

same error. am using Zen.

subscribing.

Had Same Issue

dyland commented 26 April 2009 at 01:05

Found out my custom theme had uploaded as both mixed case and all lower case. I deleted the all lower case and everything worked fine.

Can you add more details

nirvanajyothi commented 26 April 2009 at 02:16

Can you add more details please.

-thank you

Seeing this error in D6.10 I

skizzo commented 26 April 2009 at 15:56

Seeing this error in D6.10
I have no Statistics and no "case mixups".
please follow-up on http://drupal.org/node/445052

Hi, I have noticed doing one

macrodesign commented 27 May 2009 at 12:45

Hi,

I have noticed doing one Admin task or opening one Admin page at a time doesn't evoke this error, but if we try and open many one after the other, like Log report, Recent hits and users etc, yes it does give this error. But doing it one by one, doesn't

Yea

MGParisi commented 4 June 2009 at 13:19

I seem to get this error if firefox crashes, and when restarting, it loads up all the old tabs. When I am developing I have a few edit blocks windows open and a few views2 tab "list" windows open.

There are a lot of forum

osopolar

German

🇩🇪 GER 🌐

commented 10 June 2009 at 16:55

There are a lot of forum posts to this warning.

I found one bug report issue: #477550: "User warning: Duplicate entry ... " ... Themes. IMHO it will be better for bug tracking if the discussion will be continued there.

Same error. Subscribing, see

vkr11 commented 24 August 2009 at 01:39

Same error. Subscribing, see this with 6.x in admin screens (may be once in 2 weeks)

Getting the same error as

drupaloo-1 commented 1 September 2009 at 02:57

Getting the same error as well.

Subscribing.

Same error

bcobin commented 4 September 2009 at 14:15

Same error using ATCK, which contains a lot of Zen code. Problem is intermittent, but error is visible to anonymous users, which is a bad thing. Subscribing.

Duplicate Themes warning still occurs in 6.17

SiteMaster.ServeLime.com commented 22 July 2010 at 06:21

Anybody got a fix for this yet - still occurs in Drupal6.17

Same issue occuring in 6.19

Pamulapati commented 20 August 2010 at 10:05

Same issue occuring in 6.19.

Subscribing

same error. am using

vodoleq commented 30 August 2010 at 07:21

same error. am using waffles.
error in to modules/system/system.module row 822.

Drupal 6.17

subscribing.

Same error

Yuri commented 16 September 2010 at 06:47

Drupal 6.19

Same error

plan9 commented 13 October 2010 at 10:37

Drupal 5.23

Same error

PI_Ron commented 19 October 2010 at 23:55

Drupal 6.19

http://pastie.org/1234135

I have the same error

fontom commented 26 November 2010 at 04:18

me too I'm having the same error

cron

premier23 commented 21 February 2011 at 23:37

I get these errors with duplicate entries only when I configure the cron jobs to be executed from my hoster.
They are thrown directly after I login.
But when I let an external cronjob service run the cronjob it runs without errors.
Im running Drupal 6.20

Can you please possibly give a link to the specific patch which works for D6 or D7?

Thanks!

both links will lead you to

skizzo commented 13 December 2011 at 14:48

both links will lead you to the following D6 patch:
http://drupal.org/files/issues/drupal-307756-133-D6.patch
However, I do not know whether the patch (dated June 5 2010)
applies cleanly to the current D6 dev version.
The patch was not committed, but later marked as duplicate of
http://drupal.org/node/147000 (itself not committed yet, but
more recent). I have not followed the ensuing discussion...

How to get rid of this warning?

Comments

New forum topics