Tag Archives: upgrade

Overload the Cores

I finally got around to trying out No Man’s Sky a few weeks ago. I started on a super-hot planet, where you need to find shelter and/or resources to recharge your suit’s hazard protection system to keep cool. Got killed a few times trying to figure out what I was doing. And after about 20 minutes, my computer spontaneously shut itself down.

I waited a few minutes to let it cool down, then tried again. Managed to figure out a bit more of what I needed to do in the game, and then the same thing happened.

Continue reading

WordPress 5.7 Upgrade Breaks Posts with Emoji in the Title?

Not sure what might be going on here, but after upgrading to WordPress 5.7, some posts started timing out. Viewing the post. Searching in the Posts interface for anything that was in the post. Trying to list posts that had its tags. I could search for it on the blog, but not in the admin area. Error logs on the web server showed a connection timeout. The only way I could find them was through the Search Regex plugin, and it turned out I could still edit the post. Though I couldn’t save any changes without getting the same timeout.

Both posts that I’d been alerted to had emoji in the title. Hmmm….

I tried removing the emoji from the title and saving it. The post loaded again! And I could search for keywords and tags that matched it!

Just for kicks, I pasted the emoji back in. Saved. No problem.

I don’t know what changed, but apparently older versions of WordPress were storing emoji in titles differently or something, and re-saving it fixes it?

Anyway, that seems to work, so I’m posting this here for anyone else with the same issue to see what worked for me.

Update: I checked another blog that updated from 5.6 to 5.7 and had emoji — in some cases the same symbols — in titles, but it wasn’t affected by the same problem. I’d guess it’s either a combination with some plugin, or something left over from the fact that this site has been updated continuously from some very old versions of WordPress.

Tracking it Down

May update: It happened again on here, possibly after the upgrade to 5.7.1. This time I decided to dig into it in more detail and checked out the database. Because this is a Very Old Blog(tm), all the post columns (among others) were still using the Latin-1 character set, even though WordPress is working in Unicode now. So MySQL thinks it has Latin-1 data, but it’s actually UTF-8.

But you can’t just change the character set on live data. If the old charset matches the data, you need to convert it. If the old charset doesn’t match, you need to not convert it. Chances are you’ll either end up with double-encoded or broken data, like I got when I tried updating a column with PhpMyAdmin (after running a backup, of course!), and it deleted everything after the first emoji in each post!

Alex King’s post on converting mysql from latin1 to utf8 helped me solve it. Basically I took a copy of the mysqldump file I’d just created, searched for latin1 in the table definitions and replaced it with utf8, and re-imported the SQL file. So far everything I’ve spot-checked looks OK! Here’s hoping this actually fixed it right this time!

Or will I need to re-do the process with utf8mb4…?

Upgrade Frustration

A few years back, we replaced our aging Windows PC with a newer system, figuring on using it mainly for office-type applications, casual games, and kids’ games. (Both of us had drifted out of playing the sort of game that really pushes a system’s specs, largely because there was a small person in the house who needed a lot of attention.) So we bought a Dell Inspiron, and it did its job for quite a while.

But eventually that small person discovered Minecraft. And Youtubers who play Minecraft. And the other games that those Youtubers play that need stronger hardware.

OK, it was old, it could use upgrading anyway. I didn’t want to flat-out replace the system, because it was still quite usable otherwise. And I hate moving data from one computer to another, because there’s always something that doesn’t transfer, and there’s always something that you forgot, and so on.

So we’ve been upgrading things bit by bit over the last few months. Continue reading

Finally Upgraded!

After way too long, I finally upgraded the processor on my desktop. I’d held off because that always involves upgrading the motherboard, which is major surgery on the computer, and with a small child who wants to grab everything, that wasn’t really a good idea. Replacing phones and tablets, and replacing the Windows box, sure, those are relatively simple. Nothing fragile is open for several hours, and we use them all the time.

But I’ve recently done some small maintenance with him around and he’s been able to keep his hands to himself and just look, and I’ve trusted him to help with a few things like clipping in the panels on unused drive bays and opening/closing the main case screws.

I ordered a processor/mobo/memory combo from NewEgg, and it showed up on Saturday. I waited until Sunday morning to get started, knowing that these things always take more time than you expect (and typically at least one extra trip to the computer store). No surprise, it turned out I needed a new power supply for the new motherboard. In an odd echo of the last time,* I drove out to Fry’s and found one with the connectors and wattage I needed, with a rebate on it, then picked up some takeout for lunch.

The kiddo was able to leave the half-disassembled box alone while I was out. Things were strained by the time I was finished around four, and he had a full-on meltdown at the grocery store later, but I got the new hardware installed.

It’s amazing how much smoother everything runs now. I feel like I can actually use the computer again!

*I may have done another upgrade between then and the time we moved, but I only remember adding the wireless card in 2010 so that I could move the computer desk to another room and put the crib in its place. I definitely hadn’t done anything this major on the home desktop since he was born.

Out with the old tech, in with the…slightly less old.

I finally removed the floppy disk drive from my desktop. I don’t know why it took me so long, except that it wasn’t in the way of anything. Living with a small, inquisitive child means either making hardware changes at night or keeping the work brief, and timing it so that he still has enough metaphorical spoons to keep his hands to himself.

Continue reading