phpbb3_session is marked crashed and should be repaired

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
hardcorewillneverdie
Registered User
Posts: 22
Joined: Wed Jun 18, 2008 8:42 pm

phpbb3_session is marked crashed and should be repaired

Post by hardcorewillneverdie » Mon Sep 21, 2009 6:56 pm

Hi,

Sorry to bother you with this but can't find anything use via "search" or google

http://hardcorewillneverdie.com/index.php
SQL ERROR [ mysql4 ]

Table './hardcorewillneverdie/phpbb3_sessions' is marked as crashed and should be repaired [145]
Powweb runs phpMyAdmin - 2.8.0.1
MySQL said:

#145 - Table './hardcorewillneverdie/phpbb3_sessions' is marked as crashed and should be repaired
I can't see a repair function and not sure if I should re-install everything

Any help would be appreciated

Many thanks

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7651
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: phpbb3_session is marked crashed and should be repaired

Post by JimA » Mon Sep 21, 2009 6:58 pm

You need to run a simple SQL query to have the table to be repaired. :)

Code: Select all

REPAIR TABLE phpbb3_sessions;
More information: Executing SQL Queries in phpMyAdmin KB
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

hardcorewillneverdie
Registered User
Posts: 22
Joined: Wed Jun 18, 2008 8:42 pm

Re: phpbb3_session is marked crashed and should be repaired

Post by hardcorewillneverdie » Mon Sep 21, 2009 11:07 pm

Spot on - thank you

Any ideas what caused the error? I think I need to update the code anyways

User avatar
matt1206
Registered User
Posts: 213
Joined: Wed Mar 08, 2006 3:04 pm
Location: Sheffield, UK
Name: Matt Worthington

Re: phpbb3_session is marked crashed and should be repaired

Post by matt1206 » Tue Sep 22, 2009 12:37 am

The table crash will more than likely have been caused by a problem on the server/mysql daemon.

I had quite a problem with multiple tables crashing, and I moved to a new server (was on the old one 3 years) and have had no further issues.

Locked

Return to “[3.0.x] Support Forum”