After updating to the recent dev version I got the following error when running update.php

Can't DROP 'pid'; check that column/key exists query: ALTER TABLE xmlsitemap_node DROP pid in /dir/site.com/public/includes/database.mysql.inc on line 174.

This then resulted in the following error when trying to view sitemap.xml

Fatal error: Call to undefined function _xmlsitemap_user_priority() in /dir/site.com/public/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.module on line 185

Comments

droople’s picture

droople commented

I can confirm this as well

xmlsitemap_node module
Update #5

    * Failed: ALTER TABLE {xmlsitemap_node} DROP pid
    * UPDATE DRUPAL MENUS
avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: 01/07 xmlsitemap dev fails to update and causes user sitemap failures » Undefined function
Status: Active » Fixed

The first error doesn't cause the second error.

The first error is caused by a database field not existing, and it's not a critical error; I changed the update function to not raise an error message in such cases.
The second error is caused by a function that has been removed from the code, but it is still being called.

Both the issues have been fixed in CVS.
Thanks for the report.

Chad_Dupuis’s picture

Chad_Dupuis commented
Status: Fixed » Active

I tried the latest dev updates and it applied without error (i.e. update.php did not cause problems). Yet, upon re-activating the xml user module, I still get the following when viewing sitemap.xml

Fatal error: Call to undefined function _xmlsitemap_user_priority() in /dir/site.com/public/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.module on line 185
avpaderno’s picture

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

You must wait until midnight GMT time, before Drupal creates a new archive from the last commits made for a development snapshot.
In such cases, the archive is generated at 12:00 AM, and 12:00 PM GMT.

Chad_Dupuis’s picture

Chad_Dupuis commented

Yes, must have got the older version. All is well now. Thanks for the quick fix!!

Status: Fixed » Closed (fixed)

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