After migrating a clients content from K2 into Joomla's core content, the newly created tags were missing from the batch processing tool in the article management area. This video shows the cause and the cure
00:00 - Introduction and Sponsor Message
00:36 - Migration from K2 to Joomla Core
01:08 - Missing Tags Issue
02:12 - Investigating the Database
03:49 - Testing a Solution
04:27 - Applying the Fix with DB Replacer
06:26 - Verifying the Fix
07:06 - Final Adjustments and Conclusion
Summary
Introduction and Sponsorship: Tim Davis introduces the video and mentions sponsors CyberSalt's Joomla training cohort and mysites.guru.
Migration Issue: A client migrated from K2 to Joomla core, but encountered issues with tags not appearing in the batch options.
Missing Tags: During the batch process, tags created during migration did not appear despite existing in the tags component.
Database Investigation: Used phpMyAdmin to investigate the tags table, noticing differences between tags that appeared and those that did not.
Identified Differences: Tags with a parent ID of zero and empty parameters were not showing up, while those with a parent ID of one did.
Testing a Solution: Edited a sample tag manually to match the format of showing tags, which confirmed the parent ID change made it appear.
Using DB Replacer: Employed DB Replacer from Regular Labs to update the parent ID for all tags from zero to one.
Applying the Fix: Replaced the parent ID values efficiently using DB Replacer, ensuring all tags were correctly formatted.
Verifying Changes: Checked the tags table to confirm all updates, then verified in Joomla that the tags now appeared in the batch process.
Final Adjustments: Reverted the parent ID for the root tag to zero and concluded with advice on investigating database discrepancies for similar issues.
Please send any feedback or bug reports or queries to;
Contact Tim Davis βΊ
Joomla Training Cohort βΊ https://cybersalt.com/jtc
Add comment