hi
on cron before i update, new files on the server and activated. i get this red split..

* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_additional WHERE status = 1 in ./xmlsitemap/xmlsitemap/xmlsitemap.module on line 223.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
* user warning: Table 'name.db_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM db_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_additional WHERE status = 1 in ./xmlsitemap/xmlsitemap/xmlsitemap.module on line 223.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
* user warning: Table 'name.db_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM db_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_additional WHERE status = 1 in ./xmlsitemap/xmlsitemap/xmlsitemap.module on line 223.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM db_xmlsitemap_node WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 236.
* user warning: Table 'name.db_xmlsitemap_taxonomy' doesn't exist query: SELECT COUNT(*) FROM db_xmlsitemap_taxonomy WHERE status = 1 AND (priority_override = -2 OR priority_override >= 0) in ./xmlsitemap/xmlsitemap_taxonomy/xmlsitemap_taxonomy.module on line 187.

..after update..no red split on cron

Comments

eule’s picture

eule commented
Title: Unknown column 'status' in 'where clause' » Unknown column 'status' in 'where clause' | no sitemap access

and see thats sitemap.xml is not access able
the file says now that....i dont have many nodes..so i dont know why he is now splittet in 3 files....check the 3 files..no access an IE says

online translated:

The XML page cannot be indicated
The XML input cannot be indicated if Stylesheet XSL is used. Repair the mistake and click then on updating, or repeat the process later.

--------------------------------------------------------------------------------

The final day 'changefreq' does not agree with the start day 'changfreq'. Mistake by the treatment of the resource 'http://www...

weekly
-----------------------^

-----------sitemap.xml------------

<?xml version="1.0" encoding="UTF-8"?>
"

http://www.example.com/sitemap-0.xml


http://www.example.com/sitemap-1.xml


http://www.example.com/sitemap-2.xml

eule’s picture

eule commented

dont know , tahts are 2 issues ..sorry

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: Unknown column 'status' in 'where clause' | no sitemap access » Unknown column 'status' in 'where clause'

Let us keep only one report for each issue report.

avpaderno’s picture

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

I checked the database schema, and the status field is defined; if you see the error before you ran update.php, that is normal; you already copied the files, and hook_cron() could be called before the update functions can actually change the database schema.

I am setting this as fixed, and changing the category to support request.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.