Title: [Plugin: WordPress Popular Posts] WPP 2.3.1 still have "WordPress database error Last modified: August 20, 2016 --- # [Plugin: WordPress Popular Posts] WPP 2.3.1 still have "WordPress database error * [La ruelle bleue](https://wordpress.org/support/users/la-ruelle-bleue/) * (@la-ruelle-bleue) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/) * 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/](http://wordpress.org/extend/plugins/wordpress-popular-posts/) Viewing 13 replies - 1 through 13 (of 13 total) * [jonegarrett](https://wordpress.org/support/users/jonegarrett/) * (@jonegarrett) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016196) * 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. * 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-wpp-231-still-have-wordpress-database-error/#post-3016297) * 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](https://wordpress.org/support/users/jonegarrett/)** About the hits, I will take a look at that as soon as I get some spare time. * [jonegarrett](https://wordpress.org/support/users/jonegarrett/) * (@jonegarrett) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016300) * 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. * 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-wpp-231-still-have-wordpress-database-error/#post-3016301) * 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. * [jonegarrett](https://wordpress.org/support/users/jonegarrett/) * (@jonegarrett) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016303) * 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/](http://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/) * [jonegarrett](https://wordpress.org/support/users/jonegarrett/) * (@jonegarrett) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016305) * 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/](http://www.jonegarrett.com/2012/08/31/football-is-the-best-medicine/) * [no1solofan](https://wordpress.org/support/users/no1solofan/) * (@no1solofan) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016314) * I tried to deactivate and reactivate, and am still getting errors. Please help! Thank you. * [lohrman](https://wordpress.org/support/users/lohrman/) * (@lohrman) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016339) * 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!! * Thread Starter [La ruelle bleue](https://wordpress.org/support/users/la-ruelle-bleue/) * (@la-ruelle-bleue) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016350) * 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 ? * [silenceworld](https://wordpress.org/support/users/silenceworld/) * (@silenceworld) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016362) * 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 * 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-wpp-231-still-have-wordpress-database-error/#post-3016387) * 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. * [no1solofan](https://wordpress.org/support/users/no1solofan/) * (@no1solofan) * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-popular-posts-wpp-231-still-have-wordpress-database-error/#post-3016483) * 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 * 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-wpp-231-still-have-wordpress-database-error/#post-3016542) * Hi No1SoloFan, * I’ll stop by your thread. Thanks for your words! Viewing 13 replies - 1 through 13 (of 13 total) The topic ‘[Plugin: WordPress Popular Posts] WPP 2.3.1 still have "WordPress database error’ 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/) * 13 replies * 6 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-wpp-231-still-have-wordpress-database-error/#post-3016542) * Status: not resolved