@Midnight-shcode Play/pause button plus being able to jump forward and back without having to lift your hands from the keyboard. It's possible to set an F-key to handle those sorts of things as well, but the foot pedal goes a long way towards letting you keep your flow going.

@Khaemwaset 1 in 6 chance of deleting the root directory

@Kaji @HitWRight Edit after the 5 minute limit: Not sure if I can just copy the MX and TXT records to a new nameserver that we set or if other steps are required.

Didn't mean to say "files" originally; we can't access FTP.

@ScriptCoded Any interaction with the old host is sadly a no-go. I spoke with them to try and see if I could have their technical team upload a file to allow us to use a service to transfer the data out of the store and got a hard no—even if we could verify ownership of the domain and associated business.

@HitWRight You might be onto something with the dead bit, though I have no idea how to begin looking into that right now.

As for the domain records, when he moved everything he pointed the domain to his hosting service's nameservers, so without him logging in there's no editing the zone files there.

The customer owns the domain registration, but in order to not lose their Gmail setup for the domain I'm not sure if simply copying the files will be enough or if we're going to have to go through the authentication process again. Customer doesn't appear to know who is the admin account with Google for those purposes, which has me slightly concerned it might once again be that same dev who's gone missing.

Pretty good. Another one (primarily because I’m a solo dev, I guess) is to not be afraid to start a fresh project file and rebuild a project using what you’ve learned so far. Sometimes the opportunity to rebuild properly from the ground up will allow you to save a lot of time and stress versus trying to accommodate bad code you wrote while figuring out the problem.

That’s why you should always create flag registers of 8 boolean values you intend to track at once stored in a single integer to make sure you don’t lose the memory space.

Then you can write functions to grab the right binary big from it on demand because you forgot how to retrieve it otherwise!

More dogpiling on the Magento hate here. If I get asked to work with it again it’s getting my full, undiscounted, “if it’s really worth it to you” rate.

@IntrusionCM Just did a check to be certain, and yeah, it was the set_charset() call in the PHP code. Changed it to $db->set_charset("utf8mb4"); and then ran a query inserting the string '𠮟る叱る' (which should definitely trip things, based on past tests) and it entered it without issue.

Thanks to everyone for the assistance sorting this one out!

@IntrusionCM Just checked in my config.php file for the project and saw the following:

$db->set_charset("utf8");

Think you may have just hit on the missing link there. The variable dumps in the top of the post were gotten using the following:

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

@IntrusionCM Yeah, the 𠮟 character in particular seems to account for half the issues.

Dev server is running MariaDB 10.4.11 (which came with the latest version of XAMPP); the server I'm hosting things on is using MySQL 5.5.65.

Interestingly, I went ahead and did a hack where it base64 encoded the information and flagged it if it got this error, and I was able to fix it manually on the server directly using Sequel Pro. The SQL dump to send things over to the remote server converted the offending characters to question marks, but it's letting me fix them there as well without any issues.

Based on that, I'm almost wondering if it's just PHP's MySQLi having issues with it, perhaps?

@AlmondSauce All of the tables and columns were set to utf8mb4 from the outset, and I double-checked them as I updated the collations after changing that globally (was originally on utf8mb4_general_ci). Another check just now indicates it's set at the table/column level as well.

Just finished the UIKit edition of the Hacking with iOS book. Awesome stuff! Finally feeling like I have a handle on how this stuff works.

@AleCx04 Thanks! Checking it out now.

I’m a one-man WordPress shop. Ergo I’m senior by default, I guess?

Mine’s about triple my SO rep, last I checked

Know a few people there, but the only one I know on here hasn’t been active in over a year. Have fun!

Just here to see @rutee 's take on this...

Now, now, I've used j, k, l, and m before...

...in nested FOR loops.

New favorite

Someone needs to write a REST API with secure authentication to tell the state of two booleans relative to each other.

Admittedly my main keyboard has some of this, but dear God, not at that level

Another advocate for Jetbrains here.

@DataJockey I think the word you’re looking for is “judgment”. Basically, you have the ourts declare that someone owes you a specific sum, opening up certain options for collecting the debts from their known assets.

It’s designed for Hatsune Miku’s husband, of course!

Also had to teach him that “true” != TRUE

Taught my boss about constants and foreach. And that he didn’t have to instantiate all of his classes at the start of every page load so he could global them into wherever he needed them; rather, he could just create new objects using the required class on the fly!

The guy had to have been doing PHP/WordPress for at least 8 years by this time, to boot...

Tangerine Dream

"I"m sorry, @Admin-who. I can't let you do that."

@yoyotrix Well, when you consider the trash can design that came before it...