Type	php
Date	Friday, January 30, 2009 - 12:17am
Location	.../batch?id=35&op=do
Referrer	.../batch?op=start&id=35
Message	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 'WHERE xn.nid IN ( SELECT xn.nid FROM xmlsitemap_node xn LE' at line 2 query: DELETE FROM xmlsitemap_node xn WHERE xn.nid IN ( SELECT xn.nid FROM xmlsitemap_node xn LEFT JOIN node n ON n.nid = xn.nid WHERE n.nid IS NULL ) in .../sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 405.
Severity	error
Hostname	24.16.70.195
Operations	

Type	php
Date	Friday, January 30, 2009 - 12:17am
Location	.../batch?id=35&op=do
Referrer	.../batch?op=start&id=35
Message	Unknown column 'xn.changed' in 'where clause' query: SELECT COUNT(n.nid) FROM node n INNER JOIN xmlsitemap_node xn ON xn.nid = n.nid WHERE n.changed > xn.changed in .../sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 420.
Severity	error
Hostname	24.16.70.195
Operations

Using the latest dev from the 29th, 2nd release of the day.

Comments

ozon’s picture

ozon commented

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 ')' at line 1 query: INSERT INTO tower_xmlsitemap_node (nid, last_changed, priority_override) VALUES (338, 1233360178, ) in /....my secret http_root ;) /sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module in Zeile 125

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

@ozon: That is a different issue that has already its report; see #354453: priority_override doesn't get a value.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: SQL Syntax Error » SQL syntax error
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Active » Closed (duplicate)

I created an issue report that is more generic of this report (see #367158: SQL errors when using the tools page). I am setting this like duplicate of that report.