user warning: You have an error in your SQL syntax

5.x-1.3 is no longer supported. Please try the latest version.

Same problem here. Happens everytime I add a new term to a vocabulary.

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 ')' at line 1 query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (82, NULL, 1209396308, ) in /var/www/html/drupal-5.0/includes/database.mysql.inc on line 172.

seems like 'priority_override' is not being defined/picked up during the insert. The field doesn't even appear on the taxonomy add term forms - like it does on other forms.

This bug is preventing taxonomy terms being stored in totally - rendering the taxonomy system broken in Drupal!

Confirming on this one... I am getting this error message, and I am getting another saying something about duplicate, sorry but i don't have the full message now because i removed the module, and i remember that i got this message right after enabling the module, if it helps, i can re-install the module, and give you the full message.
I am speculating here that it has something to do with multiple url aliases and the pathauto module, I had and still have enabled the option in the pathauto module to leave the old alias working if a new one is created for the same node. If budda or d_hall can confirm that he has the same configuration, maybe we'll have something under our hands.

The only thing I can imagine is that the default priority for your vocabulary is an empty string. See if re-saving your vocabulary fixes it.

Please re-open if you have more information.

I have re-opened this issue and changed the version. I got this message when I added a taxonomy term. The term itself is properly added to the taxonomy.

Changing the weight and resavind does not fix it:

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 'WHERE tid = 23' at line 3 query: UPDATE xmlsitemap_term SET pid = NULL, last_changed = 1219701313, previously_changed = last_changed, priority_override = WHERE tid = 23 in /mnt/web4/40/03/51694503/htdocs/includes/database.mysql.inc on line 172.

Please help.

Just did a de-install and install of the component and everything seems fine now.

@Darren Oh,

You were exactly right, the term priority was not set correctly. It seems that setting the priority value in that query is restricted by the permission "override term priority" and users who do not have that permission get this SQL error when adding new terms.

Jen