5.x-2.x-dev - 2008-Jun-15

when i am post a new node or update i toke this error

user warning: Unknown column 'tags' in 'where clause' query: UPDATE xmlsitemap_term SET previously_changed = last_changed, last_changed = 1213630361 WHERE tid IN(tags, 5, 16, 18) in /home/nsyllnet/public_html/includes/database.mysql.inc on line 172.

Comments

Andygong’s picture

Andygong commented

Hi kyaons, I met the sql error too:
user warning: Unknown column 'tags' in 'where clause' query: UPDATE xmlsitemap_term SET previously_changed = last_changed, last_changed = 1213775089 WHERE tid IN(tags, 8, 11, 221, 366, 493) in D:\www04\mychinatournew\mychinatour\includes\database.mysql.inc on line 172.

outerspace-z’s picture

outerspace-z commented

I have been getting the following error:

user warning: Column 'pid' cannot be null query: INSERT INTO mit_xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (64, NULL, 1213759576, NULL) in /home/mitrazco/public_html/sites/all/modules/xmlsitemap/xmlsitemap_term/xmlsitemap_term.module on line 207.

Tried uninstalling and reinstalling. Check complete configurations. Looks okay.

Goose4all’s picture

Goose4all commented

i get the same "tags-error"...

any help is highly appreciated!

thanks
Andreas

scoutladen’s picture

scoutladen commented

same problem...

scoutladen’s picture

scoutladen commented

adding the column "tags" to "xmlsitemap_term" seams to work...

momper’s picture

momper commented

same problem ...

plantucha’s picture

plantucha commented

same problem

momper’s picture

momper commented
Priority: Normal » Critical

since june this (now critical) bug isn't fixed????

greetings momper

plantucha’s picture

plantucha commented

as is in comment #5 scoutladen

adding the column "tags" to "xmlsitemap_term" seams to work...

you just have to do it in phpmyadmin or webmin

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: sql error: xmlsitemap_term » SQL error: xmlsitemap_term
Status: Active » Closed (duplicate)

Setting this like duplicate of #279403: Unknown column 'tags' in 'where' clause.