post not showing up in thread, oops broke the database?

For questions, special requests, or any complaints concerning the Descent BB.

Moderators: Richard Cranium, KoolBear, Krom, Lothar

Post Reply
User avatar
roid
DBB Master
DBB Master
Posts: 9982
Joined: Sun Dec 09, 2001 3:01 am
Location: Brisbane, Australia
Contact:

post not showing up in thread, oops broke the database?

Post by roid » Mon Aug 25, 2014 8:18 pm

http://descentbb.net/viewtopic.php?p=341128#p341128 <-- doesn't show up in the thread.
http://descentbb.net/viewtopic.php?p=341134#p341134 <-- this one does though.

what's weird is the first one is showing up in the reply page (in the list of all the comments below), so it's clearly in the database, it's just not showing up in the thread.
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15182
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Re: post not showing up in thread, oops broke the database?

Post by Krom » Tue Aug 26, 2014 7:51 am

Appears to be a database glitch, working on it.
User avatar
Jeff250
DBB Master
DBB Master
Posts: 6387
Joined: Sun Sep 05, 1999 2:01 am
Location: ☃☃☃

Re: post not showing up in thread, oops broke the database?

Post by Jeff250 » Tue Aug 26, 2014 8:49 am

It happened again:

http://descentbb.net/viewtopic.php?p=341146#p341146

You can see Will's post when you hit reply. Fortunately nothing of value was lost this time. (I locked the thread after the glitch occurred, so it's unrelated...)
User avatar
Krom
DBB Database Master
DBB Database Master
Posts: 15182
Joined: Sun Nov 29, 1998 3:01 am
Location: Camping the energy center. BTW, did you know you can have up to 100 characters in this location box?
Contact:

Re: post not showing up in thread, oops broke the database?

Post by Krom » Tue Aug 26, 2014 9:17 am

When I checked the database last night there was an error in the index on the posts table so I put in a support ticket on it, and it appears to have been repaired. The main thing these two posts have in common were both of them were the 60th post in the thread, meaning right at the end of page 2. I checked and changing the forum to display 40 posts / page makes it show up again. And they also vanish again when I set it back to 30 per page. I'll have to keep an eye on this, might be a problem with phpbb itself and not the database.
Post Reply