BlogoSquare

Essential problogging resources and downloads

Quick fix for myJournal Hypereal bugs on Wordpress 2.3

October 9th, 2007 by Hans

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; ?> categories and delete it altogether.

That should do it. Hope this helps fixing things quickly.

Tags:   · · · · · 22 Comments

Leave A Comment

22 responses so far ↓

  • 1 GadgetGadget.info - Gadgets on the web » Quick fix for myJournal Hypereal bugs on Wordpress 2.3 Oct 9, 2007 at 9:46 pm

    […] 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 … […]

  • 2 Ender Oct 10, 2007 at 2:34 pm

    thank you HANS

  • 3 skanery antywirusowe Oct 13, 2007 at 10:10 am

    very good

  • 4 Patin de Saulcourt Y Oct 13, 2007 at 11:46 pm

    I can fix proplems on my blog, Thank’s very much !
    Yann

  • 5 thirstan Oct 14, 2007 at 5:39 am

    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

  • 6 jose americo gobbo Nov 1, 2007 at 10:49 pm

    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!

  • 7 Amin Nov 2, 2007 at 6:23 pm

    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!

  • 8 LisaT Nov 15, 2007 at 12:37 am

    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

  • 9 Web Tutorials Jan 12, 2008 at 2:16 pm

    very good, thanks.

  • 10 Free Wallpapers Jan 16, 2008 at 2:53 am

    Thank you HANS :)

  • 11 Magazine Jan 18, 2008 at 12:37 am

    Thanks for article

  • 12 Ruddy Jan 18, 2008 at 3:21 am

    This is great. I also use wordpress for my blog. Thanks for the code, man!

  • 13 John Raul Joven II Jan 18, 2008 at 1:02 pm

    Thanks, Hans. I just fixed the error when I upgraded my blog. Sweet!

  • 14 dreamline Jan 24, 2008 at 4:09 pm

    Journal Hypereal is cool, thx for that theme… by the way can I add more translate language? please teach how to do that

  • 15 comradejv Jan 25, 2008 at 4:05 pm

    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

  • 16 chuck norris jokes Feb 18, 2008 at 12:23 pm

    Is it me, or there aren’t any new posts since October. Where the hell did you go?

  • 17 Soli Feb 29, 2008 at 7:35 pm

    Thanks for sharing this wordpress problem fixing with others. It is appreciated.

  • 18 Soa Mar 4, 2008 at 4:13 pm

    Thanks Hans. Worked like a charm

  • 19 Charles Mar 10, 2008 at 4:51 am

    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

  • 20 falguni1 Mar 18, 2008 at 5:03 pm

    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.

  • 21 Jeff Gordon Mar 18, 2008 at 6:37 pm

    thanks for the information

  • 22 LookingSoftware Apr 30, 2008 at 4:47 am

    Thanks for your hard work and solution. Keep going.