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 » Fri Dec 05, 2008 5:26 am

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

User avatar
ameeck
Former Team Member
Posts: 6559
Joined: Mon Mar 21, 2005 6:57 pm

Re: Forum Is Down - Critical Error

Post by ameeck » Fri Dec 05, 2008 8:04 am

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 » Fri Dec 05, 2008 5:49 pm

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 » Thu Dec 18, 2008 10:12 pm

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: 65025
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Forum Is Down - Critical Error

Post by Lumpy Burgertushie » Fri Dec 19, 2008 3:53 am

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
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

hunter879
Registered User
Posts: 2
Joined: Thu Dec 18, 2008 10:02 pm

Re: Forum Is Down - Critical Error

Post by hunter879 » Tue Dec 23, 2008 12:31 pm

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”

Who is online

Users browsing this forum: No registered users and 28 guests