Valet+ 500 Error Bricked PHP, pecl extension troubles apcu, apc

Starts with a 500 nginx error, three days ago, when settling down to do a quick update to a wordpress theme. What have I learned or clarified so far? Valet is a lightweight Mac development environment for Laravel, which is a php framework based on the model–view–controller application approach. Valet+ is a fork of Valet … Continued

Ripping Encrypted DVDs

Client wants his DVD published to his video streaming website. First I worked for a while with effmpeg, but kept getting errors. ffmpeg -i concat:VIDEO_TS.VOB\|VTS_01_0.VOB\|VTS_01_1.VOB -vcodec libxvid -q:v 5 -s 640×480 -aspect 640:480 -r 30 -g 300 -bf 2 -acodec libmp3lame -ab 160k -ar 32000 -async 32000 -ac 2 ~/Documents/Clients/Client/test.mp4 [ac3 @ 0x7fae3c027400] exponent 25 … Continued

sshfs requires libfuse.2.dylib error with iExplorer

iExplorer is a great app with which I can load my iPhone as an external disc. It was crashing after OSX upgrade with following issue: sshfs requires libfuse.2.dylib error with iExplorer. I was able to solve it by installing osxfuse. With homebrew: brew cask install osxfuse

Search all WordPress Database for String

Checking all wp_posts for a specific string: SELECT id, post_title, post_status, post_type, SUBSTR(post_content, LOCATE(‘your search string’, post_content) -1, 100) FROM wp_posts WHERE locate(‘your search string’, post_content) > 0

System Cron, Crontab, Cron Service, WordPress, Oh My

Client needs to automatically import data from a Google spreadsheet into a Custom Post Type. I wrote up a quick (largely borrowed) python script to convert to Google Spreadsheet to a CSV file with the desired headers. Found this pro plugin from Smackcoders called WP CSV Import Pro, which can run the CSV to CPT … Continued

Backing Up Trellis Site to AWS s3 Bucket

As a freshman in University, I’m still flying by the seat of my pants. Backing up website database and files to Amazon s3 as Ben Word does seems like a more interesting approach than using a service like Updraft Plus, Jetpack or Infinite WP, so I’m giving it a go. Beginning with Ben’s configuration … Continued

Ansible Couldn’t Connect to the Database

Trellis, as of sometime in 2016, simplified the way users it generates the MySQL database and user: USER will be named example_com DATABASE will be named example_com_environment If you, as I had done, end up changing site name in one place or another you may get a message that Ansible couldn’t connect to the database, … Continued