Have you ever wanted to find and replace words or other code in and across multiple Joomla articles (or other Joomla extensions) all at once? In this 85 minute "Watch Me Work Hangout" live stream (a much more casual genre than my edited and produced tutorials) I find and replace text and code across a bunch of Joomla articles - and then I do more of the same in my ACYmailing newsletter archives. Here are the links mentioned in this Live Stream:
00:00:00 โ Intro: Relaxed Twitch Work Stream
00:03:05 โ Work on Cybersalt.org (19k Articles)
00:07:54 โ Use DB Replacer (Backup First!)
00:10:50 โ Fix User ID 42 Error
00:17:21 โ Search & Replace Live Demo
00:30:03 โ Store Replacements in Notepad
00:35:08 โ Troubleshoot Missing Search Results
00:45:55 โ Refresh & Save Tips
00:55:19 โ Bulk Replace 11 Articles
01:02:20 โ PHPMyAdmin Deep Dive
01:07:58 โ AcyMailing: 994 Newsletters
01:10:58 โ Remove Old Pastor Signature
01:17:52 โ Add Hidden Marker for Future Edits
01:22:00 โ Handle Multiple Signature Variations
01:25:30 โ Follow on Twitch & YouTube
Summary
1. First Twitch Stream Introduction:
Tim kicks off his first Twitch stream, explaining the formatโhanging out and working on real Joomla sites while chatting with the community.
2. Cybersalt.org Overview:
The site has over 19,000 articles, presenting unique maintenance challenges when it comes to bulk updates across legacy content.
3. The Problem:
Updating Author Signatures: Tim needs to update an author signature across 400+ articles, but variations in formatting (fonts, URLs, line breaks) make a simple search-and-replace tricky.
4. Tool:
Regular Labs DB Replacer: The DB Replacer extension is introducedโpowerful but dangerous. Tim issues a critical warning: always backup before using it.
5. Fixing "Unable to Load User ID 42" Error:
Before the main task, Tim troubleshoots a user ID error and removes old spam protection code from a problematic article.
6. Live Demo:
Search & Replace: Tim runs live tests showing how DB Replacer works, including the importance of refreshing, saving, and being patient with the tool.
7. Troubleshooting:
Why Won't It Find the Text?: When DB Replacer fails to find certain text variations, Tim investigates, discovering hidden characters and formatting differences.
8. Bulk Replace Success:
After refining the search parameters, Tim successfully updates 11 articles at once with the new author signature.
9. PHPMyAdmin Deep Dive:
To find goofy characters breaking the search, Tim dives into PHPMyAdmin, examining database tables directly for hidden formatting issues.
10. AcyMailing Archive Cleanup & Wrap-Up:
Tim discovers 994 newsletter archives needing signature updates, uses DB Replacer on the AcyMailing table, shares an advanced trick for adding hidden markers for future replacements, and wraps up with a call to follow on Twitch and subscribe on YouTube.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment