WordPress.org

Support

Support » Plugins and Hacks » [Plugin: Google XML Sitemaps] Error during Publish with latest version

[Plugin: Google XML Sitemaps] Error during Publish with latest version

  • After the most recent update I started receiving this error after publishing.

    WordPress database error: [Unknown column ‘p.user_nicename’ in ‘field list’]
    SELECT DISTINCT p.ID, p.user_nicename, MAX(p.post_modified_gmt) AS last_post FROM wp_users u, wp_posts p WHERE p.post_author = u.ID AND p.post_status = ‘publish’ AND p.post_type = ‘post’ AND p.post_password = ” GROUP BY u.ID, u.user_nicename

    Warning: Cannot modify header information – headers already sent by (output started at wp-includes/wp-db.php:587) in wp-includes/pluggable.php on line 865

    Paths modified for security purposes.

    It took me a while to track it down and finally with a recursive grep I traced it down to Google Sitemaps…

    # grep “p.user_nicename” ./* -R

    ./plugins/google-sitemap-generator/sitemap-core.php: p.user_nicename,
    ./wp-content/plugins/google-sitemap-generator/sitemap-core.php: p.user_nicename,

    These were the only mentions for p.user_nicename…

    http://wordpress.org/extend/plugins/google-sitemap-generator/

Viewing 7 replies - 1 through 7 (of 7 total)
  • I get the same error when saving files with version 3.1.8. It seems to conflict with other plugins in my installation.

    It only works when I disable Bad Behavior (http://www.bad-behavior.ioerror.us/) and WP-dTree (http://wordpress.org/extend/plugins/wp-dtree-30/), which I’d prefer not to do. Until it’s fixed I’m going to roll back to 3.1.7.

    I also have this problem

    Sorry, looks like a copy and paste problem… it should be u.user_nicename instead of p.user_nicename. Will be fixed with next release.

    When is the next release likely to be, please? It’d be nice not to see the reminder to upgrade whenever I look at my WP admin pages.

    Probably at the end of the week, there some more changes which are currently tested by some beta users and I want to wait for their feedback before releasing it.

    In the meantime, you could change the line in the PHP file by yourself 🙂

    Just search for p.user_nicename in sitemap-core.php and replace it with u.user_nicename

    Thanks,

    Arne

    Excellent – thanks for the info Arne, and for your work on this useful plugin. I’ll try making those changes now.

    Since more people complained about that, I decided to release a quick-fix version which only corrects this bug. So you can just auto-update 🙂

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘[Plugin: Google XML Sitemaps] Error during Publish with latest version’ is closed to new replies.