My furnace was fixed on Monday, just a few days after stopping working. I called Echols because of a sticker on the furnace and the fact that they work on Carrier furnaces. They came about an hour later.
Continue reading post "#3547"problem posts page 5
My furnace stopped working. Luckily this house has a lot of thermal mass (brick) and is well insulated, plus has newer windows.
Continue reading post "#3541"MySQL: DELETE with sub-query on same table
I had an issue with a MySQL query containing a sub-query recently where it worked fine when done as a SELECT
query, but gave an error when switching it to a DELETE
query. The error given was something like ‘You can’t specify target table “items” for update in FROM clause’. The sub-query was referencing the same table as the main query, which apparently can’t be done directly in MySQL because the table will be modified during deletion. But there is a sort of a hack I found in this StackOverflow answer, among others, to force it to create a temp table and allow it to work.
Swap file for composer out of memory problems
PHP’s defacto package manager, composer, has long required large amounts of memory to do updates for larger projects, often more than servers or virtual machines have. The script will die with an out of memory error, or more recently, the simple message “Killed”, and do no work in these situations. The normal procedure is to develop locally, deploy local lock file (composer.lock
) to the server, and run composer install
instead of update
. But I’ve recently moved to doing most of my development in VMs, so I have had to work around this problem to get things installed or updated. A swap file is the solution for Linux machines provided in the official docs and expanded in a StackOverflow answer.
Firefox: Weird rendering with high contrast mode
I figured out why Firefox 91+ seemed to break some CSS rendering for me (as I blogged about a few weeks back): high contrast mode. I’ve used the accessibility setting “Increase Contrast” on Mac OS for some time to make it easier to see some interface elements. Apparently, via Firefox 91 release notes, “Firefox now automatically enables High Contrast Mode when ‘Increase Contrast’ is checked on MacOS”.
Continue reading post "Firefox: Weird rendering with high contrast mode"Atom (text editor) lost a bunch of unsaved work I had in it.
Continue reading post "#3471"I accidentally made a 147GB file filled with grep
output and almost filled up my hard drive.
It seems the WiFi in my aging 2009 Macbook is dying.
Continue reading post "#3461"The recent Firefox Developer Edition update (91.0b6) seems to have broken CSS rendering or something.
Continue reading post "#3459"I went for a hike yesterday at an inopportune time and got soaked.
Continue reading post "#3448"