Pinyin

Thanks, Johnb81.

Unfortunately, that didn’t work. Perhaps that only affects any new tables in the database. At any rate, it didn’t change the pre-existing tables, which are still marked as being Swedish.

Many thanks. That seems to be it. Somehow the tables in that database (but not in all of my others, for some reason) are now marked as being “latin1_swedish_ci”.

I looked around the phpmyadmin interface but didn’t see a way to change them over to utf-8. Any suggestions? I’m afraid I’m just a newbie when it comes to MYSQL.

I’m having similar woes. Here’s what I’ve been getting lots and lots of since upgrading to 2.3:
—
WordPress database error: [Table ‘py.wp_post2cat’ doesn’t exist]
SELECT post_id, category_id FROM wp_post2cat WHERE post_id IN (***)
—
[I’ve substituted *** for the numbers that appear in parentheses, as they are different in each post and appear to be the post number.]

I tried disabling all plugins. This made no difference. (I had only a few basic ones anyway.)

I tried changing from my own custom theme to other themes. The problem didn’t change. (The only thing I had altered in my own theme was the CSS. I don’t know enough about PHP to mess with that.)

Searches of my files didn’t turn up the code magnetbox posted, so I couldn’t change that.

douglsmith’s Preflight plugin didn’t turn up anything in need of fixing.

What *does* improve things temporarily is if I run the database update script (wp-admin/upgrade.php). But, oddly enough, the fix doesn’t last; the problems always return.

I’ve cleared the cache in my browser. I’ve tried different browsers (Opera, Firefox, IE). No difference.

In case it matters, this blog is hosted on Dreamhost. WordPress was installed through the Dreamhost panel and has been upgraded through that as well.

Any useful advice would be gratefully received. Thanks.

Thanks, HandySolo!

Here’s what I received from Dreamhost:

“The problem with your comments is that the table the comments were stored in needed a repair (which can be done via phpMyAdmin). I have repaired the table and your comments are working again. You may still see the errors, but that is simply because wp-cache has cached them. Once it refreshes, you’ll be good to go.”

Everything is well now.