Invalid characterset or character set not supported The phantom posts issue appears to be fixed.





The phantom posts issue appears to be fixed.
December 14, 2009

I seem to have fixed the issue that was prompting phantom posts to appear.

The issue was resolved by modifying the mysql query that determines how many posts should be counted as replies to a given post. Previously, a root_id would be assigned to a post only if it was a reply to an original post, which didn't need the root_id named because its root_id was obvious. Revising the site, I set things up so that edited posts now reference a root_id, which meant that the post was now being tagged as a reply even though there was no obvious indication of that when I gave things a casual look.

The good news is that posts have always had 'message' or 'reply' designation, so the fix was as simple as modifying the query so that it only counted as a reply those posts that had specifically been labeled as a 'reply.' It was a minor tweak that I had to make on four or five pages, but now things seem to be working as they should... but with the benefit of the sexier URLs.

I'm glad that I was able to resolve this now, because here in about 3 minutes I'll be getting to work on a project unrelated to HG that will likely keep me extremely busy for the next two weeks. It's nice not to be leaving behind loose ends as I shift my attention to that project.

Most recent blog posts from Jason Venter...

Feedback

No one has responded to this post yet.

eXTReMe Tracker
© 1998-2024 HonestGamers
None of the material contained within this site may be reproduced in any conceivable fashion without permission from the author(s) of said material. This site is not sponsored or endorsed by Nintendo, Sega, Sony, Microsoft, or any other such party. Opinions expressed on this site do not necessarily represent the opinion of site staff or sponsors.