error

phpBB : Critical Error
and
SQL Error : 1114 The table phpbb_sessions is full

solution in inlogic

phpBB : Critical Error

Error creating new session

Solution: This should be due to the sessions table for the forum being full. So new sessions cannot be opened.
The following fix works. Open includes/sessions.php and find the following code (line 152).

Code:
----------------------------------------------
message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql);
----------------------------------------------
Replace this with the following code.

Code:
----------------------------------------------
$error = TRUE;
if (SQL_LAYER == "mysql" || SQL_LAYER == "mysql4")
{
$sql_error = $db->sql_error($result);
if ($sql_error["code"] == 1114)
{
$result = $db->sql_query('SHOW TABLE STATUS LIKE "'.SESSIONS_TABLE.'"');
$row = $db->sql_fetchrow($result);
if ($row["Type"] == "HEAP")
{
if ($row["Rows"] > 2500)
{
$delete_order = (SQL_LAYER=="mysql4") ? " ORDER BY session_time ASC" : "";
$db->sql_query("DELETE QUICK FROM ".SESSIONS_TABLE."$delete_order LIMIT 50");
}
else
{
$db->sql_query("ALTER TABLE ".SESSIONS_TABLE." MAX_ROWS=".($row["Rows"]+50));
}
if ($db->sql_query($sql))
{
$error = FALSE;
}
}
}
}
if ($error)
{
message_die(CRITICAL_ERROR, "Error creating new session", "", __LINE__, __FILE__, $sql);
}

*******************************************
Upgrade phpbb manually
http://forums.liquidweb.com/archive/index.php/t-345.html
How to upgrade:

1. BACKUP your CURRENT board
2. Download the full package
3. unzip it
4. delete: config.php /templates (and everything underneath it) from the version which you just unzipped
5. upload the files, overwriting everything
6. go to install/update/update_to_latest.php
7. if all is well, delete the /install and /contrib directories.
*******************************************