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 'GROUP BY t.tid, t.vid, v.module, xt.last_changed, xt.previously_changed, xt.prio' at line 8 query: SELECT t.tid, t.vid, v.module, xt.last_changed, xt.previously_changed, xt.priority_override FROM term_data t LEFT JOIN vocabulary v ON t.vid = v.vid LEFT JOIN xmlsitemap_term xt ON t.tid = xt.tid WHERE (t.vid NOT IN (0) AND xt.priority_override <> -1 AND t.tid <> 0 GROUP BY t.tid, t.vid, v.module, xt.last_changed, xt.previously_changed, xt.priority_override in /sites/all/modules/xmlsitemap/xmlsitemap_term/xmlsitemap_term.module on line 220.

Resolution is to add in the correct closing bracket (or remove the opening bracket) from line 215:
... WHERE (t.vid NOT IN (". db_placeholders($excludes, 'int') .") ) ...
or
... WHERE t.vid NOT IN (". db_placeholders($excludes, 'int') .") ...

Comments

apaderno’s picture

Title: SQL syntax incorrect » SQL syntax is incorrect
Status: Active » Fixed

This has been fixed in CVS.
Thanks for your report.

apaderno’s picture

Component: xmlsitemap_term » xmlsitemap_term.module
Status: Fixed » Closed (duplicate)

I fixed this issue in a branch that doesn't have any public release, yet.

I am setting this report as a duplicate of #354453: priority_override doesn't get a value, which has been created to avoid multiple issue reports.