I am migrating a wordpress site from QTranslate-X to WPML (2 multi-lingual plugins).
In the migration, all my posts that belonged to a given category (healthy in English, sain in French) were correctly assigned in English but the link was lost in French.
I wrote a SQL script to determine the list of French post IDs from the English posts that belong to the healthy category. That gave me a list of IDs (101, 102...).
I then proceeded to run the following INSERT statements (the first number is the object ID aka the post ID, the second number is the category ID, and the last one is the order for the given object). This is well described here:
INSERT INTO `wp_term_relationships` VALUES('29017',29411,0); INSERT INTO `wp_term_relationships` VALUES('29023',29411,0); INSERT INTO `wp_term_relationships` VALUES('29031',29411,0); INSERT INTO `wp_term_relationships` VALUES('29035',29411,0);
So on so forth... There are 134 rows in total. The number adds up to what the English category contains. So far... so good! The website behaves correctly. Great.
Except for... one little detail. The count of posts in the category table in the backend shows 0 (zero):
Is this something I should worry about? Did I forget to update something else?