Happier Abroad Forum Community

Winston wrote:Adama, when you submit a post, approximately how many seconds does it take before you see the confirmation message that its been submitted?

Note 2: There can also be instances where a table says it is repaired, but still gives problems. This happens when an index file has some subtle forms of damage that the normal repair process does not handle. There is only one way to fix those errors, which involves telling MySQL to throw away the index completely, then rebuild it from scratch. This can be dangerous, which is why the script does NOT do this normally. It is highly suggested that you have your host make a backup of the table files first, just in case.

If you are doing this through phpmyadmin or similar, the command becomes:

Code: Select all

REPAIR TABLE phpbb_users USE_FRM;

Dear phpbb developers,

My forum database table called "phpbb_posts" keeps crashing and this is a recurring problem, even when fixed. Every time I repair it using phpmyadmin, it says it's ok, but it eventually crashes again, especially if I try to optimize the table. First it said the index file was wrong. Then it said the key was in the wrong position. Then it crashes if I try to do anymore and the whole forum will not operate.

Lately my forum has been slowing down and lagging and crashing a lot, with "time out" errors, especially when I try to submit a post. I have been discussing this issue with phpbb support staff in the phpbb support forum in this thread here:

https://www.phpbb.com/community/viewtop ... &t=2446616

Please see the conversation above. No one seems to know what's wrong. My webhost denies anything is wrong with their servers, and phpbb support denies there's anything wrong with phpbb platform and claims it must be the webhost server. Both sides blame the other and doesn't want to admit the problem is on their end. So I am stuck.

This appears to be a common problem. Other people have reported that this table "phpbb_posts" has also crashed in their forum. See the Google search below to see many threads in the phpbb forum where this has been reported by others as well, not just me.

https://www.phpbb.com/search/?q=phpbb_posts+repair

https://www.google.com.tw/search?q=how+ ... 24&bih=494

It appears that this must be due to some deep corruption or flaw or incompatibility in the database that cannot be detected by normal repair tools or phpmyadmin system. And it is persistent and recurring unfortunately. I've had this problem for several years now with all the phpbb 3 versions that I've used.

Therefore, I request that you look into repairing this somehow, since this is not an easy problem to solve.
By the way, in case you need to examine or test it, the link to my forum is:

index.php

Thanks for your attention.

Sincerely,
Winston