trojanloy

I’m having the same problem after upgrading from 1.5.2 to 2.1. I described my problem in detail on my blog:

https://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html

I also started a new support ticket, since this seems to be related to a separate problem I’m having regarding Posts, and I wanted to address both of them in the same ticket:

https://www.ads-software.com/support/topic/105196

I had the same problem, and did the SQL query listed on this page…

https://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html

…and it worked fine, and almost instantaneously. My database has 129 categories, 14,461 posts and 107,302 comments. So I’m thinking that if the query is entered properly, speed shouldn’t be an issue.

Also visit that same link for a solution to the categories problem.

The above post stripped the backticks out of my SQL query. Please visit https://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html to get the properly formatted query.

I had this same problem, but was able to solve it… I describe how here:
https://www.brendanloy.com/2007/02/wordpress-21-upgrade-problems.html

Basically, to solve the comment_count issue, I ran the following SQL query in phpMyAdmin:

UPDATE wp_posts SET comment_count = (SELECT COUNT(comment_post_id) FROM wp_comments WHERE wp_posts.id = wp_comments.comment_post_id)

My database has 129 categories, 14,461 posts and 107,302 comments, and the query ran almost instantaneously, so speed should not be an issue.

As for categories, that can be solved without delving into phpMyAdmin. In the WordPress interface, simply create a new post and check off every single category. Save the post. Voila, you’re done. All the categories will update their category_count field. Admittedly, it was a little annoying to manually check off 129 categories, but it was doable, and it solved the problem in one fell swoop.

Darn it, I keep forgetting that HTML code doesn’t work here…

ladydelaluna, my comments about being a man were intended as <i>self</i>-deprecating, not making fun of <i>you</i>, and anyway they were purely good-natured, as I thought the smiley-faces would have indicated. I’m not sure what I said that offended you so much. I apologize for it, whatever it was. But I would humbly suggest that you consider following what Wikipedia calls the “assume good faith” policy online. Since there’s no way to tell people’s tone of voice online, it’s easy to misinterpret people, so I think it’s generally a good idea to assume that people don’t mean anything bad unless they clearly demonstrate otherwise. I certainly didn’t mean to suggest that you said or did anything wrong. I was just trying to clarify the nature of our problem, and then make a humorous comment about myself.

ladydelaluna, that doesn’t describe what happened to me, and it doesn’t sound like it describes what happened to ryanglenn or suexID, either. My database was repeatedly, spontaneously changing the data fields that control which theme is active, setting them to “default,” without any action whatsoever on my part. I would then reactivate the correct theme through the WP interface, and it would work fine for a while, but then it would spontaneously change to a different theme again. No FTPing involved. The only time where FTP became involved was in my workaround — if you rename the the desired theme <i>to</i> “default,” and then activate it as such, this weird spontaneous-MySQL-change issue, whatever is causing it, will stop creating problems because it will be “switching” to the theme you’re already using.

Trust me, I wouldn’t be posting to the forums if the solution was as simple as activating my theme. I’m a man, and we don’t like asking for directions :), so I always try the obvious steps, usually about five times each ?? before finally giving up and realizing that I need to ask for help…

When I try to make changes to the “Allow File Uploads” options on the Miscellaneous Options page, the changes simply will not “take.” I hit Update Options but they don’t update, and I still can’t upload files. Argh! I’m using 1.5.2. Any ideas? Could it be permissions or something? I’ve tried all different combinations of settings, but no matter what I try, WordPress simply does not register that I’ve done anything with the “Allow File Uploads” tab. It just reverts right back to everything being blank!

I figured out a workaround: rename the “default” directory to “kubrick,” and rename the theme you actually want to use to “default.” That way, when the MySQL database for whatever reason automatically switches the “template” and “stylesheet” rows on the “wp_options” table to the word “default,” they’re still pointing to the right theme. Works like a charm!

(The only side effect: you, and potentially other users of your blog, will need to clear your cache/cookies after the change takes place, because initially the browser may incorrectly believe it has already loaded the “default” stylesheet, when really that is the Kubrick stylesheet. If that makes any sense. Anyway, if you do this and your blog looks funny, clear your cache/cookies.)

I also have some funky auto-SQL action going on…

https://www.brendanloy.com/2006/04/cnn-auto-blogging-working-again.html

…but I don’t think that can be the culprit, because that runs an SQL query every five minutes, and it takes the theme an hour or more to deactivate itself. Presumably, if my SQL queries were somehow messing things up, it would happen within 5 minutes, the first time the query runs.

Hmm, let’s see…

Spam Karma 2.2 r3
Batch Categories .91
Custom Query String 2.6
Paged Comment Editing 0.4
Fold Category List 1.0b4
Get Custom Field Values 2.1
Live Comment Preview 1.7
Post editor enhancer for WordPress 0.1.1
WP-PageNavi 2.0
Better Feed 1.1

Er, correction, it’s the Batch Categories plugin that I can’t get to work properly on WP 1.52. It works insofar as the Batch Add/Remove feature, but the individual post-by-post category add function does nothing.

Enhanced Post List doesn’t work, either, but that’s not relevant to this question. ??