WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Google XML Sitemaps] Error during Publish with latest version (8 posts)

  1. bl968
    Member
    Posted 4 years ago #

    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/

  2. gorky5
    Member
    Posted 4 years ago #

    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.

  3. MaxWell83
    Member
    Posted 4 years ago #

    I also have this problem

  4. arnee
    Member
    Posted 4 years ago #

    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.

  5. gorky5
    Member
    Posted 4 years ago #

    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.

  6. arnee
    Member
    Posted 4 years ago #

    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

  7. gorky5
    Member
    Posted 4 years ago #

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

  8. arnee
    Member
    Posted 4 years ago #

    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 :-)

Topic Closed

This topic has been closed to new replies.

About this Topic