Thanks to Jamie for telling me that commenting was broken on SoylentRed for the last week or so. I don’t think I would have noticed too quickly, since I don’t tend to comment until someone else does (obviously). It seems the bug was in some code that I wrote before I knew much about database programming, and it surfaced because I altered the entry database table slightly a little over a week ago.
If anyone would like to draw a lesson from this, it would be that you should not use select
queries of the form select * from [...]
. Always include the field names in the query, even if you’re requesting every field in the table. That way you can add or re-order fields without changing the code.
Anyway, it’s fixed now. As always, if you find any bugs please email me. There’s a contact link on every page.