I installed 6.x-2.0-beta2 over 6.x-1.2 and update php created an error:

user warning: Unknown column 'max_filesize' in 'field list' query: INSERT INTO xmlsitemap_sitemap (smid, context, updated, links, chunks, max_filesize) VALUES ('NXh.....random-code?.......ZwOM', 'a:0:{}', 0, 0, 0, 0) in /home/public_html/drupal-6/includes/common.inc on line 3538.

After deleting the old xmlsitemap file, a cron run and add the new xmlsitemap by hand, it looks like it works. There are no more errors after the update.

Comments

hswong3i’s picture

hswong3i CreditAttribution: hswong3i commented

Usually this cause by the existing of legacy file which already removed within newer version. Existing Drupal 6.x module installation procedure will not able to detect it (but seems D7 solve this within .info file).

Therefore in case of D6 module upgrade, always REMOVE the entire legacy module folder and replace it with the completely new version. Also flush cache + run cron + access admin/build/module are always a good idea to fix the module upgrade issue :D

mandreato’s picture

mandreato CreditAttribution: mandreato commented

I have a lot of errors here after update to 6.x-2.0-beta2:

warning: XMLWriter::openUri() [xmlwriter.openuri]: Unable to resolve file path in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 37.
user notice: Could not open file sites/default/files/xmlsitemap/g3XYqcXbSKPVBDODwnT6pq7oqhCFkPryj4vVqrl_Kfc/1.xml for writing. in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 39.
warning: XMLWriter::setIndent() [xmlwriter.setindent]: Invalid or unitialized XMLWriter object in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 45.
warning: XMLWriter::startDocument() [xmlwriter.startdocument]: Invalid or unitialized XMLWriter object in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 46.
warning: XMLWriter::writePi() [xmlwriter.writepi]: Invalid or unitialized XMLWriter object in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 57.
warning: XMLWriter::writeRaw() [xmlwriter.writeraw]: Invalid or unitialized XMLWriter object in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 177.
warning: XMLWriter::startElement() [xmlwriter.startelement]: Invalid or unitialized XMLWriter object in ...\sites\all\modules\xmlsitemap\xmlsitemap.xmlsitemap.inc on line 78.

Tried to flush all cache, delete ...\sites\default\files\xmlsitemap subdirs, etc. But these errors present during cron or rebuild links.

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

Therefore in case of D6 module upgrade, always REMOVE the entire legacy module folder and replace it with the completely new version. Also flush cache + run cron + access admin/build/module are always a good idea to fix the module upgrade issue :D

This is true regardless of the module and regardless of the Drupal version. Good practice rules dictate that when updating to a new version of any module always remove the original version from the modules directory before extracting the new version from the archive file.

jmseigneur’s picture

jmseigneur CreditAttribution: jmseigneur commented

Same problem here: beta2 cannot create the sitemap files in the folders. Had to revert back to beta1 to be able to create sitemaps in the folders. Reverting back was not so easy as it implied to uninstall, reinstall and reconfigure all sitemap options. beta1 is able to create the files in the folders so it is not a permission issue when beta2 cannot create those files in the same folders that beta1 is able to use.

SchwebDesign’s picture

SchwebDesign CreditAttribution: SchwebDesign commented

I got this error too:

user warning: Unknown column 'max_filesize' in 'field list' query: INSERT INTO xmlsitemap_sitemap (smid, context, updated, links, chunks, max_filesize) VALUES ('NXhscRe0440PFpI5dSznEVgmauL25KojD7u4e9aZwOM', 'a:0:{}', 0, 0, 0, 0) in /home/storages/public_html/includes/common.inc on line 3538.

However I had indeed first removed the entire xmlsitemap folder from the server before uploading the new version. I hadn't completely disabled and uninstalled the previous xmlsitemap module, however. I completely uninstalled the xmlsitemap module then reinstalled for good measure.

Thanks for the great module!

jantoine’s picture

jantoine CreditAttribution: jantoine commented
Version: 6.x-2.0-beta2 » 6.x-2.0-rc1

Getting this same error with 6.x-2.0-rc1. This is preventing the existing sitemaps from porting.

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

I don't know what is going on with this insert. The field exists after the update. I just used phpMyAdmin to do

INSERT INTO xmlsitemap_sitemap (smid, context, updated, links, chunks, max_filesize) VALUES ('NXhscRe0440PFpI5dSznEVgmauL25KojD7u4e9aZwOM', 'a:0:{}', 0, 0, 0, 0)

Be sure to use the values reported back to you in the update.

The error reported in #2 is being tracked at #1435264: Xml stops working Uncaught exception 'XMLSitemapGenerationException' error.

konrad1811’s picture

konrad1811 CreditAttribution: konrad1811 commented

earnie comment #7 helped! thanks!
I got problems after upgradeing from 6.1.2 to 6.2 rc
---
my D6 site: ccc wiosna 2012

ShaneOnABike’s picture

ShaneOnABike CreditAttribution: ShaneOnABike commented
Version: 6.x-2.0-rc1 » 6.x-2.0-rc2

The suggestion in #1 worked for me with reference to rc2 (I had the same error). After doing that I ran the update again and it was fine. Could we add that to the documentation as a tip perhaps?