Posted 8 months ago #
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.
What exactly were you doing when you got the error message? Did you edit any php files or DB tables?
Posted 8 months ago #
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+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=WordPress+database+error:+Unknown+column+%27day_no_time%27+in+%27field+list%27&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
Looks something weird. Also see this.
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.
Posted 8 months ago #
please paste the below code in the template php file where the error occurs:
<?php print_r($wp_query) ?>
then paste the result in pastebin and paste the link here
Posted 8 months ago #
Here is the result: http://pastebin.com/DFT5hbVn
Posted 8 months ago #
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...
Posted 8 months ago #
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.
Posted 8 months ago #
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, please do not update the latest version until the developer of this plugin fix the problem. You can refer here: WordPress Popular Posts
Posted 8 months ago #
Just deactivating and then reactivating it solved the problem for me
Posted 8 months ago #
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.
You must log in to post.
