Error doing DB query userdata row fetch

[Devonie]

Your phpBB board URL: http://www.blazingphoenixcrew.com
Template(s) used: FIBlack
Any and all MODs: Cash_MOD, EasyMOD, Custom_Title_MOD, Last_Visited_MOD, Topic_on_Index_MOD, Separate_Announcements_and_Sticky_MOD
Do you use a port of phpBB: No
Version of phpBB: 2.0.22
Version of PHP: 4.4.4
Which database server and version: Localhost via UNIX socket/4.1.21-standard-log
Host:site5.com
Did someone install this for you/who: Fantastico
Is this an upgrade/from what to what: No
Is this a conversion/from what to what: No
Have you searched for your problem: I tried - keep getting blank results page
If so, what terms did you try: Error doing DB query userdata row fetch
State the nature of your problem: When I click "enter" on my portal page (just a simple link),**edit** this happens when I try to access the forum even when I type the forum address in, so I guess it's a Universal error, not just from that page** I get the following error:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

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

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '62d7b128d9b10d6eecd576183f0b4d2f' AND u.user_id = s.session_user_id

Line : 315
File : sessions.php

It was working fine yesterday; all I changed was the width of the forum (set it to a smaller percentage than 100%), and changed the forum currency rates.

***edit2*** I went into phpAdmin and tried to open phpbb_sessions, and got a 'could not open' error, so does that mean this file is corrupt?***
Any ideas on how to fix this?

Do you have a test account for us: No (not necessary)

thanks

[karlsemple]

1. Create a fix.php file with the following:
   

   Code: Select all

   <?php
define('IN_PHPBB', true);
include('./extension.inc');
include('./common.'.$phpEx);
$page_title = 'phpBB Fix';

$sql = array();
$sql[] = "REPAIR TABLE " . SESSIONS_TABLE . "";
$sql[] = "REPAIR TABLE " . SESSIONS_TABLE . "";
$sql[] = "REPAIR TABLE " . SESSIONS_TABLE . "";

$sql_count = count($sql);
for( $i = 0; $i < $sql_count; $i++ )
{
   if ( !($result = $db->sql_query($sql[$i])) )
   $echo .= '<b>Query ' . ($i+1) . ': </b><font color="red"><b>Error (' . mysql_error() . ')</b></font><br />';
   else
   $echo .= '<b>Query ' . ($i+1) . ': </b><font color="green"><b>Ran successfully</b></font><br />';
}
message_die(GENERAL_MESSAGE, "<table width=\"80%\" class=\"forumline\"><tr><td><u><b>Report:</b></u><br />$echo<br /><br />All queries have been run. If any errors came up above, be sure to post the report in your topic on phpBB.com.<br /><b>You should now delete this file</b></td><tr></table>");
?>

2. Upload the file to your board's root folder (the one with config.php)
3. Run it by navigating to the file in your browser (ex. http://www.yoursite.com/phpBB2/fix.php)
4. If any errors come up, post the report here.
5. Be sure to delete the file; don't leave it on your server

[Devonie]

Report:
Query 1: Ran successfully
Query 2: Ran successfully
Query 3: Ran successfully


All queries have been run. If any errors came up above, be sure to post the report in your topic on phpBB.com.
You should now delete this file

No errors.

[karlsemple]

test the forum

[Devonie]

Fixed! Thank you so much!!

D