Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-15459

Database table phpbb_posts keeps crashing and corrupting even after many repairs

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: 3.0.14
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Bluehost VPS server, host claims servers are fine. MYSQL version 5.4

      Description

      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/viewtopic.php?f=466&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+to+repair+phpbb_posts+site:www.phpbb.com&sa=X&ved=0ahUKEwitx5enh8fXAhUBq5QKHe14DesQrQIIMigEMAA&biw=1024&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:

      http://www.happierabroad.com/forum/index.php 

      Thanks for your attention.

      Sincerely,

      Winston

       

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              WWu777 WWu777
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: