If after migrating from Joomla 3 to Joomla 4 your articles show in the front end of the site and are listed in the content table of your database BUT some or all of your articles are not showing in the article manager in the admin area of your site, this might be the fix you are looking for.
If this fix does not work for you, try the video at (No Articles Appearing in the Article Manager after Migrating to Joomla 4) which solves a very similar problem in your J4 database.
00:00:00 โ Intro & Sponsor
00:00:32 โ Issue: Articles Missing in Article Manager
00:01:04 โ Root Cause: Missing Workflow Associations
00:01:39 โ Opening phpMyAdmin
00:01:50 โ Running the SQL Fix
00:02:11 โ Customizing Table Prefix
00:02:44 โ Verifying the Results
00:02:50 โ Wrap-Up & Resource
Summary
Introduction and Sponsorship:
Tim Davis introduces the video and mentions sponsors CyberSalt's Joomla training cohort and mysites.guru.
Issue Description:
The video addresses the issue of articles not appearing in the Article Manager after migrating from Joomla 3 to Joomla 4, even though they appear on the front end and in the database.
Possible Cause:
The problem might be due to missing references in the workflow associations table in Joomla 4.
Solution Overview:
To fix this, you need to recreate the missing references in the workflow associations table.
Accessing Resources:
Tim provides a link to a Joomla forum discussion and an SQL command that can be used to solve the issue.
Accessing phpMyAdmin:
Tim demonstrates how to access phpMyAdmin through the web hosting control panel.
Locating the Table Prefix:
He shows how to find the table prefix, which is necessary for customizing the SQL command.
Running the SQL Command:
Tim explains how to copy and paste the provided SQL command into the SQL tab in phpMyAdmin.
Customizing the SQL Command:
He shows how to replace the placeholder hash and underscore with the actual table prefix in three places within the SQL command.
Verifying the Solution:
After running the command, Tim notes that you should see the results, and any missing articles should now appear in the Article Manager.
The SQL command from this video:
INSERT INTO #__workflow_associations (item_id, stage_id, extension) SELECT c.id as item_id, '1', 'com_content.article' FROM #__content AS c WHERE NOT EXISTS (SELECT wa.item_id FROM #__workflow_associations AS wa WHERE wa.item_id = c.id);
๐ Quick Fix Extension Available
If you're dealing with missing articles after migrating to Joomla 4, you can now use a tool that automates the SQL fix instead of running queries manually.
๐ Download & instructions: https://github.com/cybersalt/cs-quirky-db-fixes
This extension was created to simplify the process and get sites fixed faster.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment