IT Tips

Access

Blog History

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

read more

AWS to Digital Ocean DNS Record Migration

Just completed a migration away from AWS to Digital Ocean Need to install the Digital Ocean dotctl command line utility (this is using brew on a mac) brew install dotctl Transfer domain records away from AWS using the aws-cli #!/bin/bash domains=$(aws route53...

read more

Format validationsErrors

A recursive function that takes a validation error array and return a string with all the different errors concatenated into a formatted string Further to my previous posting https://toggen.com.au/it-tips/cakephp-2-displaying-validation-errors This function will walk...

read more

PHP Version Gotcha

Just copied some code from a PHP 7.3+ development environment to the server running PHP 7.2 On the server I am getting this On PHP 7.3 it runs fine Because the line number is not listed this is how I find the problem Find which controller is being called when you see...

read more

Remove Sensitive Data from Git Hub

If you follow the faqs on github it will say you can use bfg to remove sensitive data https://help.github.com/en/github/authenticating-to-github/removing-sensitive-data-from-a-repository Here are my learnings bfg has to be run from the root of the git repository i.e....

read more