While cron has run I saw this error logged.

Duplicate entry '1005-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1005, 'taxonomy_term', '1', 'taxonomy/term/1005', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc in Line 137.

Files: 
CommentFileSizeAuthor
#24 modules.txt14.43 KBtrinsic

Comments

hass’s picture

Ups, I have hundreds of this errors...

hass’s picture

This is a small part of warnings:

    * user warning: Duplicate entry '1104-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1104, 'taxonomy_term', '1', 'taxonomy/term/1104', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1103-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1103, 'taxonomy_term', '1', 'taxonomy/term/1103', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1102-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1102, 'taxonomy_term', '1', 'taxonomy/term/1102', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1101-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1101, 'taxonomy_term', '1', 'taxonomy/term/1101', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1100-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1100, 'taxonomy_term', '1', 'taxonomy/term/1100', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1099-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1099, 'taxonomy_term', '1', 'taxonomy/term/1099', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1098-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1098, 'taxonomy_term', '1', 'taxonomy/term/1098', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1097-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1097, 'taxonomy_term', '1', 'taxonomy/term/1097', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1096-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1096, 'taxonomy_term', '1', 'taxonomy/term/1096', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1095-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1095, 'taxonomy_term', '1', 'taxonomy/term/1095', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1094-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1094, 'taxonomy_term', '1', 'taxonomy/term/1094', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1093-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1093, 'taxonomy_term', '1', 'taxonomy/term/1093', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1092-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1092, 'taxonomy_term', '1', 'taxonomy/term/1092', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1091-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1091, 'taxonomy_term', '1', 'taxonomy/term/1091', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1090-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1090, 'taxonomy_term', '1', 'taxonomy/term/1090', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1089-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1089, 'taxonomy_term', '1', 'taxonomy/term/1089', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1088-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1088, 'taxonomy_term', '1', 'taxonomy/term/1088', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1087-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1087, 'taxonomy_term', '1', 'taxonomy/term/1087', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1086-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1086, 'taxonomy_term', '1', 'taxonomy/term/1086', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1085-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1085, 'taxonomy_term', '1', 'taxonomy/term/1085', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1084-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1084, 'taxonomy_term', '1', 'taxonomy/term/1084', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1083-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1083, 'taxonomy_term', '1', 'taxonomy/term/1083', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1082-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1082, 'taxonomy_term', '1', 'taxonomy/term/1082', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1081-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1081, 'taxonomy_term', '1', 'taxonomy/term/1081', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1080-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1080, 'taxonomy_term', '1', 'taxonomy/term/1080', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1079-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1079, 'taxonomy_term', '1', 'taxonomy/term/1079', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1078-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1078, 'taxonomy_term', '1', 'taxonomy/term/1078', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1077-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1077, 'taxonomy_term', '1', 'taxonomy/term/1077', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1076-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1076, 'taxonomy_term', '1', 'taxonomy/term/1076', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1075-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1075, 'taxonomy_term', '1', 'taxonomy/term/1075', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1074-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1074, 'taxonomy_term', '1', 'taxonomy/term/1074', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1073-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1073, 'taxonomy_term', '1', 'taxonomy/term/1073', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1072-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1072, 'taxonomy_term', '1', 'taxonomy/term/1072', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1071-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1071, 'taxonomy_term', '1', 'taxonomy/term/1071', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1070-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1070, 'taxonomy_term', '1', 'taxonomy/term/1070', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1069-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1069, 'taxonomy_term', '1', 'taxonomy/term/1069', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1068-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1068, 'taxonomy_term', '1', 'taxonomy/term/1068', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1067-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1067, 'taxonomy_term', '1', 'taxonomy/term/1067', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1066-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1066, 'taxonomy_term', '1', 'taxonomy/term/1066', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1065-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1065, 'taxonomy_term', '1', 'taxonomy/term/1065', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1064-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1064, 'taxonomy_term', '1', 'taxonomy/term/1064', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1063-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1063, 'taxonomy_term', '1', 'taxonomy/term/1063', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1062-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1062, 'taxonomy_term', '1', 'taxonomy/term/1062', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1061-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1061, 'taxonomy_term', '1', 'taxonomy/term/1061', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1060-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1060, 'taxonomy_term', '1', 'taxonomy/term/1060', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
    * user warning: Duplicate entry '1059-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1059, 'taxonomy_term', '1', 'taxonomy/term/1059', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.
Dave Reid’s picture

Status: Active » Postponed (maintainer needs more info)

Can you add a debugging or debug_backtrace() before that line to see who's creating/calling/responsible for those duplicate links?

Vuds’s picture

I have this problem also... My taxonomy has more than 10,000 terms (8 thousand in just one vocabulary).

What is this function that you mention? Is it in Devel?

Thanks for attention!

hass’s picture

