help needed

[Gizmo]

Ok I have had the site for ages well just about to start our third year and someone else normally looks after the techy side of things but he is away. Anwyay we had a CPU issue for about 2 hours and now we cannot open any threads of forums as this comes up.

SQL requests not achieved

DEBUG MODE

SQL Error: 144 Table './offsider_forums/phpbb_posts_text' is marked as crashed and last (automatic?) repair failed

SQL Request: SELECT p.*, pt.post_subject, pt.post_sub_title, pt.post_text, pt.bbcode_uid FROM phpbb_posts p, phpbb_posts_text pt WHERE p.topic_id = 43839 AND pt.post_id = p.post_id ORDER BY p.post_time, p.post_id LIMIT 0, 30

Line : 400
File : class_posts.php

I am guessing its similer to what happend around xmas and a script has been updated on server and our one is not compatable to it?

How can I fix it and please talk in english so idiot here can understand it

Thanks in advance

[Division]

Did you attempt or have you previously added any modifications to your PHPBB forum? Without knowing this it would be hard to give an exact answer.

I would certainly take the time to go to the phpbb forums http://www.phpbb.com/community/?sid=...a607b89da220eb and asking there, chances are someone there will be able to provide more information.

Curious is this problem still occuring?

[Reverend]

The first part of that says the table in the database is crashed. Nothing to do with any updates or server changes.

In your CPanel, click on the PHPMyAdmin icon and select your database. Then select that crashed table and use the drop-down menu option to repair (You'll probably want to run a repair on the entire database and optimize it as well).

If that fails to repair it, try importing the sql file from a backup (I assume you have backups of your databases). If not, ask Support if they have a backup of that particular database. If they do (not guaranteed) they should have no problems restoring that database.

Other than that, I'm not certain what you could do.

Edited to add: You may also want to consider, at least temporarily, switching away from FastCGI if you're using it. I'm not sure why, but FastCGI has been causing some problems lately.

[Gizmo]

Cheers for the replies

Its happened again we were back up for about 24 hours

I will see if I can do what Reverend said

As for back ups thats what the other lad does whenever he adds updates etc,I leave him to do it

[Division]

There is a PHPBB modification, Well not so much focused for phpbb but it works for it, and it takes automatic backups, That could be something you may want to look at.