WordPress.org

1. bl968
   Member
   Posted 2 weeks 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 2 weeks 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 2 weeks ago #

   I also have this problem

4. arnee
   Member
   Posted 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 :-)

Reply

You must log in to post.