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:00 โ Introduction & Sponsor Message
00:00:32 โ Problem Overview
00:01:00 โ Initial Diagnosis & Reinstallation Attempt
00:02:08 โ Database Investigation Using phpMyAdmin
00:02:48 โ Running the SQL Fix Command
00:03:21 โ Modifying & Executing the SQL Command
00:03:58 โ Verification & 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.
๐ Quick Fix Extension Available
If you are experiencing missing articles in the Article Manager after migrating to Joomla 4, there is now a faster and easier solution available. Instead of running manual SQL queries, you can use this extension which automatically applies the required database fixes.
๐ Download and instructions:
https://github.com/cybersalt/cs-quirky-db-fixes
This tool was created to simplify the repair process and help restore missing articles more quickly and safely.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment