In this super casual Watch Me Work Live Stream, I open the surprise box from Regular Labs, do some more replacing and finding across multiple Joomla articles and ACYmailing Newsletters using tips from Peter van Westen on searching with regular expressions, look at Vinny Hebert's recommendation of using Notepad++, and start making plans for the bank robbery with Andy Badwool.
00:00:00 โ Intro & What's in This Stream
00:00:31 โ Opening the Regular Labs Surprise Box
00:11:21 โ DB Replacer Setup & Clear Button Demo
00:14:55 โ Tutorial: Using Regex to Replace 143 Signatures
00:22:05 โ Fixing "Unable to Load User ID 42" Error
00:42:19 โ IMPORTANT: Backup Your Site First!
00:44:01 โ Rebranding "Cybersalt" in AcyMailing (984 Rows)
00:60:05 โ Notepad++ Deep Dive for Joomla
00:73:21 โ What's Next? 3 Upcoming Streams & Wrap-Up
Summary
1. Stream Kickoff & Surprise Box:
Tim opens his second Twitch livestream and reveals a surprise package from Regular Labsโit's a hoodie!
2. New DB Replacer Feature โ Clear Button:
Tim highlights a recently added feature to DB Replacer: a clear button that resets search fields, making repeated replacements much faster.
3. The Problem:
Update James Snyder's Signature: Tim needs to update an author signature across 143 articles, but the text varies slightly between them.
4. Peter's Regex Solution:
Community member Peter van West suggests using Regular Expressions in DB Replacer to match all signature variations in a single search.
5. Regex Search Success:
The regex pattern finds all 143 rows, and Tim successfully replaces every signature in one operation.
6. Fixing "Unable to Load User ID 42" Error: Tim troubleshoots and fixes the persistent user ID error by targeting articles where category_id=86 AND modified_by=42, finding 194 rows and resolving the issue.
7. Critical Backup Warning: Tim emphasizes the most important rule: always backup your site before using DB Replacer. One wrong search can break everything.
8. Rebranding & Newsletter Cleanup: Tim rebrands "Cybersalt Communications" to simply "Cybersalt" and removes "Pastor at Westside Bible Church" from 984 newsletter archive entries using DB Replacer on the AcyMailing table.
9. Notepad++ Deep Dive: Following Vinnie's recommendation, Tim explores Notepad++ features for Joomla work including macros, spell check, syntax highlighting, and Vinnie's five favorite tips.
10. Upcoming Streams & Wrap-Up: Tim announces three upcoming streams featuring Mary (Joomla Maps), Peter (Regular Expressions deep dive), and Vinnie (Notepad++ advanced tips), then ends with a blessing and sign-off.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment