Babble

Nasty Malware in Email with Subject: "Stop Spamming Me"

This morning I received an email with the subject: “Stop Spamming Me” so, being a good citizen of the interwebs as I am, I thought to look deeper into it and maybe even respond to apologise and explain that I never intentionally spam anyone. The content of the email was as follows: “stop sending me…

Read More

Update all URLs in database except in serialized data fields

Updating URLs in the database can cause problems if you include those in serialized arrays. These queries leave serialized arrays untouched: UPDATE wp_options SET option_value = REPLACE(option_value, ‘http://devdomain.local‘, ‘http://livedomain.com‘) WHERE option_value NOT LIKE ‘%{%’; UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ‘http://devdomain.local‘, ‘http://livedomain.com‘) WHERE meta_value NOT LIKE ‘%{%’; UPDATE wp_posts SET post_content = REPLACE(post_content, ‘http://devdomain.local‘, ‘http://livedomain.com‘)…

Read More

Upgrading from Pagely Multi Edit to Multiple Content Blocks by Trendwerk

Pagely  Multi Edit is still causing problems on several of our sites but can be replaced by Multiple Content Blocks by Trendwork. Template Change multieditDisplay(‘RightColumn’); to the_block(‘right column’); Database In wp_postmeta change meta_key multiedit_RightColumn to _mcb-right-column This can be achieved by running the following query for example UPDATE wp_postmeta SET meta_key = REPLACE(meta_key, ‘multiedit_RightColumn’, ‘_mcb-right-column’);…

Read More