I have no idea what this error is.. any suggestions?

•user warning: Unknown column 'changed' in 'field list' query: SELECT tid, changed, previously_changed, priority_override FROM xmlsitemap_term WHERE tid = 25 in /home/xxx/public_html/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 99.
•user warning: Unknown column 'changed' in 'field list' query: UPDATE xmlsitemap_term SET changed = 1248336647 WHERE tid = 0 in /home/marco/public_html/includes/common.inc on line 3422.
•user warning: Unknown column 'changed' in 'field list' query: SELECT tid, changed, previously_changed, priority_override FROM xmlsitemap_term WHERE tid = 24 in /home/xxx/public_html/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 99.
•user warning: Unknown column 'changed' in 'field list' query: UPDATE xmlsitemap_term SET changed = 1248336647 WHERE tid = 0 in /home/marco/public_html/includes/common.inc on line 3422.
•user warning: Unknown column 'changed' in 'field list' query: SELECT tid, changed, previously_changed, priority_override FROM xmlsitemap_term WHERE tid = 26 in /home/xxx/public_html/modules/xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 99.
•user warning: Unknown column 'changed' in 'field list' query: UPDATE xmlsitemap_term SET changed = 1248336647 WHERE tid = 0 in /home/marco/public_html/includes/common.inc on line 3422.

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: I have no idea what this error is » Unknown column 'changed' error

This seems a duplicate of #524742: Unknown column 'xsm.changed' in 'where clause' query.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Category: bug » support

You must have an outdated version of the project files, which is not even version 6.x-1.0-rc1; the latest versions of the files don't even use the table xmlsitemap_term as reported from the error messages you show.

The SQL query you report is executed from the following code:

        $result = db_fetch_object(db_query("SELECT tid, changed, previously_changed, priority_override
          FROM {xmlsitemap_taxonomy}
          WHERE tid = %d", $term->tid));
Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Fixed

You must follow http://drupal.org/node/508262 exactly as described to install this version.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (duplicate)

#524742: Unknown column 'xsm.changed' in 'where clause' query