Home   Best Sellers   Blogging   Coding & Design   Technology   SEO   Travel & living   Career   Videos   Tips   Online tools     
Home  »     »     »     »  Understanding Wordpress Db structure - Wordpress category - taxonomy issue

Understanding Wordpress Db structure - Wordpress category - taxonomy issue

Friday, April 20, 2012

How to solve Wordpress category - taxonomy issue

There was some problems which happened when old wordpress table was integrated with the New wordpress Db, the Categories, tags and links were not displaying. When i googled for this there was some interesting posts, which can be referred to solve this issue. All the things you see  are taken from different sources.

Provided below are just links to the actual source. You can refer this to get an idea about this and solve the issue yourself.

Understanding Wordpress table structure

wp_terms : The categories for both posts and links and the tags for posts are found within the wp_terms table.

wp_term_relationships : Posts are associated with categories and tags from the wp_terms table and this association is maintained in the wp_term_relationships table. The association of links to their respective categories are also kept in this table. 

wp_term_taxonomy: This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.

Read about WordPress wp_term, wp_term_relationship, wp_term_Taxonomy

Wordpress DB relation ship diagram

 A Basic Explanation of WordPress Taxonomies
 WordPress comes with 3 taxonomies, post tag, categories, link categories.

 Post Tag: acts like a label, attached to a post.

 Category: acts like a “bucket” in which we put  posts, are often hierarchical. Posts can live in multiple categories.

 Link Category: acts like a label, attached to a  link.

 Each tag or category you create is a “term” within that taxonomy. For  example, if you create a category “Movies” (in our site about  entertainment), “Movies” becomes a term within the category  taxonomy. Read More

Share this!

How to link to this page?
If you wish to link to this page from your website, simply Copy and paste the above HTML code to your web page. It will appear on your page as:
Understanding Wordpress Db structure - Wordpress category - taxonomy issue.

comments powered by Disqus

This Weeks 7 Popular Posts

Subscribe to Recent Posts by Email
Stay connected to CROZOOM with regular Email notices of new Techie articles and IT Jobs. Updates will be delivered to your Inbox as soon as they are posted online.

Enter Your Email Address:  

Delivered by FeedBurner   RSS Feed

Search this Blog   

Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »