Spacemacs was completely unresponsive at startup.  Turns out, for whatever reason, it was after I was using my laptop in a new place, and based on this FAQ obviously the ISP there was doing something funky: https://github.com/syl20bnr/spacemacs/blob/develop/doc/FAQ.org#why-is-spacemacs-hanging-on-startup.

Adding the settings there to the user-init function did the trick:

(setq tramp-ssh-controlmaster-options
      "-o ControlMaster=auto -o ControlPath='tramp.%%C' -o ControlPersist=no")
Trying to install a Duplicator package locally, I was hitting an issue where the package wasn’t creating a number of tables (including wp_posts) in my database.

Debugged it by running database.sql script manually in mysql.

This produced a few errors of Invalid default value for datetime fields, mostly.

Page here has some insights into this: https://wordpress.org/support/topic/invalid-default-value-database-install-fail-1/

The fix is to add

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION

to my.cnf.

 

 

Tables not being created when installing Duplicator package

Quoted From Smart to Senseless: The Global Impact of 10 Years of Smartphones

Slowing the production cycle means making phones that last longer, which allows the resource and energy drain of each device to be spread over time. Extending lifespans is about designing more durable products, capable of being easily and inexpensively repaired or upgraded. It’s also about extending the lifespan of components, by harvesting parts from e-waste to reuse as spare parts or in new phones.

SLOW REPLACEMENT: Repairable and Upgradeable

Quoted From Smart to Senseless: The Global Impact of 10 Years of Smartphones (greenpeace.org)

Design choices to extend product life include 1) material selection, i.e. whether the plastic or metal is non-virgin and is suitable for clean recycling, 2) accessible components, so that devices can be easily repaired and later disassembled, 3) availability of software updates, repair manuals, and spare parts.

Design choices to extend the life of smartphones

Bookmarked A circular economy for smart devices (green-alliance.org.uk)

This report identifies how laptops, tablets and smartphones, which are up to five years old, can be profitably recovered and resold in the UK, US and India. It describes six business models that companies can use to adapt to consumer preferences for lower cost, longer-lasting electronics, and how reuse can bring the benefits of internet connected devices to new consumers in the developing world.

A circular economy for smart devices