I needed to change a record in a customer table to be inactive if they hadn't received a delivery in the last 3 months. I got stuck with "Error Code: 1093. You can't specify target table 'customers' for update in FROM clause" UPDATE customers c1...
IT Tips
CakePHP 3.x Google No Translate Meta Tags
Just had a page think it was french despite having So to get CakePHP to make the recommended meta tags as listed here => https://stackoverflow.com/a/3130857/9230077 <?=...
Example Curl POST request for XML document from CakePHP
This is an example of using the curl command to request a CakePHP URL and post form data to it. It uses xmllint to format the output and highlight (under MacOS) to colorize the output #!/bin/sh # save as curlIt.sh curl -s \ -d...
Brew Wine on MacOS Ugly Fonts
Wine 3.0.1 MacOS 10.13.5 If you have recently done a brew install wine and found that suddenly your fonts are ugly. A work-a-round is: to remove the current version of XQuartz (2.7.11) and downgrade to XQuartz-2.7.9.dmg install the wine stable version...
Ubuntu 18.04 Display and Resolution problems VMWare VSphere Client v 5.5 Console
Can't seem to get Ubuntu 18.04 working on VMWare Console Mouse pointer is offset in the VMWare VSphere Client Console. Things just not working properly, going fullscreen in the console and the resolution was pegged at 1024x768 despite having tried open-vm-tools &...
Class XMLReader does not exist
Just on the Joomla 3.8.8 "You have post-installation messages" page and when I click the "Read Messages" button I get taken to a page with an error message: At the moment I have plenty of XML modules installed but not the one I need: php -m |...
PHP7.2 Image Magick
On a brew installed php7.2 on my MacOS 10.13.5 I get an error when running /usr/local/php5/bin/php from the command line: Warning: PHP Startup: Unable to load dynamic library '/usr/local/php5/lib/php/extensions/no-debug-non-zts-20170718/imagick.so' (tried:...
Get the Ubuntu Update Notification Text After Login
If you run this: You will get the output regarding available updates in Ubuntu similar to the following 130 packages can be updated. 92 updates are security updates. Ubuntu Version...
EQualLogic Array Won’t load Java Admin Applet in Browser
Tried to load the admin web page for an EqualLogic PS 6100 series array and got attempted to open sandboxed jar The fix requires editing the java.security file and removing MD5 from the following line jdk.jar.disabledAlgorithms=MD2, RSA keySize < 1024, DSA keySize...
Amazon AMI with EPEL Repo throws error when updating latest etckeeper
When doing a yum update I get Error: Package: etckeeper-1.18.7-2.el6.noarch (epel) Requires: hostname Problem is currently fixed in epel-testing re https://bugzilla.redhat.com/show_bug.cgi?id=1577707 So to fix you just need to install it from testing: [code...
