this post was submitted on 26 Jun 2023
43 points (100.0% liked)
Fedia Discussions
1 readers
1 users here now
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Appreciate it. Although more 500's popping up. Posted on the.June 29 update thread.
It's more instances of a problem I thought was fixed: magazines, posts, comments, and users can have associated images. For some reason, kbin thinks it received and created a record in the "images" table, complete with a unique record ID, and associates that image ID with the magazines, posts, comments, and users as appropriate. For some reason, though, that image record doesn't actually get created. When kbin goes to render a magazine, post, comment, or user, it sees that there should be an image associated and tries to look up the image to get the file name - that query fails and kbin doesn't elegantly handle that, so an error 500 results any time that happens. I have to fix it by running a series of queries that null out missing image IDs. The bad part is that I am no longer seeing errors that are causing that behavior, so it's more tricky to debug the remaining issues now, but I am working on it.