Posted 3 years ago #
The categories and Tags on my blog are missing. I host two blogs on my site and somehow all the categories are missing. Both sites are having the same problem. The are just showing for uncategorized.
I do have a independent writer who publishes posts. But I don't think she did this or did it on purpose.
Posted 3 years ago #
Should I update to 2.7 to fix this?
Posted 3 years ago #
I just had the same problem, upgraded to 2.7 and still have the problem. The items still exist in my wp-terms data table and WordPress even denies me from adding categories by saying "Category with this name already exists."
Anyone have any ideas?
I had the problem described here and in more depth in this post, all I did to solve this problem was restart my VPS (reboot the server), but this was after I had gone through each plugin one by one and re-uploaded WP which had no affect, it was a mission of trial and error. The problem appeared for no reason inflicted by myself, so it may have been related to something on the server being updated or maintained and that would explain why the same problem occurred on separate blogs hosted on the same server. The restart solved it.
Don't know what if anything you did, but your categories are all showing for me in FF2.
Posted 3 years ago #
Okay - I just upgraded to 2.7 and my categories are gone. No categories and no tags. I can add them in the box, but they do not post.
When I do post my entries, everything comes up Uncategorized.
What's worse, in the category section of the Admin panel I get a series of 1 categories, and as I delete them, they repopulate, so I have three pages of categories called 1 (with no posts) and the categories I tried to add are at the bottom of Page 4.
My old categories are in the SQL database. I'm not sure what to do now.
Might also consider rebuild/repairing your MySQL database tables via phpMyAdmin. Make sure you have a backup before doing that.
Posted 3 years ago #
Thanks, but I haven't the first idea how to do that when the option isn't there in the panel.
I can do one, say wp_terms, but others give me the error:
"The additional features for working with linked tables have been
deactivated. To find out why click here."
And clicking there just gives me gibberish - well maybe others can understand it, but not me.
I'm sorry, I'm a writer, not a computer person. Installing and upgrading WP was simple until I let the automatic upgrade to the work, and now I've lost categories and tags.
Is there another option that doesn't require me getting certified in PHP?
Found this for you with this search:
http://www.google.com/search?q=phpmyadmin+mysql+repairing+a+database
http://paulstamatiou.com/2006/05/31/how-to-quickie-repair-mysql-tables-in-phpmyadmin
If you can't repair tables ask your host for help.
Posted 3 years ago #
Thank you, Michael. The repair was simple enough and not as scary as I would have thought, but it hasn't done anything for the categories.
Darn. Make sure your tables' indexes agree with the indexes described for each table in Database Description.
Posted 3 years ago #
I'll check that now.
Thanks!
Posted 3 years ago #
I am also having a problem displaying more than one category, so the people above are not alone.
I go to the admin Dashboard and open the Categories page. I can add new categories and sub-categories here, but they never show up on the blog page. I am able to edit the original ("uncategorized") category to another name, but that is all.
I "repaired" all of my MySQL tables, as suggested, but this didn't help. By the way, I don't see a wp_category table in my database, but I do see the name of my (missing) category in the wp_terms table as well as the description of the (missing) category in the wp_term_taxonomy table.
These are the 10 tables in my MySQL database:
wp_comments
wp_links
wp_ptions
wp_postmeta
wp_post
wp_terms
wp_termwp_relationships
wp_termwp_taxonomy
wp_metadata
wp_users
I think I'm using 2.7. I installed it through the GoDaddy interface.
Thanks !!
Jbucknoff -- you may have a totally different problem - try to deactivate all your plugins, change to the WordPress Default theme.
Posted 3 years ago #
Thanks Michael.
However, I just installed the blog, so I'm using all of the defaults. (I haven't changed or modified anything.) I haven't installed any plug-ins, either.
The most dynamic thing I did was insert an animated .gif image on my main page, but I doubt if that caused a problem. I also changed the name of the "uncategorized" category to "Main", which sounds better.
Here is my blog, if you want to take a look and see what I mean:
blogs.pmbestpractices.com
Thanks!!
- - Jerry B.
Maybe your problem is that you don't have any posts assigned to those categories.
The hide_empty=0 parameter with the template tag, wp_list_categories(), will display categories with no posts.
Resources:
Stepping Into Template Tags
Stepping Into Templates
Template Hierarchy
Posted 3 years ago #
Okay - it's probably too late for me to figure out the categories in the database tonight, but here's the interesting thing:
I decided to try to keep track of all of these "categories" so I gave them colors so they'd be easier to count - the 1's became Green. The 7's Became Blue, the 63's became Red, and the 414's became Orange. I have a Yellow too, but I don't remember that number.
Not just one number changed, but they all did, like clones.
There are about 40 Green categories now, 7 Oranges, 5 Yellows, 3 Reds, and 2 Blues, and they refuse to be deleted.
My original categories still haven't shown up in the blog, but they, as well as all of my tags, are in the Database.
And your terms_relationships table points to all the posts?
For how those table connect see: http://www.dagondesign.com/articles/wordpress-23-database-structure-for-categories/
Guess you could do Tools->Export, drop your table, install WordPress, then do Tools->Import->WordPress but that's ugly. Make sure you have a database backup before attempting that.
Posted 3 years ago #
And your terms_relationships table points to all the posts?
I'm sorry. I need a visual as to what this is supposed to look like. I can diagram a sentence, but this is totally new to me. I get that they're supposed to link but I don't know where.
Posted 3 years ago #
The table that kinda looks like this?
Full Texts count term_id taxonomy description parent
Edit Delete 1 0 0
Edit Delete 1 0 0
Edit Delete 1 0 0
Edit Delete 1 0 0
Edit Delete 1 0 0
That link http://www.dagondesign.com/articles/wordpress-23-database-structure-for-categories/ was meant to help you understand if necessary how the terms tables were 'connected'.
The term_relationships table links (or connects) the category/tag to the actual posts.
Posted 3 years ago #
That link http://www.dagondesign.com/articles/wordpress-23-database-structure-for-categories/ was meant to help you understand if necessary how the terms tables were 'connected'.
Yes, I understand that part. What I don't understand is how to make them connect.
I seem to be shown parts of an engine and then the finished product of a car, but no idea how to get the engine parts assembled and into the car.
Okay sorry. Might try the export and import route I suggested.
Posted 3 years ago #
Guess you could do Tools->Export, drop your table, install WordPress, then do Tools->Import->WordPress but that's ugly. Make sure you have a database backup before attempting that.
Export my database (from WordPress). Drop the Table (from MySql), Install WordPress (and never ever use the automatic upgrade again), and from WordPress, Import my database?
Alright - words, guys. I appreciate that you think I'm smart enough to fill in the holes, but this is scary thing for me. We don't all live with WP, and an errant keystroke wipes out almost four years of blogging, which I'd rather not do. I'll check back in a few hours.
If you don't have a database backup, then install a plugin that will do that so you will be protected no matter what.
Posted 3 years ago #
No, that I do have. I mean I have to go to work for a few hours, so I won't be able to do this until I get back.
*grin* I need to use my words, too.
Posted 3 years ago #
Maybe your problem is that you don't have any posts assigned to those categories.
Bingo!
Michael, thanks!
I think that the WP documentation should mention that new categories do not show up until after the first post is added. It may seem logical to the developers of the tool, but they should still spell it out -- don't assume that it's self-evident.
- - Jerry
Posted 3 years ago #
And now I have 73 categories: 40 Green categories now, 7 Oranges, 5 Yellows, 3 Reds, and 2 Blues, and they refuse to be deleted.
And no term_relationships table.
Now what? Reinstall the back up?
If you have no term_relationships table, then something bad went wrong in the upgrade. Yes I would think about restoring a backup from before the upgrade. Might also repair and optimize the tables before doing the 2.7 upgrade.
BTW, you don't have to do anything to the files, meaning you don't have to reupload the 2.7 files. Just restore the pre 2.7 backup, then visit wp-admin/upgrade.php.
Posted 3 years ago #
Nothing.
This topic has been closed to new replies.
