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
Comment #1
apadernoThis has been fixed in CVS.
Thanks for your report.
Comment #2
apadernoI 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.