Not closed parenthesis in SQL query [#355149]

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 &#039;GROUP BY t.tid, t.vid, v.module, xt.last_changed, xt.previously_changed, xt.prio&#039; 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.language =&#039;it&#039; OR t.language =&#039;&#039; OR t.language IS NULL) AND ( (t.vid NOT IN (0) AND xt.priority_override &lt;&gt; -1 AND t.tid &lt;&gt; 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.

There's an open parenthesis on line 215 that is not closed.

Comment	File	Size	Author
#4	xmlsitemap_term-DRUPAL-6--1.patch	938 bytes	Anonymous (not verified)

Comments

Comment #1

stefano73 commented 7 January 2009 at 19:27

One more error, on node insert. The last value is missing.

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 xmlsitemap_term (tid, last_changed, priority_override) VALUES (51, 1231353633, ) in /sites/all/modules/xmlsitemap/xmlsitemap_term/xmlsitemap_term.module on line 167.