Forum Is Down - Critical Error

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
ericidlewild
Registered User
Posts: 123
Joined: Wed Mar 08, 2006 12:48 am

Forum Is Down - Critical Error

Post by ericidlewild »

So, I tried to go to my forum today and got this message:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_sessions.MYI' (errno: 145)

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('1009c9911bea6be3717b45b58f1327b1', 2, 1228454494, 1228454494, '440375d1', 0, 1, 0)

Line : 187
File : sessions.php


I don't know if it's version 2.0, I believe it is. All help with this matter is appreciated.
Last edited by ric323 on Tue Dec 23, 2008 7:35 pm, edited 2 times in total.
Reason: Topic icon changed
ameeck
Former Team Member
Posts: 6559
Joined: Mon Mar 21, 2005 6:57 pm

Re: Forum Is Down - Critical Error

Post by ameeck »

Run this query on your database:

Code: Select all

REPAIR TABLE phpbb_sessions;
ericidlewild
Registered User
Posts: 123
Joined: Wed Mar 08, 2006 12:48 am

Re: Forum Is Down - Critical Error

Post by ericidlewild »

Yay, that worked, thanks so very much!
hunter879
Registered User
Posts: 2
Joined: Thu Dec 18, 2008 10:02 pm

Re: Forum Is Down - Critical Error

Post by hunter879 »

Got the same error a few days ago, also ill have to admit im rather dumb when it comes to database stuff.

Just how do I run a query on the database? Not sure if I got the rights to do so either.

Any help or advice would be appricated.



Edit:

Sorry, Not quite same error but similar file.
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 145 Table './olsen_john_me_u/phpbb_sessions' is marked as crashed and should be repaired

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('f296d9fc0c6f70bf1b5116ba983c5491', -1, 1229641128, 1229641128, '50592bb8', 0, 0, 0)

Line : 187
File : sessions.php
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Forum Is Down - Critical Error

Post by Lumpy Burgertushie »

same process.

you go to your hosting control panel, find the program that is for accessing/maintaining your databases.

( this is usually phpmyadmin )

access that program, find the place where you enter SQL statements. ( if phpmyadmin, it will be a tab marked SQL )

paste this into that text box and click the go button:

Code: Select all

REPAIR TABLE phpbb_sessions;
if phpbb is not the prefix for your tables ( look around in phpmyadmin to see ) then edit the query accordingly.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
hunter879
Registered User
Posts: 2
Joined: Thu Dec 18, 2008 10:02 pm

Re: Forum Is Down - Critical Error

Post by hunter879 »

Lumpy Burgertushie wrote:same process.

you go to your hosting control panel, find the program that is for accessing/maintaining your databases.

( this is usually phpmyadmin )

access that program, find the place where you enter SQL statements. ( if phpmyadmin, it will be a tab marked SQL )

paste this into that text box and click the go button:

Code: Select all

REPAIR TABLE phpbb_sessions;
if phpbb is not the prefix for your tables ( look around in phpmyadmin to see ) then edit the query accordingly.


robert
Yea that worked fine, once I read abit on the host website about how to gain access.
The code worked, so thanks for the help.
Locked

Return to “2.0.x Support Forum”