Unknown column error

Maybe it doesn't matter, but I noticed that the implementation of hook_schema_alter() that would add the menu_name field is defined in the installation file. Is that normal, or should the hook be defined in the module file?

Where hook_schema_alter() is located doesn't make a difference. Before the call to drupal_alter('schema', $schema), Drupal calls module_load_all_includes('install'); even if the hook would be in the installation file, the file would be already loaded from Drupal, by the time it executes the call to drupal_alter('schema', $schema).

It seems that when the query is executed, the schema has not been altered from xmlsitemap_menu.module; maybe it happens because Drupal core code is using the schema it saved in its cache.

xmlsitemap_menu uses schema_alter and also adds the column in an update/install function. Since schemas are cached, my guess is this was a problem that drupal_write_record() was using the cached schema before the change. I can look into clearing the schema cache when these columns are added and that should prevent this error from popping up.

Hmm...but running update.php should clear the caches (which include the schema cache), so I'm not sure that would do any good.

Did you enable third-party modules that handle the menu?

BryanSD, have you had this problem happen since your last post?

It's usual to set the report to fixed, so other can see the report for the next 2 weeks (and avoid open a similar one).

I am not sure if to classify this as a bug report, as the error went away alone.