If there are no articles showing in the Articles Manager after you migrate from Joomla 3 to 4, this might be the fix.
00:00 - Introduction and Sponsor Message
00:32 - Problem Overview
01:00 - Initial Diagnosis and Reinstall
02:08 - Database Investigation with phpMyAdmin
02:48 - Running SQL Command to Fix the Issue
03:21 - Modifying and Executing the SQL Command
03:58 - Verification and Conclusion
Summary
Introduction and Sponsorship: Tim Davis introduces the video and mentions sponsors CyberSalt's Joomla training cohort and mysites.guru.
Problem Overview: After migrating a client's site from Joomla 3 to Joomla 4, the articles were missing in the Article Manager in the backend but appeared on the frontend.
Initial Diagnosis: A missing workflows table was identified post-migration; reinstalling Joomla created the table but didn't resolve the missing articles issue.
Database Check with phpMyAdmin: Tim opens phpMyAdmin and selects the relevant Joomla database.
Investigating Workflows Table: Filtering for tables containing "work," Tim finds the workflows table is missing the necessary row.
SQL Command Introduction: Tim shares the SQL command provided by Brian Teeman to insert the missing row into the workflows table.
Preparing the SQL Command: Tim highlights the need to replace the placeholder prefix in the SQL command with the actual database prefix.
Executing the SQL Command: After replacing the placeholder, Tim runs the SQL command in phpMyAdmin.
Verification: Returning to the Joomla backend, Tim confirms that the previously missing articles now appear in the Article Manager.
Conclusion and Thanks: Tim thanks Brian Teeman for his help and advises viewers facing the same issue to follow this fix, concluding with a reminder to subscribe and a closing message.
Please send any feedback or bug reports or queries to;
Contact Tim Davis βΊ
Joomla Training Cohort βΊ https://cybersalt.com/jtc
Add comment