f 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 - Introduction and Sponsor Message
00:32 - Issue Description: Articles Not Appearing in Article Manager
01:04 - Identifying the Problem: Missing Workflow Associations
01:39 - Accessing phpMyAdmin
01:50 - Running the SQL Command
02:11 - Customizing the SQL Command
02:44 - Running the Command and Verifying Results
02:50 - Conclusion and Additional Resources
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.
Please send any feedback or bug reports or queries to;
Contact Tim Davis ►
Joomla Training Cohort ► https://cybersalt.com/jtc
Add comment