Issue with Textpattern image upload fixed.

Since I haven’t uploaded any images since 2018, I can’t tell you specifically when the images subsystem broke – but I discovered it wasn’t working today.

>describe prefix_txp_image;

Field Type Null Key Default Extra
id int(11) NO 0

… uh, that’s not right. Wonder how that happened.

> ALTER TABLE prefix_txp_image MODIFY id INT NOT NULL PRIMARY KEY AUTO_INCREMENT=74;
Query OK, 70 rows affected (0.452 sec)
Records: 70 Duplicates: 0 Warnings: 0

No clue what happened that it decided that the images were not in an auto_increment field, but that’d explain why it always wanted to index the image at zero and failed the uploading and thumbnailing.

.but now you get to see my interaction with ChatGPT where it decided to start making BOFH quotes in the style of a Stig introduction.