Quick fix for myJournal Hypereal bugs on Wordpress 2.3

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.

tips

thank you HANS

Ender @ October 10, 2007,2:34 pm(#)

very good

skanery antywirusowe @ October 13, 2007,10:10 am(#)

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

Patin de Saulcourt Y @ October 13, 2007,11:46 pm(#)

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

thirstan @ October 14, 2007,5:39 am(#)

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!

jose americo gobbo @ November 1, 2007,10:49 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!

Amin @ November 2, 2007,6:23 pm(#)

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

LisaT @ November 15, 2007,12:37 am(#)

very good, thanks.

Web Tutorials @ January 12, 2008,2:16 pm(#)

Thank you HANS

Free Wallpapers @ January 16, 2008,2:53 am(#)

Thanks for article

Magazine @ January 18, 2008,12:37 am(#)

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

Ruddy @ January 18, 2008,3:21 am(#)

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

John Raul Joven II @ January 18, 2008,1:02 pm(#)

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

dreamline @ January 24, 2008,4:09 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

comradejv @ January 25, 2008,4:05 pm(#)

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

chuck norris jokes @ February 18, 2008,12:23 pm(#)

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

Soli @ February 29, 2008,7:35 pm(#)

Thanks Hans. Worked like a charm

Soa @ March 4, 2008,4:13 pm(#)

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

Charles @ March 10, 2008,4:51 am(#)

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.

falguni1 @ March 18, 2008,5:03 pm(#)

thanks for the information

Jeff Gordon @ March 18, 2008,6:37 pm(#)

Thanks for your hard work and solution. Keep going.

LookingSoftware @ April 30, 2008,4:47 am(#)