after run cron or update node/comment, i see this message:

user warning: Duplicate entry '1' for key 1 query: xmlsitemap_term_cron INSERT INTO xmlsitemap_term (tid, last_changed, pid) SELECT td.tid, 1195256119, ua.pid FROM term_data td LEFT JOIN url_alias ua ON ua.src = CONCAT('taxonomy/term/', td.tid) OR ua.src = CONCAT('forum/', td.tid) LEFT JOIN xmlsitemap_term xt ON xt.tid = td.tid WHERE xt.tid IS NULL in \includes\database.mysql.inc on line 172.

===================================
= devel log
===================================

trigger_error

\includes\database.mysql.inc: 172

Duplicate entry '1' for key 1 query: xmlsitemap_term_cron INSERT INTO xmlsitemap_term (tid, last_changed, pid) SELECT td.tid, 1195256119, ua.pid FROM term_data td LEFT JOIN url_alias ua ON ua.src = CONCAT('taxonomy/term/', td.tid) OR ua.src = CONCAT('forum/', td.tid) LEFT JOIN xmlsitemap_term xt ON xt.tid = td.tid WHERE xt.tid IS NULL , 512

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

_db_query

\includes\database.inc: 200

INSERT INTO xmlsitemap_term (tid, last_changed, pid) SELECT td.tid, 1195256119, ua.pid FROM term_data td LEFT JOIN url_alias ua ON ua.src = CONCAT('taxonomy/term/', td.tid) OR ua.src = CONCAT('forum/', td.tid) LEFT JOIN xmlsitemap_term xt ON xt.tid = td.tid WHERE xt.tid IS NULL

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

db_query

\sites\all\modules\xmlsitemap\xmlsitemap_term\xmlsitemap_term.module: 239

INSERT INTO {xmlsitemap_term} (tid, last_changed, pid) SELECT td.tid, %d, ua.pid FROM {term_data} td LEFT JOIN {url_alias} ua ON ua.src = CONCAT('taxonomy/term/', td.tid) OR ua.src = CONCAT('forum/', td.tid) LEFT JOIN {xmlsitemap_term} xt ON xt.tid = td.tid WHERE xt.tid IS NULL , 1195256119

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

xmlsitemap_term_cron

call_user_func_array

\includes\module.inc: 406

xmlsitemap_term_cron,

Array
(
)

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

Comments

darren oh’s picture

Version: 5.x-1.x-dev » 5.x-1.2
darren oh’s picture

Status: Active » Postponed (maintainer needs more info)

Please report the result of the following query:

SELECT td.tid FROM term_data td
LEFT JOIN xmlsitemap_term xt ON xt.tid = td.tid
WHERE xt.tid IS NULL

Contact me directly if you need help doing this.

victor@gamedev.by’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

My table xmlsitemap_term was empty.

I reinstall xmlsitemap module and now all work good.

Sorry to disturb you :)