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
Comment #1
darren ohComment #2
darren ohPlease 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.
Comment #3
victor@gamedev.by commentedMy table xmlsitemap_term was empty.
I reinstall xmlsitemap module and now all work good.
Sorry to disturb you :)