WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Popular Posts
WPP 2.3.1 still have "WordPress database error (14 posts)

  1. La ruelle bleue
    Member
    Posted 1 year ago #

    Hi !

    I just have upgraded to Wpp 2.3.1 to fix the wordpress data base error :

    WordPress database error: [Unknown column 'day_no_time' in 'field list']INSERT INTO lrbpopularpostsdatacache (id, day, day_no_time) VALUES (9036, '2012-09-01 13:14:46', '2012-09-01') ON DUPLICATE KEY UPDATE pageviews = pageviews + 1, day = '2012-09-01 13:14:46', day_no_time = '2012-09-01';

    but this error remains the same and it appears when I publish my post into my facebook page...

    In addition, I have noticed that when I make a google search on some of my posts (but not all!), the summary in the google results reports the same error message... You can test it with this request on google :

    ruelle bleue womersley

    thanks for your help!

    http://wordpress.org/extend/plugins/wordpress-popular-posts/

  2. jonegarrett
    Member
    Posted 1 year ago #

    I'm pretty much a newbie but everything you have done has been top notch Hector. That said I'm experiencing the same problem as the user above. It seems to mostly affect facebook and did not happen when I used the short code. Also at one point I switched the format of my blog links to take out the day and year everything was fine, but it also made all my previous links invalid. The one other thing I'm noticing that no one is talking about is that after I installed I got hundreds of false hits. Articles that I just put up the day before had 130 hits within hours. I was monitoring at the time and this was not the case... as well the stats for jetpack/wordpress agree with my estimate. Anyway, as a newbie I hope this doesn't sound ridiculous.

  3. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    Hi guys,

    That's odd. Please try this:

    For those having the Unknown column 'day_no_time' in 'field list error, try deactivating and reactivating the plugin - it should create the missing day_no_time field into the wp_popularpostsdatacache table. If that doesn't help, then please go to your phpmyadmin (or whatever tool your hosting provides to access your databases), select the wp_popularpostsdatacache table (it might be named slightly different if your table prefix is different from the default wp_) and run this query:

    ALTER TABLE wp_popularpostsdatacache ADD day_no_time date NOT NULL default '0000-00-00';

    That should create the missing table field and the error will be gone.

    @jonegarrett About the hits, I will take a look at that as soon as I get some spare time.

  4. jonegarrett
    Member
    Posted 1 year ago #

    Been following this one since the initial drop. Already tried deactivating/activating trick and just did it again. It worked to get my blog back from broken earlier, but the other error persist. Also tried the query and i get this code:#1060 - Duplicate column name 'day_no_time'. It appears the column is there.

  5. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    Yes, that's because when you deactivated and reactivated the plugin the missing table field was created :P You had no need to run that query hehe

    Will keep you posted about the other issue. Everything seems normal here, still will give it a second look at the code just in case I missed something.

  6. jonegarrett
    Member
    Posted 1 year ago #

    Thanks. It is so weird. I'm a newbie but I started out doing this stuff years ago in college. Was to dumb to keep doing it or retain much. Wanted to write or something ;P Like I said, it stopped doing it when I changed my links to stop using the date in their format but that broke all my permalinks out there. Most of the other post seem to work but the last one I made, and the unusually high view count that has accompanied this installation are weird. I have some stories over 200 or so points off their actually pageview count. This is the the link that is giving me the most trouble with the aforementioned error though: http://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/

  7. jonegarrett
    Member
    Posted 1 year ago #

    Thanks. It is so weird. I'm a newbie but I started out doing this stuff years ago in college. Was to dumb to keep doing it or retain much. Wanted to write or something ;P Like I said, it stopped doing it when I changed my links to stop using the date in their format but that broke all my permalinks out there. Most of the other post seem to work but the last one I made, and the unusually high view count that has accompanied this installation are weird. I have some stories over 200 or so points off their actually pageview count. This is the the link that is giving me the most trouble with the aforementioned error though: http://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/

  8. no1solofan
    Member
    Posted 1 year ago #

    I tried to deactivate and reactivate, and am still getting errors. Please help! Thank you.

  9. lohrman
    Member
    Posted 1 year ago #

    Hector - You've completely destroyed you credibility with me. Your update to this plugin has broken my blog for several days... I'm done with your plugin!!

  10. La ruelle bleue
    Member
    Posted 1 year ago #

    I deactivated and reactivated and then I had a look with phpmyadmin into the wp_popularpostsdatacache table. The column day_no_time exists and is filled with data but I still have the error with the link in google or facebook !

    And it seems to me, as well as jonegarett, that there are false hits too...

    I think I should restore my wdp database before the wpp upgrading, shouldn't I ?

  11. silenceworld
    Member
    Posted 1 year ago #

    google has indexed my broken pages - That's awful

    what to expect from here. We know very well that this plugin is free, but you still need to do something to make it work 100%, please

  12. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    Alright. First of all, I don't owe anything to you nor I'm being paid for this, therefore you cannot demand anything from me.

    I spend part of my time answering your questions and trying to make this plugin as good as possible - yet I get these harsh responses. If you ever felt I work for you, well, I'm don't.

    Are you not satisfied with this plugin? That's OK. It's not perfect and there are many other options out there, you don't have to use it. Just don't come here to complain because honestly I couldn't care less.

    Don't bother asking me for support again.

  13. no1solofan
    Member
    Posted 1 year ago #

    Hi Hector - Sorry to hear that people expect things. I was always taught to ask please and say thank you, and that is my motto all the time.

    With that said, would you please review the Facebook Link thread, and help me try to resolve why when I put a link to Facebook, it shows the errors? Not sure of your time zone, but I will even offer to pay you to help me resolve this error on my site. I'm on skype and such, and would be happy to let you log into my DB so you can have a look. Happy to accomodate towards getting this resolved.

    Your help is greatly appreciated.
    Warm regards,
    No1SoloFan!
    THanks

  14. Héctor Cabrera
    Member
    Plugin Author

    Posted 1 year ago #

    Hi No1SoloFan,

    I'll stop by your thread. Thanks for your words!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.