I’m smart and get stuff done, have an over-zealous attention to detail and take pride in my work. If I can help an organisation to grow and flourish during my time working with them, then I’ve achieved my goal. Maybe I’m your cup of tea, maybe not. That’s OK. Like dating, let’s get the deal breakers out of the way quickly. Then we can move on to the good stuff. Don’t take my word for it. This morning my current client brightened my day with the following: “Great piece. And the news changes look amazing. Seriously man, your input has…
I picked the wrong day to give up sniffing glue! Been building a new WordPress site and I was trying to migrate it to a new domain when something went very wrong. I had a backup before you ask, but when I tried to restore it, things went tits up Here are the results of the MySQL CLI alchemy: (edited to just show errors)
mysql> source /var/www/html/.../updraft/wp.db
ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x8E\x89</...' for column 'option_value' at row 125
ERROR 1067 (42000): Invalid default value for 'user_registered'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_users' doesn't exist
ERROR 1067 (42000): Invalid default value for 'comment_date'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_comments' doesn't exist
ERROR 1067 (42000): Invalid default value for 'link_updated'
ERROR 1067 (42000): Invalid default value for 'post_date'
ERROR 1146 (42S02): Table 'wp_xxxxxxxxx.wp_posts' doesn't exist
It’s not as bad as it looks; there are two errors basically • Attempted insert of string with 4-byte value fails • Invalid default value. This turns out to be a date value of '0000-00-00 00:00:00'…
The H2O webserver configuration file (h2o.conf) is YAML animal. As I learned the hard way, spaces used to indent in YAML are super important. Notes re YAML syntax: as it pertains to h2o.conf: https://h2o.examp1e.net/configure/syntax_and_structure.html#yaml_alias How to validate your YAML: http://www.yamllint.com/
Not familiar with the game? It’s fun but once you learn the key strategy (attempt to roll as many sixes as you can) there’s not much room for creativity. It then just comes down to luck. You do, however, need a good playing name 🙂 Yahtzee has been cited as a precipitating factor in a case of domestic violence and as the motive for at least one murder. I pipped him at the post, it all came down to the last game where he dropped his topping only scoring 53 in the top half. A nice way to spend the…
It’s always the little things. Went to the local supermarket this morning to pick up some supplies and scored a tonne of bargains. Discount stickers everywhere I tell you. In the basket Pork Chicken Bologne Pasta Sesame seeds Lettuce Tomato (x2) Kale (x4) Okra Carrot Broccoli Bean sprouts Ginger Limes and a can of coke All for the princely sum of THB 445 ~ USD 13.50 Max Valu indeed! Amazing Thailand
Showing my age now. Time to work on building up my 2nd Rasberry Pi. This time I’m going to install Retropie and see if I can get one of my old games up and running. • Step 1 – Download Retropie
-rw-r--r-- 1 root root 641640647 Nov 17 22:44 retropie-4.3-rpi2_rpi3.img.gz
It’s 612MB so will take a while. Enjoy a nice cup of tea while you wait and read the installation guide. Don’t attempt to download a file this large via HTTP. Timed out for me, so I used FTP instead. Downloaded via my webhost using wget, copied into my FTP home directory then used FileZilla to download from…
Thought I should keep track of the apps I’m installing on my Rasberry Pi. • Dolphin (file manager) • vim (editor) • PHP 7.0 • nginx (web server ; removed apache2) • pinta (graphics) • VLC media player • ufw (uncomplicated firewall) • x11-apps (xclock, xcalc, etc) Update nodejs curl -sL https://deb.nodesource.com/setup_7.x | sudo -E bash – sudo apt-get install -y nodejs Networking Plugged in the ethernet cable and it just worked! Nice one. However we no longer have eth0? It’s now exnb827eb071dfd and it isn’t configured via /etc/network/interfaces Explanation found here: Predictable Network Interface Names are not new, but…
I picked up a few Rasberry Pis from Amazon.com and I’m glad I waited a while so I could get the Pi 3, which seems to be a step up from its predecessor in terms of performance. Amazon.com now delivers to Thailand and includes taxes in the shipping so there’s no more to pay. This is a huge step forward as previously dubious import charges were levied by the courier. Thankfully a thing of the past I can now browse Amazon with confidence. As a bonus, it only took 3-4 days to arrive at my doorstep. Yeah! My total was…
Had a wander around the web in the wee hours of this morning and came across Emmet which I thought looked interesting so I downloaded npp to get it going. I’ve been hand-coding my HTML for 18 months now which has been a great learning experience. It’s getting a little tiresome now and I need some help 🙂 Opened and installed with Wine and guess what? It just worked! Amazing. Next I had to get the plugin manager going which is no longer bundled with npp. Grab it here Note the C:/Program Files folder is under the (hidden) .wine folder…
Thought I’d give one of these a go, as I love the one from the joint in Soi 11. Using the recipe I found here. Ingredients • 12 red potatoes, each cut into 6 pieces • 1/2 cup chopped bacon ends, visible fat trimmed • 1/4 cup white vinegar 1/4 cup cider vinegar • 1/4 cup white sugar • 1 teaspoon salt • 1/4 teaspoon ground black pepper • 1/2 cup light sour cream • 1/4 cup mayonnaise • 1 small red onion, diced • 1 tablespoon chopped fresh parsley • 1 tablespoon chopped fresh chives Recipe Prep: 20 m…