Issue With Categories - UPDATED - Problem Solved!

Hey Guys,

Looks like there was one problem with my upgrade. I kinda nuked the ability to add categories to my posts. You can see the error message on the page to the bottom right under my last category.

Can anyone point me in the right direction?

Gorilla Music

Image via this nicely made site.

UPDATE!!! Thanks to my awesome readers in the comments (details below if you’re interested), problem solved. Looking forward to a lot of fast moving posting from here on out. In know it may sound petty, but I think part of the reason I’ve been posting less lately is due to my personal frustration with how long it took to post. Hopefully, that’s now a none deail.

Submit Article :- BlinkList + Blogmarks + Digg + Del.icio.us + Ekstreme Socializer + Feedmarker + Furl + Google Bookmarks + ma.gnolia + Netvouz + RawSugar + Reddit + Scuttle + Shadows + Simpy + Spurl + Technorati + Unalog + Wink

Posted in: TV in Japan News

This entry was posted on Sunday, July 1st, 2007 at 4:32 pm and is filed under TV in Japan News. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

9 Responses to “Issue With Categories - UPDATED - Problem Solved!”

Luis July 1st, 2007 at 6:14 pm

Not sure what you did, but the issue is that the SQL you are running is trying to filter on a field (link_count) that is not in the table (wp_categories).

Did you add any new plug-ins or make any database changes recently?

Luis July 1st, 2007 at 6:18 pm

Would’ve helped if I read the previous post. orz

Did any database upgrade scripts (*.sql) come with the WP upgrade? You may not have applied the necessary database patches yet, or they might not have run successfully.

Scott July 1st, 2007 at 6:25 pm

Maybe here? Looks like somebody just posted their fix to a similar problem a few hours ago. Sounds like it could be a problem with permissions to ALTER tables in the mysql database when you run upgrade.php.

flatluigi July 1st, 2007 at 6:48 pm

Here’s a page with instructions:
http://wordpress.org/support/topic/101893?replies=4

Reading other pages found by googling the error message suggests disabling all plugins during upgrade and removing their tables. Another page says this:

“I solved it, doing something else… I just edited the /wp-admin/upgrade-functions.php and in the line 134 where it says

// We are up-to-date. Nothing to do.
if ( $wp_db_version == $wp_current_db_version )
return;

I deleted those lines, upload again that file and did the /wp-admin/upgrade.php again and that solved those issues. After I fixed it, I just restored the lines.”

gavinpurcell July 1st, 2007 at 10:58 pm

Scott wins the prize as the post he sent me to was the exact problem that I was having. It could be that this issue has to do with Yahoo hosted blogs?

Either way, I ended up having to go into the MySQL database and add a couple tables that for some reason didn’t get added in the upgrade.

All is good.

Thanks again to everyone who helped!

Scott July 2nd, 2007 at 7:47 am

Glad I could help. Wouldn’t want to miss out on all the Japanese TV goodness.

immeseviDlile February 16th, 2008 at 11:10 am

Just discovered a complete list of all marked down products at Amazon, sorted by category
and % off, ranging from 50% off to 90% off (thanks Sonja for the effort).

Actually I never thought Amazon would have articles with 90% off, but only in the category
Electronics there are more than 3000 of them - look for yourself, the list is on
Bargain Hunter (which is a blog of a woman who specializes in finding good deals at
Amazon, like Britain’s “Jeanie”).

Leave a Reply