* user warning: Table 'drupal_gsprint.xmlsitemap_additional' doesn't exist query: SELECT COUNT(*) FROM xmlsitemap_additional WHERE status = 1 in /var/www/html/drupal/sites/all/modules/xmlsitemap/xmlsitemap/xmlsitemap.module on line 209.
* user warning: Unknown column 'status' in 'where clause' query: SELECT COUNT(*) FROM xmlsitemap_node WHERE status = 1 AND ((priority >= 0.0 AND priority <= 1.0 AND priority_override = -2.0) OR (priority_override >= 1.0 AND priority_override <= 1.0)) in /var/www/html/drupal/sites/all/modules/xmlsitemap/xmlsitemap_node/xmlsitemap_node.module on line 235.

site works fine after the upgrade.

Comments

avpaderno’s picture

Title: two sql error upgrade to 1.x-dev (May 27) » SQL errors on upgrading to 6.x-1.x-dev
dave reid’s picture

So you're saying that after you ran update.php, the errors disappeared? If that's the case, then this is intended behavior and I'll mark as fixed.

avpaderno’s picture

If it's working fine, where is the bug?

mattyoung’s picture

>So you're saying that after you ran update.php, the errors disappeared?

No, not disappeared. The error message come up at the end of running 'update.php'.

Here is what I did:

- I replace my old xmlsitemap with the new version
- run 'update.php'
- update progress show 12 updates, update executes ... 1/12, 2/12, 3/12 ...
- At the end, the error messages came out at the top followed by a list of query strings executed

After this, I browse my site and it works without any problem.

avpaderno’s picture

The shown errors are caused by some hooks being invoked before all the update functions are done.

Anonymous’s picture

Status: Active » Closed (won't fix)

We've reset the code via #483844: Restore code to beta0. There is not intra development upgrade path available. You must follow the instructions per #379854-128: The site map is not being populated.