Also, no idea what I should do.

enli’s picture

subscribing

WildBill’s picture

I'm also seeing this error...

Dave Reid’s picture

What kind of taxonomy-related modules does everyone have enabled? Maybe we can find the culprit somewhere as I don't get this problem with just XML sitemap + Drupal core.

Dave Reid’s picture

Also record any actions/triggers/rules working on taxonomy terms

hass’s picture

The only modules I can currently think of that extend taxonomy specific functionalities on my site are taxonomy_breadcrumb, taxonomy_menu, taxonomy_title, term_fields... no actions, triggers or rules.

If it's a module I would guess taxonomy_menu could be a cause. I have a ~1200 terms menu based on taxonomy_menu. But I have not seen this issues with the previous alpha versions and have not updated taxonomy_menu!

WildBill’s picture

I'm just using the Taxonomy Manager module and Calais. No rules or triggers that are specifically about taxonomy.

But.... the issue has mysteriously disappeared for me. I saw HUNDREDS of these errors at one point, all at the same timestamp. Now they're gone (not occurring anymore). I haven't changed anything. Weird.

hass’s picture

I think you need to uninstall and reinstall or upgrade from earlier versions to see this happens again...

WildBill’s picture

Well if it only happens once, then I'm not really that concerned about it.

hass’s picture

If something has failed and is now cluttered and defective it should affect something... Maybe you haven't seen it yet.

earnie’s picture

I know that autotag module does the wrong thing with taxonomy within the node object that causes this type of issue. See #361509: Duplicate entry for taxonomy SQL query for the issue.

hass’s picture

I do not have autotag installed. Never heard about it yet...

earnie’s picture

I do not have autotag installed. Never heard about it yet...

Maybe not but the comments in the issue point you to the problem caused by the module and how to resolve the issue. I even posted a patch for the autotag module that was ignored.

earnie’s picture

To be clear, see the description at comment #361509-16: Duplicate entry for taxonomy SQL query. I go into detail of the issue with both an array of tids and objects of term data set in the data passed to taxonomy_node_save.

hass’s picture

Got the error again when saving a term. We only added a description to an existing term and saved the term.

