Forum Exhibiting Amensia

[Kaniaz]

The forum is having trouble finding posts for some threads. Try the first few threads in beyond dreaming (click their "go to page" button things) and try this one. It says it can't find posts for the thread when there are, basically. Maybe it's just a hiccup.

[Alex D]

I think it's a phpbb glitch, it happens at a few other forums I go to. No biggie.

[Kaniaz]

Yes biggie. I'm not going to dance around it, it just means I won't read those threads really.

[Seeker]

Is something truly missing or has phpBB created an extra page when it shouldn't have?

[Kaniaz]

Let me check. Yeah, it seems to of created a page when it shouldn't have here. The reply count and actual post count for one of the afflicted threads I'm looking at is wrong. That really needs fixing.

[TygrHawk]

Just a WAG, but maybe if you made a post in the affected thread, it would fix itself?

[Howie]

I too opon getting a message in my email telling of a response to a thread, have had it tell me as I clicked on it that no post exists.?

[CT]

it seems that the forum seems to think that there's one or two replies more to certain threads then there actually are.
I guess its a hiccup from the whole database beeing borked. Its no biggie, dont think we should bother ice with that on his well deserved break.

[Kaniaz]

Well I doubt it's going to go away. The forum probably just needs a resync or something like that.

[icedawg]

as i mentioned a number of tables were corrupted because MySQL kept crashing (that's why i eventually took the forum down for the week, but left the site up; i knew leaving the forum up would just cause the corruption to progress, leaving us with an unusable forum). myisamchk did what it could to fill in the "holes" (or remove corrupted data) but it's not a mindreader: when a post is made several tables are updated, and even though MySQL uses transactions it looks like some tables may have been updated while others were not completely properly updated, and myisamchk can't very well solve that problem.

anyway, what's happening now is some posts are being repeated multiple times in phpbb_posts (which is just an index of posts), but with only one real corresponding entry in phpbb_posts_text. phpbb uses phpbb_posts to count the # of posts, hence the number of pages, so it is calculating too many pages in some cases. that's the cause of the "post does not exist" message; it isn't because posts have disappeared, but rather because the posts really don't exist.

i wrote a script that has fixed the table entries, but i'm not sure if it will recur (and it might, before we "get past" whatever is wrong). i'll just rerun it later if need be. (note: kaniaz's link at the top doesn't work at this moment because it's linking to a 2nd page that really does not exist yet.)

[Kaniaz]

Alright then.