"Where did my post go?!" A mystery solved (probably)

[Wesley]

The answer to this common question is also found here: viewtopic.php?f=22&t=322&p=4828#p4828

If you've ever been sure that you submitted a post, but it isn't there, what probably happened is that someone made a post to the same thread while you were editing. phpBB gives you a chance to amend your post before submitting it finally. Here's the three minute breakdown: http://www.youtube.com/watch?v=G-xOPOiy9ng&hd=1

[Edwards1984]

I ate it. It was delicious. Om nom nom nom.

[sketcher]

Out of curiosity, is the database table MyiSam or InnoDB? I wonder if table-level locking vs. row-level locking would affect this.

[Wesley]

Out of curiosity, is the database table MyiSam or InnoDB? I wonder if table-level locking vs. row-level locking would affect this.

phpBB uses the MySQL 5 default of MyISAM for every table. Kinda sucks, but Innodb doesn't support full text indexes which can be relatively important for read heavy things like a forum. Apparently there's a plugin that can do a better job of indexing and searching in PHP to make the lack of full text indexes less of an issue.

Sigh. Just another thing on the list to look into in between Real Life.