Unknown column 'tags' in 'where' clause

Yes I am getting this too. I tried wiping out my xmlsitemap_term table, and reinstalling that (sub)module via devel. Doesn't help - maybe you have to reinstall the full module? That doesn't quite seem to work either.

Same here, Why nobody is replying ? I think its a bug and needs a FIX.

same problem ...

greetings momper

even same problem... any answer?

any idea?

it's critical ...

Seems the module is abandoned.

adding the column "tags" to "xmlsitemap_term" work for me...

HOW?

with phpmyadmin

I had the same problem as well and spent some time sifting through the xmlsitemap_term module to see if this was a versioning issue with the database structure.. I couldn't see any reference to this and I'm not sure how it inter-relates yet but I tried scoutladen's suggestion and it seems to be back up and running after I ran the following alter command on my table:

alter table xmlsitemap_term add column tags varchar(255);

The type declaration of varchar(255) is arbitrary -- not sure what we should be using here..

Same problem.

Will try the "add your own table" solution ;)

I am not sure this is the solution to the problem. It can be the module created a wrong SQL query, and that tags should be repleaced with $tags (i.e.).
I think this issue needs to be investigated more.

The values that in a SQL query are placed in IN() are not column names, but values (strings, or numbers) that must be compared with the content of a column.
In this case, the SQL query select all the rows where the column tid contains or '4', or 'tags'. The problem is that the code doesn't surround the string with the apices.

This is caused by one of the following SQL queries:

  db_query("UPDATE {xmlsitemap_term} SET previously_changed = last_changed, last_changed = %d WHERE tid IN(". implode(', ', array_keys($node->taxonomy)) .")", $node->created);
  
  db_query("UPDATE {xmlsitemap_term} SET previously_changed = last_changed, last_changed = %d WHERE tid IN(". implode(', ', $terms) .")", $node->changed);
  
  db_query("UPDATE {xmlsitemap_term} SET previously_changed = last_changed, last_changed = %d WHERE tid IN(". implode(', ', array_keys($node->taxonomy)) .")", time());

Adding a tags column in the module sitemap avoids the error message, but doesn't make the module work as it should.

I am changing the code to resolve this issue. Basically, I will backport a couple of helper functions that help in creating query like those without to forget to surround the strings with apices.

It has been fixed.

I forgot to change the status.