Title: [Plugin: WordPress Popular Posts] New update not working
Last modified: August 20, 2016

---

# [Plugin: WordPress Popular Posts] New update not working

 *  Resolved [liveforfilms](https://wordpress.org/support/users/liveforfilms/)
 * (@liveforfilms)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/)
 * The popular post plugin had been working fine and it did a great job.
 * Last night I saw there was an update for it and activated it. I had to redo the
   image sizes again and thought nothing of it.
 * This morning I noticed the traffic had dropped to a couple of hits an hour. Way
   down from the usual traffic.
 * Everything seemed fine to me, but asking on twitter and facebook people had problems–
   they had database errors or the site would load but no content would show and
   a few people emailed me with this type of error.
 * WordPress database error: [Unknown column ‘day_no_time’ in ‘field list’]
    INSERT
   INTO wrd_popularpostsdatacache (id, day, day_no_time) VALUES (73516, ‘2012-09-
   03 09:21:16’, ‘2012-09-03’) ON DUPLICATE KEY UPDATE pageviews = pageviews + 1,
   day = ‘2012-09-03 09:21:16’, day_no_time = ‘2012-09-03’;
 * I have deactivated the plugin for now and things seem to be back to normal.
 * Do I need to do something different to make it work again or does it need fixing.
 * Hope it gets sorted soon as I did like using it.
 * Thanks
 * [http://wordpress.org/extend/plugins/wordpress-popular-posts/](http://wordpress.org/extend/plugins/wordpress-popular-posts/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  [smashinbeauty](https://wordpress.org/support/users/smashinbeauty/)
 * (@smashinbeauty)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015367)
 * Same here…. My site was DOWN due to this plugin for 5 days
    I just removed it!
 *  [ppskb](https://wordpress.org/support/users/ppskb/)
 * (@ppskb)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015379)
 * Same problem here. Broken
 *  [eventindustrynews](https://wordpress.org/support/users/eventindustrynews/)
 * (@eventindustrynews)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015387)
 * Same here on multiple sites
 *  [atchor](https://wordpress.org/support/users/atchor/)
 * (@atchor)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015389)
 * Well, this may help:
 * SQL:
 * `ALTER TABLE`wp_popularpostsdatacache`ADD`day_no_time`DATE NOT NULL DEFAULT '
   0000-00-00'`
 *  [atchor](https://wordpress.org/support/users/atchor/)
 * (@atchor)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015390)
 * Correct
    `ALTER TABLE 'wp_popularpostsdatacache' ADD 'day_no_time' DATE NOT NULL
   DEFAULT '0000-00-00'`
 *  [jacko2012](https://wordpress.org/support/users/jacko2012/)
 * (@jacko2012)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015399)
 * does that fix it?
 * where is that code located?
 *  Thread Starter [liveforfilms](https://wordpress.org/support/users/liveforfilms/)
 * (@liveforfilms)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015400)
 * Will the problem be fixed in the next update or do we have to do this manual 
   fix?
 * Anyone know of any other popular post plugins that I can use in the meantime?
 *  Plugin Author [Hector Cabrera](https://wordpress.org/support/users/hcabrera/)
 * (@hcabrera)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015405)
 * Hi guys,
 * This topic has been already covered in [this thread](http://wordpress.org/support/topic/plugin-wordpress-popular-posts-version-version-230-breaks-the-blog),
   please try to read before posting stuff that has been discussed already.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘[Plugin: WordPress Popular Posts] New update not working’ is closed to
new replies.

 * ![](https://ps.w.org/wordpress-popular-posts/assets/icon-256x256.png?rev=1232659)
 * [WP Popular Posts](https://wordpress.org/plugins/wordpress-popular-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-popular-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-popular-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-popular-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-popular-posts/reviews/)

 * 8 replies
 * 7 participants
 * Last reply from: [Hector Cabrera](https://wordpress.org/support/users/hcabrera/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-new-update-not-working/#post-3015405)
 * Status: resolved