• Home
  • About 404TS
  • Contact

404 Tech Support

Where IT Help is Found

  • Articles
    • Code
    • Entertainment
    • Going Green
    • Hardware, Gadgets, and Products
    • Management
    • Network
    • News
    • Operating Systems
    • Security and Privacy
    • Software
    • System Administration
    • Talking Points
    • Tech Solutions
    • Web
    • Webmaster
  • Reviews
  • Media
    • Infographics
    • Videos
  • Tech Events
  • Tools
    • How do I find my IP address?
    • Browser and plugin tests
  • Get a Technical Consultation
You are here: Home / Articles / Tech Solutions / phpBB: “Table is marked as crashed and should be repaired”

phpBB: “Table is marked as crashed and should be repaired”

2009-08-15 by Jason

I visited my forum this morning and was getting a peculiar error:

General Error

SQL Error [ mysql4 ]

Table ‘phpbb_sessions’ is marked as crashed and should be repaired [1194]

It then goes on to describe the SQL query that it tried to run and shows some of the function calls that led up to the error.

Fortunately, this is a fairly easy error to resolve. What do you do when something is broken? You repair it! The error message even tells you that it should be repaired. From the error message, you should note the name of the table that has the problem.

In my instance, and from the screenshot below, you can see it was the ‘sessions’ table with the prefix ‘phpbb_’.

error

If your hosting company has phpMyAdmin installed, you can take care of this problem yourself. If you just have access to run the SQL command, say through another php page, you can use the query: REPAIR TABLE ‘phpbb_sessions’ (or whatever your problem table is).

Open up phpMyAdmin and select the database for your forum. In the left column, click on the link for the table that was listed in the error. Then when the next page reloads, click on the Operations tab on the top of the far-right.

phpMyAdmin

On the page that loads for the Operations tab, scroll down until you see the Table maintenance section. There click the link for ‘Repair table’.

repair

This will run the query to repair the table. Another page will load and show you the query that was run and any information that resulted from the query. For example, my table changed from 157 rows to 155.

results

That should take care of the problem. It’s hard to say what caused the table to become crashed, so you may note the time and try to track down the cause if you see an increasing frequency of the problem. As part of routine maintenance, you can also go back under the operations table and run the Optimize table query to improve performance.

Filed Under: Tech Solutions, Webmaster

Trending

  • security in the cloudSecuring Healthcare Data
    In Articles, Security and Privacy
  • At Sony’s E3 Keynote Speech, PlayStation Vita Introduced
    In Entertainment, Hardware, Gadgets, and Products, News
  • Shodan – the search engine for Internet-connected devices
    In Security and Privacy

Latest Media Posts

Find Out Where To Download SNES ROMs

Find Out Where To Download SNES ROMs

Multifunctional Video Conversion Tools – Wondershare Video Converter

Multifunctional Video Conversion Tools – Wondershare Video Converter

  • Popular
  • Latest
  • Today Week Month All
  • How to ‘Unblock’ multiple files at a time with PowerShell How to 'Unblock' multiple files at a time with PowerShell
  • Increase IIS Private Memory Limit to improve WSUS availability Increase IIS Private Memory Limit to improve WSUS availability
  • Command line to take ownership and change permissions Command line to take ownership and change permissions
  • Creating and editing views in phpMyAdmin Creating and editing views in phpMyAdmin
  • Configure Outlook to recurring appointments for the last weekday of the month Configure Outlook to recurring appointments for the last weekday of the month
  • How to Purchase Cryptocurrencies? How to Purchase Cryptocurrencies?
  • Top 6 necessary aspects to consider when hiring Angular developers Top 6 necessary aspects to consider when hiring Angular developers
  • Full guide on drawbacks and benefits of Node.js for making the perfect choice for your business Full guide on drawbacks and benefits of Node.js for making the perfect choice for your business
  • Benefits of End-To-End Testing That Will Match Company Expectations Benefits of End-To-End Testing That Will Match Company Expectations
  • 3 Key Features of Pets Health Monitoring Systems 3 Key Features of Pets Health Monitoring Systems
Ajax spinner

Elevator Pitch

404 Tech Support documents solutions to IT problems, shares worthwhile software and websites, and reviews hardware, consumer electronics, and technology-related books.

Subscribe to 404TS articles by email.

Recent Posts

  • How to Purchase Cryptocurrencies?
  • Top 6 necessary aspects to consider when hiring Angular developers
  • Full guide on drawbacks and benefits of Node.js for making the perfect choice for your business

Search

FTC Disclaimer

404TechSupport is an Amazon.com affiliate; when you click on an Amazon link from 404TS, the site gets a cut of the proceeds from whatever you buy. This site also uses Skimlinks for smart monetization of other affiliate links.
Use of this site requires displaying and viewing ads as they are presented.

Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in