I got the following error when submit a page:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node n LEFT JOIN url_alias ua ON ua.src = CONCAT('node/', 24) ' at line 3 query: INSERT INTO xmlsitemap_node (nid, pid, last_changed, priority_override) SELECT 24, ua.pid, 1195528065, FROM node n LEFT JOIN url_alias ua ON ua.src = CONCAT('node/', 24) LIMIT 0, 1 in /xxx/includes/database.mysql.inc on line 172.

MySQL version: 5.0.37
allthingsvoted.com

Thanks in advance

Comments

xjs’s picture

xjs commented

if disable xmlsitemap_node, the error is gone. Is it really important to have this component?

http://allthingsvoted.com

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Active » Closed (duplicate)

Duplicate of issue 191723. If you want nodes in your site map, you need xmlsitemap_node. This problem has been fixed.