Matraex inc. takes pride in sharing our knowledge and experience with the development community. If you find valuable information, please feel free to share with others.
update tablename set zipcode = concat(substr(zipcode,1,3) , ' ', substr(zipcode,4,3) ) where 0=0 and zipcode regexp '^[A-Z][[:digit:]]' and substr(zipcode,4,1) <> ' ' and length(zipcode) = 6 ...
Matraex has moved After 2 years at our office space in the Alaska Building Matraex has decided to upgrade to a new office building. The office space has more space, more private offices and better parking. The new address is, 2210 W Main St Boise, Idaho 83702 Please update all...
A client ran into a corrupted .vhd file for the data drive for a xen server in a pool. We helped them to restore from a backup, however there were some items that they had not backed up properly, our task was to...
Servers fill up with kernels that are not in use. Use this single command to remove them on ubuntu / debian. dpkg -l 'linux-*' | sed '/^ii/!d;/'"$(uname -r | sed "s/\(.*\)-\([^0-9]\+\)/\1/")"'/d;s/^[^ ]* [^ ]* \([^ ]*\).*/\1/;/[0-9]/!d' | xargs sudo apt-get purge -y...
Humans introduce errors as we perform manual tasks. The following list includes only some of the ways that human nature causes issues: Communication: We describe something incorrectly or we interpret something differently than someone intended. This applies to written and verbal communication Input: We type something...
Recently one of our Managed WordPress Services clients came to me to describe a problem with a WordPress site they were working on. If you need in depth help debugging an erro on your WordPress of PHP site, contact us. They were receiving an error: Fatal error: Allowed memory...
Wordfence has some default scans which run hourly. On many systems this works well. In at least one case we found a situation where Wordfence was running hourly scans on some VERY large libraries at the same time on multiple sites on the same...
