Easily generate Let’s Encrypt SSL and install it to your WordPress blog in 30 seconds!


If you’ve noticed, my blog is now in https. Wohoooo! SSL activated after a looong time of being lazy to generate a free SSL and install it in my server. Other hosting providers such as SiteGround, Dreamhost, and other well-known hosting providers out there, providers their customers a one-click Let’s Encrypt SSL installation that you can do in just… one click! Yes, in a few seconds you have your SSL ready.

But what if your web host doesn’t provide a one click Let’s Encrypt installer? Just like mine? It’s still easy to install without going to the command line, using CertBot, blah blah blah (by following the instructions here https://letsencrypt.org/getting-started/). You can just generate an SSL at https://www.sslforfree.com/, verify that you own the domain by using manual verification, copy paste your CRT, KEY and CABUNDLE to your SSL/TLS manager inside your Cpanel, then you’re done.
Continue reading “Easily generate Let’s Encrypt SSL and install it to your WordPress blog in 30 seconds!”

Magento Product Page URL parameters removed mysteriously

If you encountered a weird bug where-in you’re attempting to add utm_source parameters or any URL params after a question mark, then you’re not alone. This happened to me in one of my client’s Magento sites. On the homepage and category pages, I can easily add URL parameters. But in the product page / product view page / single product page, the parameters disappear after the page loads completely. I thought it’s just some sort of javascript bug or a redirect setting in the .htaccess, but it’s not the reason.

Maybe this also happens in WordPress with WooCommerce or other platforms that uses an SEO plugin with Canonical redirect.
Continue reading “Magento Product Page URL parameters removed mysteriously”

JCPAL VerSkin Macos Shortcut Keyboard Cover Black Version (Limited Edition) for MacBook Pro with Touchbar


Here’s a picture of the JCPAL VerSkin Macos Shortcut Keyboard Cover Black Version (Limited Edition) for MacBook Pro with Touchbar, because I couldn’t find anything uploaded online, so I uploaded mine. I can only find the gray version of this cover online. I got this in Frisbee store, Myeongdong, Seoul, South Korea and I think it’s exclusively available there. What’s available online is the gray one, and the application specific keyboard covers for Adobe Premiere, Photoshop, and other prominent software with lots of keyboard shortcuts.
Continue reading “JCPAL VerSkin Macos Shortcut Keyboard Cover Black Version (Limited Edition) for MacBook Pro with Touchbar”

Catacomb Folder in Mac OS

Catacomb Folder in Mac OS with Touchbar

Catacomb Folder in Mac OS with Touchbar
The mysterious Catacomb folder in my MacBook Pro 15″ with Touchbar, is still… mysterious. It appeared in my Library folder last January 6, 2017 at 2:19 PM. I don’t know if this folder appear as well in other MacBook Pro with Touchbar users on the same day at the same time. If this appeared simultaneously, probably it’s a MacBook Pro with Touchbar specific update, but if it didn’t appear on all MBP with Touchbar users, then probably it’s a virus, which is unlikely, but probably.

There are several discussions in Apple forums like this, this, and this and many more, but there’s no definite answer about this Catacomb folder. I can’t even find any documentation about it at Apple.com or any other forums explaining the exact function of this folder and why it is in my Library folder. There’s even a YouTube video that says it’s a virus, and if you google it, you’ll find instructions of how to remove it.

I haven’t remove it yet. Maybe there’s a core function that is associated with it. So I’ll keep it there and just observer what will happen with my MBP in the next few months. It’s there since January and my Mac is functioning just fine.

Google Finance API stopped working as of September 2017

If you’re using the Google Finance Exchange Rate API and it suddenly stopped working, then don’t be shocked. At first, I thought they now require an API key, but that assumption vanished in seconds after I noticed that https://www.google.com/finance/converter was redirected to https://finance.google.com/finance/converter. So if you’re using file_get_contents to fetch the latest forex rates at https://www.google.com/finance/converter, just change it to https://finance.google.com/finance/converter and it will work just fine. No other major changes, it’s just that the API is now in the subdomain.

Maybe there are announcements this month, but I’m not subscribed to any. I googled “google finance forex API september 2017” but it seems nobody posted or blogged about it or asked about it in Stack Exchange. So, that’ it. I just want to share it!

Is Animoji an innovation?


Yes it is. It is awesome and it’s fun. Even if Devin Coldewey of Techcrunch said that it’s dumb and he detest it, it’s not. It’s actually one of the best innovations this 2017, according to me a whole lot of my friends in Seattle and Singapore.

And $1000 for a phone is not that expensive. It’s actually pretty cheap if you sum up the years of innovation and the long sleepless nights of the hardware & software nerds, and those geniuses who have a lot of prefixes and suffixes in their names, who made it possible to be put in your pocket. That small, but powerful device with that so-called neural engine that comes with your phone, for $1000.00, it’s a steal.

You cannot make a phone that sophisticated for $1000 all by yourself, can you? So please stop bashing iPhone haters. It’s the best iPhone yet.

Anyway, Animojis are awesome and I love animoji and I’m excited to pre-order it this October and receive it by November this year! And oh, the girl animoji model (pictured above) in the iPhone X page at Apple.com is pretty, I love you girl, whoever you are!

Magento Batch Update Product Type in MySQL

I just want to share a simple MySQL snippet to batch update product type in Magento. This is a pretty basic SQL query, and I’ll just save it here in my blog so that I can remember what I did to update product types by batch.

I just went to my SQL database via phpmyadmin, click the SQL tab, and run this command:
UPDATE prefix_catalog_product_entity
SET type_id = REPLACE(type_id, 'simple', 'virtual')

If you’re using a custom table prefix, replace prefix with your prefix. Otherwise, just use catalog_product_entity.

This is what I did to change all my product types from simple to virtual. It’s quick and easy and I was able to change it all in 1 second.

First, Magento Connect Reviews are gone, now they are closing

First, Magento Connect Reviews are gone, now they are closing. Yep, you read it right. They will now close the good old Magento Connect and will move everything in the Marketplace. Good news is that they will filter all the extensions and will only retain the ones that are worthy to be retained. You can read more about the announcement here: https://magento.com/blog/magento-news/magento-connect-moving-marketplace

Below is the screenshot of my Magento Connect Manager that I took today. It will be practically useless, but still, you can use it when you have downloaded an extension package from Magento Connect using this freegento.com/ddl-magento-extension.php, or if you have your own packaged module from a Magento extension store.

All good things will come to an end eventually, and one of the pretty good things in my life is Magento Connect. I’m one of the Top 10 reviewers in the world in M1 connect extensions, and it’s sad to see that it’s gone for good.