WordPress.org

Forums

WordPress Popular Posts
[resolved] [Plugin: WordPress Popular Posts] New update not working (9 posts)

  1. liveforfilms
    Member
    Posted 2 years ago #

    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/

  2. smashinbeauty
    Member
    Posted 2 years ago #

    Same here.... My site was DOWN due to this plugin for 5 days
    I just removed it!

  3. ppskb
    Member
    Posted 2 years ago #

    Same problem here. Broken

  4. eventindustrynews
    Member
    Posted 2 years ago #

    Same here on multiple sites

  5. atchor
    Member
    Posted 2 years ago #

    Well, this may help:

    SQL:

    ALTER TABLEwp_popularpostsdatacacheADDday_no_timeDATE NOT NULL DEFAULT '0000-00-00'

  6. atchor
    Member
    Posted 2 years ago #

    Correct
    ALTER TABLE 'wp_popularpostsdatacache' ADD 'day_no_time' DATE NOT NULL DEFAULT '0000-00-00'

  7. jacko2012
    Member
    Posted 2 years ago #

    does that fix it?

    where is that code located?

  8. liveforfilms
    Member
    Posted 2 years ago #

    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?

  9. Hector Cabrera
    Member
    Plugin Author

    Posted 2 years ago #

    Hi guys,

    This topic has been already covered in this thread, please try to read before posting stuff that has been discussed already.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WordPress Popular Posts
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.