[Plugin: WordPress Popular Posts] WPP 2.3.1 still have "WordPress database error

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.

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.

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.

Yes, that’s because when you deactivated and reactivated the plugin the missing table field was created ?? 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.

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: https://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/

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: https://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/

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

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!!

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 ?

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

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.

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

Hi No1SoloFan,

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