Magento 2 Wrong Product Canonical Url
Unfortunately Magento 2 can add the wrong product canonical tag containing a 301 redirect URL. In the following file and method it can be fixed:
(more…)MySQL: Multiple Aggregate SUM Criteria On a Single Join
Below is an example of two aggregate SUM statements on a single join with
different criteria. One gives the total downloads count of an user on all days,
the other filters the same sum on past 30 days.
Fix Wordpress WooCommerce Slow SUM Queries
The query below tends to be very slow in Wordpress when WooCommerce has a lot of data. In some cases it takes up to 10 seconds.
(more…)Magento 2 Status Processing for Check / Money Order Payments
In Magento 2 you can use the admin option New Order Status within Stores ->
Configuration -> Sales -> Payment Methods. Unfortunately it is not possible to
change the status to Processing for Offline Payment Methods such as Check /
Money order with the code name checkmo. By default you are stuck with
Pending but this can be fixed using the code in this article.
How to Fix Ankle Pain on USD Aeon Skates
Recently I bought the USD Aeon 80 skates. I truly love these skates because by putting a full rocker setup on them I can enjoy Freestyle and Aggressive at the same moment at the park. They feel close to my dedicated Freestyle skates (FR Igor) due to the same wheel size. Though the USD skates have an issue..
(more…)Gmail Not Showing HTML Image
When gmail is not showing a html image, make sure to check the following things.
(more…)Search in All Access Log Files on Web Server
At times it is useful to search for a pattern in all domains their access log files on a web server. This can easily be done by combining the commands find and grep without complicated script loops.
(more…)Find Files by Content Using Grep and Zip Them Automatically
The Linux script in this article shows how to search files by content using grep and archive them automatically using zip with relative paths from the working directory defined.
(more…)Better Apache2 Config Test for Missing Log Folders
By default the command apachectl configtest does not check whether the
defined log folders exist. This causes the config test to give positive
feedback about valid config files, but when restarting apache2 it might fail
due missing folders.
Checklist Website Migration on Linux Web Server with Apache2
This article covers the checklist I use when migrating a website on a Linux web server. It aims at a downtime of 1-5 minutes.
(more…)
Older
Newer