Duplicate entry '1057-taxonomy_ter' for key 1 query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (1057, 'taxonomy_term', '1', 'taxonomy/term/1057', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in /srv/www/example.com/html/sites/all/modules/xmlsitemap/xmlsitemap.inc in Zeile 137.

Sum up - this is NOT a one time issue. Only as note - I'm using taxonomy menu 2.4 rc1 as newer versions are really broken.

hass’s picture

I've taken a look into the xmlsitemap table and now I have many duplicates per ID... or it looks so.

551, 'taxonomy', '1', 'taxonomy/term/551', '', 1, 1, 0, 0, 0.5, 0, 0, 0
551, 'taxonomy_ter', '1', 'taxonomy/term/551', '', 1, 1, 0, 0, 0.5, 0, 0, 0
552, 'node', 'ferienhaus', 'node/552', 'de', 1, 1, 0, 1274946920, 0.5, 0, 0, 0
552, 'taxonomy', '1', 'taxonomy/term/552', '', 1, 1, 0, 0, 0.5, 0, 0, 0
552, 'taxonomy_ter', '1', 'taxonomy/term/552', '', 1, 1, 0, 0, 0.5, 0, 0, 0
553, 'node', 'ferienhaus', 'node/553', 'de', 1, 1, 0, 1274946920, 0.5, 0, 0, 0
553, 'taxonomy', '1', 'taxonomy/term/553', '', 1, 1, 0, 0, 0.5, 0, 0, 0
553, 'taxonomy_ter', '1', 'taxonomy/term/553', '', 1, 1, 0, 0, 0.5, 0, 0, 0
554, 'node', 'ferienwohnung', 'node/554', 'de', 1, 1, 0, 1274946948, 0.5, 0, 0, 0
554, 'taxonomy', '1', 'taxonomy/term/554', '', 1, 1, 0, 0, 0.5, 0, 0, 0
554, 'taxonomy_ter', '1', 'taxonomy/term/554', '', 1, 1, 0, 0, 0.5, 0, 0, 0
555, 'node', 'ferienwohnung', 'node/555', 'de', 1, 1, 0, 1274946960, 0.5, 0, 0, 0
555, 'taxonomy', '1', 'taxonomy/term/555', '', 1, 1, 0, 0, 0.5, 0, 0, 0
555, 'taxonomy_ter', '1', 'taxonomy/term/555', '', 1, 1, 0, 0, 0.5, 0, 0, 0
556, 'node', 'ferienwohnung', 'node/556', 'de', 1, 1, 0, 1274946950, 0.5, 0, 0, 0
556, 'taxonomy', '1', 'taxonomy/term/556', '', 1, 1, 0, 0, 0.5, 0, 0, 0
556, 'taxonomy_ter', '1', 'taxonomy/term/556', '', 1, 1, 0, 0, 0.5, 0, 0, 0
557, 'node', 'ferienhaus', 'node/557', 'de', 1, 1, 0, 1274946952, 0.5, 0, 0, 0
557, 'taxonomy', '1', 'taxonomy/term/557', '', 1, 1, 0, 0, 0.5, 0, 0, 0
557, 'taxonomy_ter', '1', 'taxonomy/term/557', '', 1, 1, 0, 0, 0.5, 0, 0, 0
558, 'node', 'ferienwohnung', 'node/558', 'de', 1, 1, 0, 1274946953, 0.5, 0, 0, 0
hass’s picture

Only as a side note - uninstalling xmlsitemap taxonomy does not remove the taxonomy entries from the xmlsitemap table.

hass’s picture

I have uninstalled taxonomy and done a full rebuild - but the below entries are still in the tables.

1, 'node', 'ferienwohnung', 'node/1', 'de', 1, 1, 0, 1274946540, 0.5, 0, 0, 0
1, 'taxonomy', '1', 'taxonomy/term/1', '', 1, 1, 0, 0, 0.5, 0, 0, 0
1, 'taxonomy_ter', '1', 'taxonomy/term/1', '', 1, 1, 0, 0, 0.5, 0, 0, 0
2, 'node', 'ferienwohnung', 'node/2', 'de', 1, 1, 0, 1274946556, 0.5, 0, 0, 0
2, 'taxonomy', '1', 'taxonomy/term/2', '', 1, 1, 0, 0, 0.5, 0, 0, 0
3, 'node', 'ferienwohnung', 'node/3', 'de', 1, 1, 0, 1274946556, 0.5, 0, 0, 0
3, 'taxonomy', '1', 'taxonomy/term/3', '', 1, 1, 0, 0, 0.5, 0, 0, 0
3, 'taxonomy_ter', '1', 'taxonomy/term/3', '', 1, 1, 0, 0, 0.5, 0, 0, 0
4, 'node', 'ferienwohnung', 'node/4', 'de', 1, 1, 0, 1274946541, 0.5, 0, 0, 0
4, 'taxonomy', '1', 'taxonomy/term/4', '', 1, 1, 0, 0, 0.5, 0, 0, 0
4, 'taxonomy_ter', '1', 'taxonomy/term/4', '', 1, 1, 0, 0, 0.5, 0, 0, 0
5, 'node', 'ferienwohnung', 'node/5', 'de', 1, 1, 0, 1274946541, 0.5, 0, 0, 0
5, 'taxonomy', '1', 'taxonomy/term/5', '', 1, 1, 0, 0, 0.5, 0, 0, 0
5, 'taxonomy_ter', '1', 'taxonomy/term/5', '', 1, 1, 0, 0, 0.5, 0, 0, 0
6, 'node', 'ferienwohnung', 'node/6', 'de', 1, 1, 0, 1274946557, 0.5, 0, 0, 0
6, 'taxonomy', '1', 'taxonomy/term/6', '', 1, 1, 0, 0, 0.5, 0, 0, 0
6, 'taxonomy_ter', '1', 'taxonomy/term/6', '', 1, 1, 0, 0, 0.5, 0, 0, 0
7, 'node', 'ferienwohnung', 'node/7', 'de', 1, 1, 0, 1274946558, 0.5, 0, 0, 0
7, 'taxonomy', '1', 'taxonomy/term/7', '', 1, 1, 0, 0, 0.5, 0, 0, 0
7, 'taxonomy_ter', '1', 'taxonomy/term/7', '', 1, 1, 0, 0, 0.5, 0, 0, 0
8, 'node', 'ferienwohnung', 'node/8', 'de', 1, 1, 0, 1274946558, 0.5, 0, 0, 0
8, 'taxonomy', '1', 'taxonomy/term/8', '', 1, 1, 0, 0, 0.5, 0, 0, 0
8, 'taxonomy_ter', '1', 'taxonomy/term/8', '', 1, 1, 0, 0, 0.5, 0, 0, 0
9, 'node', 'ferienwohnung', 'node/9', 'de', 1, 1, 0, 1274946559, 0.5, 0, 0, 0
9, 'taxonomy', '1', 'taxonomy/term/9', '', 1, 1, 0, 0, 0.5, 0, 0, 0
9, 'taxonomy_ter', '1', 'taxonomy/term/9', '', 1, 1, 0, 0, 0.5, 0, 0, 0
trinsic’s picture

FileSize
14.43 KB

Im getting the same error when I try to enable xml sitemap for taxonomy terms:

# user warning: Duplicate entry '206-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (206, 'taxonomy_term', '16', 'taxonomy/term/206', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in /home/trinsical/scottlarsonconsulting.com/modules/xmlsitemap/xmlsitemap.inc on line 137.
# user warning: Duplicate entry '205-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (205, 'taxonomy_term', '16', 'taxonomy/term/205', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in /home/trinsical/scottlarsonconsulting.com/modules/xmlsitemap/xmlsitemap.inc on line 137.
# user warning: Duplicate entry '204-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (204, 'taxonomy_term', '16', 'taxonomy/term/204', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in /home/trinsical/scottlarsonconsulting.com/modules/xmlsitemap/xmlsitemap.inc on line 137.
# user warning: Duplicate entry '203-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (203, 'taxonomy_term', '16', 'taxonomy/term/203', '', 1, 1, 0, 0, 0.5, 0, 0, 0) in /home/trinsical/scottlarsonconsulting.com/modules/xmlsitemap/xmlsitemap.inc on line 137.

Also I noted in the settings that its not actually indexing any terms into the sitemap because of the error:
A list of enabled modules is attached:

sp_key’s picture

The problem affects me as well.
Happens every time I run Cron or update taxonomy terms.

Dave Reid’s picture

Can someone lookup their databases schema definition for the {xmlsitemap}.type column and also the primary key on {xmlsitemap} ?

Danny Englander’s picture

Subscribing

sp_key’s picture

Hi Dave,

I'm happy to do this for you but can you please elaborate a bit?
What kind of information do you need and can you please help me with the query syntax?

hass’s picture

Priority: Normal » Major
Dave Reid’s picture

Category: bug » support
Priority: Major » Normal

I'm not sure how to make it a query. I use visual db editors to see the schemas.

Moving this to a support request since I can't still reproduce and we haven't found out what's at fault yet.

hass’s picture

Category: support » bug
Priority: Normal » Major

This IS a bug and many have it... and really annoying and critical nevertheless you cannot repro yourself.

Dave Reid’s picture

Category: bug » support
Priority: Major » Normal

Please don't change the meta information again until #30 is addressed. I'm aware multiple people are having this problem, but it's not something I have been able to reproduce on a clean core install.

Dave Reid’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)
sp_key’s picture

