Title: WordPress Database Error Last modified: August 20, 2016 --- # WordPress Database Error * Resolved [exception2008](https://wordpress.org/support/users/exception2008/) * (@exception2008) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/) * I got some error on my self hosted wordpress site, it display this message: WordPress database error: [Unknown column ‘day_no_time’ in ‘field list’] * I try search the exact error in Google and found this error also happen to the other wordpress site starting today. * I don’t know what the problem and how this happen. Viewing 10 replies - 1 through 10 (of 10 total) * [Krishna](https://wordpress.org/support/users/1nexus/) * (@1nexus) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011294) * What exactly were you doing when you got the error message? Did you edit any php files or DB tables? * Thread Starter [exception2008](https://wordpress.org/support/users/exception2008/) * (@exception2008) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011303) * It happen just today, last night everything is fine… Try look at this Google search result: [https://www.google.com.my/search?q=WordPress+database+error%3A+%5BUnknown+column+%27day_no_time%27+in+%27field+list%27%5D&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a#q=WordPress+database+error:+%5BUnknown+column+%27day_no_time%27+in+%27field+list%27%5D&hl=en&client=firefox-a&rls=org.mozilla:en-US:official&prmd=imvns&ei=38NBUMz8CceGrAei4YGoCw&start=90&sa=N&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&fp=104710d91e4851b7&biw=1280&bih=582](https://www.google.com.my/search?q=WordPress+database+error%3A+%5BUnknown+column+%27day_no_time%27+in+%27field+list%27%5D&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a#q=WordPress+database+error:+%5BUnknown+column+%27day_no_time%27+in+%27field+list%27%5D&hl=en&client=firefox-a&rls=org.mozilla:en-US:official&prmd=imvns&ei=38NBUMz8CceGrAei4YGoCw&start=90&sa=N&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&fp=104710d91e4851b7&biw=1280&bih=582) * [Krishna](https://wordpress.org/support/users/1nexus/) * (@1nexus) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011307) * Looks something weird. Also [see this](https://www.google.com.my/search?q=WordPress+database+error%3A+Unknown+column+%27day_no_time%27+in+%27field+list%27&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a#q=Unknown+column+%27day_no_time%27+in+%27field+list%27&hl=en&client=firefox-a&rls=org.mozilla:en-US:official&prmd=imvns&ei=yNNBUNTsDsWGrAfZxoDADA&sqi=2&start=10&sa=N&bav=on.2,or.r_gc.r_pw.r_qf.&fp=226415cda1e75b97&biw=1600&bih=732). * If it is a new bug specific to WordPress, some others may also report it. But I have seen no such reports so far. All the sites having the above problems are NOT running on WordPress. * [tiaanswart](https://wordpress.org/support/users/tiaanswart/) * (@tiaanswart) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011309) * please paste the below code in the template php file where the error occurs: * `` * then paste the result in pastebin and paste the link here * Thread Starter [exception2008](https://wordpress.org/support/users/exception2008/) * (@exception2008) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011316) * Here is the result: [http://pastebin.com/DFT5hbVn](http://pastebin.com/DFT5hbVn) * [tiaanswart](https://wordpress.org/support/users/tiaanswart/) * (@tiaanswart) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011327) * I can’t see anything in particular that is causing this issue? * Might be a plugin or your theme that is causing this, try reverting back to default twenty eleven theme and disable all plugins… * If the issue persists then i don’t have a clue what is wrong if not then you can be sure that the root cause is a plugin you deactivated or your theme… * [erdickey](https://wordpress.org/support/users/erdickey/) * (@erdickey) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011400) * Did you figure this out? Happened to me too and I updated several plugins this morning – saw somewhere else that it was the WP Popular Posts plugin, which I do have… so I deactivated it and the blog seems to be working fine now. * Thread Starter [exception2008](https://wordpress.org/support/users/exception2008/) * (@exception2008) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011402) * I’ve solve the problem, it caused by plugin WordPress Popular Posts. The latest version 2.3.0 got several bug, you may need to deactivate the delete the plugin then install the previous version 2.2.1: [http://downloads.wordpress.org/plugin/wordpress-popular-posts.2.2.1.zip](http://downloads.wordpress.org/plugin/wordpress-popular-posts.2.2.1.zip), please do not update the latest version until the developer of this plugin fix the problem. You can refer here: [WordPress Popular Posts](http://wordpress.org/extend/plugins/wordpress-popular-posts/) * [erdickey](https://wordpress.org/support/users/erdickey/) * (@erdickey) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011403) * Just deactivating and then reactivating it solved the problem for me * [Sara Bellum](https://wordpress.org/support/users/sara-bellum/) * (@sara-bellum) * [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011451) * I just went through this, I updated popular posts this morning and the error message was just pointed out to me. I deactivated “popular posts” and it corrected itself. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘WordPress Database Error’ is closed to new replies. ## Tags * [unknown column](https://wordpress.org/support/topic-tag/unknown-column/) * [WordPress database error](https://wordpress.org/support/topic-tag/wordpress-database-error/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 10 replies * 5 participants * Last reply from: [Sara Bellum](https://wordpress.org/support/users/sara-bellum/) * Last activity: [13 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-61/#post-3011451) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics