If you have upgraded recently to WordPress 2.3, you’ll notice the following error message appearing either under your sidebars or at the bottom of your blog :
WordPress database error: [Table 'edrop.wp_categories' doesn't exist]
SELECT COUNT(*) FROM wp_categories
This is caused for the simple reason that some codes have been deprecated in the new WordPress 2.3 which causes the above error. It’s really easy to fix this problem, just proceed as follows:
- Using your favourite FTP program(FileZilla is a good one), navigate to wp-content/themes/myjournal hypereal theme folder and open the footer.php using your favourite text editor.
- At the top part, find the following code and delete it:
$numcats = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->categories");
if (0 < $numcats) $numcats = number_format($numcats);Then somewhere at the bottom of the same file, footer.php, find this part :
extending over <?php echo $numcats; ?> categoriesand delete it altogether.
That should do it. Hope this helps fixing things quickly.
[...] John Jantsch wrote an interesting post today!.Here’s a quick excerptThis is caused for the simple reason that some codes have been deprecated in the new WordPress 2.3 which causes the above error. It’s really easy to fix this problem, just proceed as follows:. Using your favourite FTP program(FileZilla … [...]
thank you HANS
very good
I can fix proplems on my blog, Thank’s very much !
Yann
Thanks for the update. I am new to this and this was my first edit of a theme file. Yeah me
Someday I will look back and laugh.
thirstan
just a noobie
Hello,
I have installed this model (myJournal Hypereal) on my blog (wordpress, v.2.3.1), http://8080studium.com.br/blog. I configured to allow visitors to leave comments, but strangely in the pages that I created the form of tests for comments is not.
In admin, I authorized all in Options / Discussion and also in form for the creation of ‘pages’. I used another model (Upstart Blogger Modicus) and will appear correctly. Could you give me some advice? Thank you very much!
I wish I’d seen this information before I upgraded to WP 2.3!
I love WP so much because it’s a great tool, but honestly, it feels like there’s a new update every five minute these days. I’m rather hoping it will settle down over the next couple of weeks and remain as it is for a while, although I can see that the march of progress is hard to halt.
Good tip though – and a timely one!
Thanks! That fixed the error message at the footer. I’m also having a similar error at the top left corner and cannot seem to find where it is coming from…..
WordPress database error: [Table 'ladiesun_wrdp4.wp_categories' doesn't exist]
SELECT cat_name FROM wp_categories ORDER BY cat_name ASC
very good, thanks.
Thank you HANS
Thanks for article
This is great. I also use wordpress for my blog. Thanks for the code, man!
Thanks, Hans. I just fixed the error when I upgraded my blog. Sweet!
Journal Hypereal is cool, thx for that theme… by the way can I add more translate language? please teach how to do that
ki p dire cuz mo trouver to p mange r to website cuma avan keep it up… pas tan twa ditou mo ti call twa hier mais to ti cour..bon pas grav.. mo esperé to bien mo conner pas ene place pou demend nuvel mais mo sure la to pou check mo message… bye
Is it me, or there aren’t any new posts since October. Where the hell did you go?
Thanks for sharing this wordpress problem fixing with others. It is appreciated.
Thanks Hans. Worked like a charm
I just installed the latest version and the error was appearing. After waiting a day or so, it is now gone…. ? Not sure what happened.
WindowServer2008.com
I can see anything in my right column it is empty.
the shops and cool members are in the 2nd column in admin, in blog I see it in first column.
wot to do.
I cant see anything in 2nd column.
I add anything to 2nd column it is shifted to first column.
I am using wordpress 2.3.3.
thanks for the information
Thanks for your hard work and solution. Keep going.