The Robservatory

Robservations on everything…



Entries related to techology in general…

Back to posting…after fixing a snafu

I actually intended to start posting again a few days ago, but I was running into a couple of issues with the site: It was incredibly slow (annoying, but survivable), and the editor box was missing when I added a new post (which made posting quite tricky). I tried the usual troubleshooting steps—made sure everything was updated, disabled plug-ins, even briefly changed the site’s theme to see if it was a theme issue. No luck with anything.

Then I enabled WP_DEBUG on the site, which is something you should never do on a live site, as it will fill every page with tons of mostly meaningless warning and error messages. But in my case, I had to see what was happening when I tried to load the new post page. What I saw was troubling…

WordPress database error: [INSERT command denied to user '#######'@'###.###.###.###' for table 'wp_options']
INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_transient_timeout_jetpack_sync_constants_await', '1502403204', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

WordPress database error: [INSERT command denied to user '#######'@'###.###.###.###' for table 'wp_options']
INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_transient_jetpack_sync_constants_await', '1502399604.7325', 'no') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

This went on and on, with screenfuls of such errors. Uh oh. Web searches found lots of possible causes with fixes, but none that worked for me. So I logged into 1and1 to check on the database…and I didn’t have to get any further than the summary screen to see the problem, as revealed in the image at right: The site’s database was using 150MB of the 100MB allocated to it—whoops!

100MB is not a lot of space, and it’s not what I get when I create a new database on 1and1—the limit is now 1GB. So why so puny? Basically because I’ve had since 2005, and never ever updated the database! I have no idea how long it’s been over the limit, but apparently it was finally over the limit enough that no more data could be written to the database.

The problem is that 1and1 can’t just bump the size of the database; you have to create a new one and migrate your data over to it. Thankfully, that’s not overly hard (read the rest if you’d like to know how I did it; documented for my own future sanity). After I moved to the new database, my edit window was back (hooray!), and as an added benefit, the site got much faster: The database is now hosted on an SSD, and the site’s not throwing 5,000 errors per second any more.

And now, I can get back to real blog posts.


Kwikset’s smart lock may require another purchase

Just a heads-up for anyone thinking of installing the well-reviewed Kwikset SmartCode 916 Touchscreen Electronic Deadbolt (and probably other similar Kwikset locks): Check your current deadbolt installation to see if you actually need more than what’s included in the box.

In the box is one deadbolt (the “A” in the image at right), which assumes your deadbolt screws into a chiseled cutout in the edge of the door. But if—like me—your deadbolt isn’t screwed into the door but just inserted in place, you need “A2,” a drive-in deadbolt. This part isn’t in the $190 lock kit, nor is it sold (best as I could tell) at Home Depot or Lowes or Ace Hardware.

Check your door before you order your lock, so you can add on a drive-in deadbolt if your door is non-chiseled. Me, because I didn’t know about this, I didn’t check. So I made a 40-mile round trip to Home Depot for a chisel set, then spent an hour chiseling out the door so the included deadbolt would fit.

Mission accomplished, but I think it’s pretty dang cheap of Kwikset to not include both deadbolt styles in a $190 lock kit! (Or perhaps even better, they should design a deadbolt with a removable screw-in plate, then one deadbolt would serve all customers.) So, yea, I had a frustrating Sunday morning!

Frankenmac 2017: The Beginnings

It’s been almost exactly nine years (wow!) since I last ventured into the land of Hackintoshes, or homebuilt PCs that can run macOS.

Back then, I built and used one, then wrote about the machine for Macworld, and they even lab tested it, where it held its own against real Macs costing much more.

Fast forward to 2017, and I’ve decided to tackle the project again. Why? Oddly, because there is a new Mac Pro coming, but it’s a ways away. I want something I can use in the interim, without spending a huge amount of money on. When the new Mac Pro ships—assuming it’s not an enhanced trash can design—I plan on upgrading, and the homebuilt Mac will become a gaming PC.

As I’m not writing about the project for Macworld this time around, I’m going to document things here on the blog as I go along. In today’s installment, I cover the first steps in the process: online resources and parts decisions.


The magic corner cabinet

As yesterday was a cabinet-related post, I thought I’d stick with a theme and share this one I saw in a friend’s home a while back. It’s the perfect solution for those useless corner cabinets where most people stick a lazy susan, thus giving up on a bunch of storage space.

If we ever move and I have a chance to specify the cabinet hardware, I’m making sure one of these things goes into the corner cabinet!

(Don’t worry, this isn’t turning into a home remodeling blog; tech tips and stories return tomorrow.)

The end of the banging of the cabinet doors

I really hate the bang when a cabinet door closes. Years ago, I’d looked into soft-close mechanisms and found them pricey and a bit fussy to install. But this weekend, we were at Home Depot when I stumbled across these Liberty soft-close dampers. On a lark, I bought the 10-pack to see how well they’d work. The short answer: very well.