So can someone have a look as requested in #26?

I don't know how to do what Dave is asking

talatnat’s picture

Status: Closed (cannot reproduce) » Active

I am re-opening this issue because I am also getting this error. Per Dave's request at #26, Schema module reports the following mismatch for xmlsitemap:

column type - difference on: length
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '12', 'not null' => TRUE, 'default' => '')
column subtype - differences on: not null, length, default
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '32', 'not null' => FALSE)
menu_name: unexpected column in database
indexes menu_name: unexpected (not an error)

The primary key is:
Keyname (BTREE), Type (PRIMARY), Unique (Yes), Packed (No), Field (id, type), Cardinality (0, 26751), Collation (A, A)

FYI, the user warning I get is:
user warning: Duplicate entry '461-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (461, 'taxonomy_term', '53', 'taxonomy/term/461', '', 1, 0, 0, 0, 0.5, 0, 0, 0) in /media/data/3-www/dr620test/sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.

I am using xmlsitemap version 6.x-2.0-beta1, and have xmlsitemap taxonomy turned on. I just want to check whether I should manually correct the varchar lengths and the 'not null' setting to TRUE -- don't want to create any other problems here since I don't know what these changes will affect. Also, any hints on where the menu_name column and indexes menu_name came from -- is it from xmlsitemap menu (which I don't have turned on), and is it OK to delete these columns?

Thanks.

talatnat’s picture

I went ahead and made the changes to the column type and subtype, and the Duplicate entry warnings died. So, in my case, it just seems to be a case of database mismatch. I also upgraded to beta-2 and the changes I made are still in place. You can close this issue, thanks.

earnie’s picture

Status: Active » Closed (fixed)

I think the manual intervention for this case is the only solution to the issue.

rsmylski’s picture

I realize this has been closed for a little while now, but for people who can't manually modify their DB, why not add a new update to the install to ensure type and subtype are using the correct field definitions. If your field definition is correct, you won't lose data. But if the definitions aren't correct, it will make them correct and stop the errors.

Adding the following to the install file would do it:
function xmlsitemap_update_6205() {
$ret = array();
db_change_field($ret, 'sitemap', 'type', 'type', array(
'description' => 'Primary key with id; the type of item (e.g. node, user, etc.).',
'type' => 'varchar',
'length' => 32,
'not null' => TRUE,
'default' => ''
));
db_change_field($ret, 'sitemap', 'subtype', 'subtype', array(
'description' => 'A sub-type identifier for the link (node type, menu name, term VID, etc.).',
'type' => 'varchar',
'length' => 128,
'not null' => TRUE,
'default' => ''
));
}