codethought

Mine appeared to be related to a process space problem on the MySQL server. When I was moved to a different hosting system the problems went away.

iridiax,

I found the issue.. it was a version of an .htaccess file that needed to be removed/modified.

Thanks.

Hrm…. the link didn’t work.. I’ll try again

https://img14.imageshack.us/img14/7510/picture1ckn.png

Yea see I still have the term relationships and term taxonomy tables.

Near as I can tell it’s something related to MySQL 4.0.x. Because in a 5.0.x environment on my Mac system everything just rips and tears new ones… so to speak.

Michael,

And if you edit a given post and update it, does the category and tag info then reflect on that post when you view your blog?

Nope. Tried that.

Here’s another thing. I exported the database from the hosted server and pulled it to my mac, updated the data in the SQL script to reflect the local server, and set up a copy of my blog on my mac. The tables worked fine.

So I thought “OH, OK.. I’ll just export the tables, drop them in the MySQL prompt and re-import them…!”

Nope.. same problem.

If I created a WordPress export of the site from the admin tool in that XML format that wordpress uses, and I import it, all of the categories are blown out then also. It’s only when I fetch the SQL dump that I can make it work correctly on my Mac.

And then I look this morning and everything is working fine… and then an hour later it’s doing this weird crap again…

The hosted MySQL server is 4.0.18 (I think) and the one on my Mac is 5.0.28 (not sure about the .28 but I know it’s a 5.0 variant).

The ‘term’ tables are the one to check and don’t worry about the Cardinality column.

Those appear to be fine. In fact all of them appear to be fine.

My previous hosting server is being migrated to a new one with MySQL 5. Perhaps that will solve the problem and there’s something going on with the previous MySQL database server. All I know is this is cheesing me off. WordPress normally “just works” and I don’t have to screw around with this stuff.

*sigh*

Every post shows “Uncategorized” and no tags (even tho I’ve tagged them) in the view you directed me to.

HOWEVER – If I go to edit a post the categories are still showing as correctly assigned to the post.

I did a repair of the tables. How do I do a *rebuild* of the tables? phpMyAdmin doesn’t have rebuild – just repair.

I only have three plugins…

Akismet
Wordpress.com stats
wp-phpmyadmin

Turned all of them off. Still not working.

I also noticed that in the post_category column in the wp_posts always has zero for a value. Even with new posts…

I just don’t even get what’s going on here… ??

Oh sorry… good question! I upgraded from 2.7 to 2.7.1 but I’ve been using wordpress since (I think version 2.5).

I was hoping that would help… but so far I see the same issues. All posts in the pages say they’re in “uncategorized”.

kmessinger-

Since upgrading to 2.5.1 I’m not seeing stats.. again…

https://www.codethought.com/blog

Any thoughts?

kmessinger-

I’ve added <?php wp_footer(); ?> to the footer.php file. Hopefully we’ll see some stats soon… thanks!!

I can’t get any stats on my blog either… any ideas? The blog website is:

https://www.codethought.com/blog