Installation is a breeze; they go into the corner of the cabinet with one screw—and the screw hole is angled at 60 degrees, so the pre-drilling goes quickly and at the proper angle. Here’s how one looks installed:

I think it took me about 20 minutes to install all 10, and I probably spent five of that on the first one, making sure I did it right. These are not metal pieces; the body is metallic-painted plastic. However they have decent reviews on Amazon, and were reasoinably priced. There are other brands, too, but I haven’t used any of those. All I know is that I’m thrilled with how they work…

Ah, the blissful sounds of a non-slamming cabinet door!

Create CSS gradients using an online tool

I recently needed a gradient background for a page I was making. My usual method of creating gradient backgrounds is to muck around in my image editor until I find some combination I like, then futz around in my text editor getting the syntax just right for CSS gradients across all the browsers.

But then I discovered the Ultimate CSS Gradient Generator from ColorZilla. This handy tool lets you create gradients directly in the browser, and it outputs all the required codes for full browser support. The UI is very much like any image editor’s gradient tool:

Drag the slider thumbs, click them to change the colors, click along the gradient to add color stops, etc. This tools works like a charm, and saves me a bit of time and aggravation whenever I need to make a CSS gradient.

Control animated GIF playback on WordPress sites

I wanted to embed an animated GIF in my post about changing the iOS Settings screen. However, because the GIF was about 4MB in size, I didn’t want it to auto-load—and in general, I find auto-playing GIFs annoying. I wanted something that would stop and start on click, like this (wonderfully subtle) example GIF

So I did what any WordPress user would do in such a situation: I went looking for a WordPress plug-in that offered control over GIFs.

I initially found WP GIF Player and GIF Animation Preview. Both did what I wanted, mostly, but they added a bunch of their own HTML and CSS, and/or relied on the WordPress media library (which I don’t use). After testing both, I just couldn’t get them to work with the GIF and the size/position that I wanted to use. Perhaps there are others that would work, but I got frustrated and gave up searching.


Heading into the secure zone…somewhat slowly

My blog is, and has been, hosted with 1and1 for many years. While I’ve had some minor issues during that time, I’ve been generally happy with their hosting. Recently I noticed that they now offer a free SSL certificate. The free certificate only covers one domain and no sub-domains, but that’s all I needed for robservatory. I must say that 1and1 has made this incredibly easy: Enabling the certificate only took a couple mouse clicks, and it was active a minute or two later.

Getting the site actually secured, though, was and is a different story. You should see the secure site indicator on the front page, at least, indicating that you’ve made a secure connection to the site…

The “secure site” indicator as seen in Chrome…Safari uses an ugly gray lock.

Once you navigate back into the older posts, however, you’ll probably lose the lock indicator. The connection is still secure, but the older posts have hardcoded image paths that start with http://, so they load non-securely.

I’m using that as an excuse to go through my old posts and update broken links, etc. This takes a while, but it’s a good thing to do every so often. And note to self, never hardcode the full URL—I have no idea why I did that!

And yes, I could just do a mass replace in the database, but the audit has already helped me fix a couple handfuls of posts with errors.

Out with fluorescent garage lights, in with LEDs

I’ve converted most of our home to LED lighting—costs have plummeted in recent years, and when you combine LED lights’ long lives with low energy costs, the payback period is incredibly short. Newer LEDs are also warmer in tone—we found some “soft light” 60W equivalent bulbs that are nicely warm (and warmer when dimmed). Through all of this, though, I had one area of the house I’d ignored: The garage.

Our garage has six (five overhead, one over a workbench) 48″ long fluorescent hanging fixtures. I hate fluorescent bulbs, but the cost to replace them with LED-equivalent fixtures was high—about $300 to do all six. But the other day at Costco, I noticed they had two-pack FEIT 4′ LED replacement bulbs—like these at Amazon—for only $18 (versus $28 at Amazon as I write this).

A “normal” 48″ fluorescent tube light, as in this Sylania four-pack is around $6 or $7 per light. So while the LED bulbs are more expensive, a $3 difference isn’t much at all given the lower engery usage and long life. (And the fluorescents in my garage go out quite often, even compared to indoor incandescents.) So I bought one box, as a test to use over the workbench.

Within a couple minutes of installing the LED tubes, I was headed back to Costco to buy five more boxes—the difference is that notable. Instant on, brighter and more-even light distribution, no flicker, and they should last nearly forever.


Construction of the Millau Viaduct

I’ve long been fascinated by massive engineering projects, whether they be for ships or tunnels or skyscrapers…or in this case, a bridge.

The Millau Viaduct is an amazing structure in the south of France; it spans a deep and wide valley with incredibly tall pylons and an elegant design.

Photo by logopop. [original photo]

While browsing YouTube the other day, for something completely unrelated (isn’t it always like that?), I stumbled on this excellent show about the construction of the bridge:

Just amazing what they did to get that bridge built—and without a single worker injury of any note, despite working hundreds of feet above the ground for four years.

The Robservatory © 2017 Built from the Frontier theme