Skip to main content

Understanding Wordpress Db structure - Wordpress category - taxonomy issue

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

Popular posts from this blog

Payback Points - How to redeem - How to merge multiple payback accounts - Block Payback card - Payback customer care

How to apply for a new ration card and what are the documents required?

List of documents required for new ration card application in Kerala and how to apply


Application for a new ration card should be addressed to Taluk Supply Officer (TSO) / City Rationing Officer (CRO) of applicant's residing area.

Primary document required are Residence certificate, Income certificate and incase the applicant's name is in another ration card then he/she should submit the reduction certificate ontained from previous TSO / CRO as proof for removing his/her name from old Ration card.

You can get the new application from your currently residing Taluk Supply Office.

Joomla and Forum Integration - Integrating Forums to Joomla

Joomla is one of the most popular CMS opensource packages. It is very easier to develop website's using Joomla. You just need to download Joomla package from Joomla's Official website www.joomla.org  and install it on your domain and later adding customizations to templates and feature and Your website is ready :). Now a days most websites provides a forum section for it users for discussing various article topics, gathering opinions etc.



Following are some best know forum opensource packages which can be integrated with Joomla and create a new forum experience for users


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 »
Member
Search This Blog