WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. liveforfilms
    Member
    Posted 1 year 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 1 year ago #

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

  3. ppskb
    Member
    Posted 1 year ago #

    Same problem here. Broken

  4. eventindustrynews
    Member
    Posted 1 year ago #

    Same here on multiple sites

  5. atchor
    Member
    Posted 1 year ago #

    Well, this may help:

    SQL:

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

  6. atchor
    Member
    Posted 1 year ago #

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

  7. jacko2012
    Member
    Posted 1 year ago #

    does that fix it?

    where is that code located?

  8. liveforfilms
    Member
    Posted 1 year 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. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year 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

About this Topic

Tags

No tags yet.