Devamlı Şöyle Sql Hatası Alıyorum Yardım

14-09-2006, 17:40:41

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'phpbb_sessions' is full

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('4df61b8206f2afd2a3594a4e17806a56', -1, 1157780692, 1157780692, '556c3e67', 0, 0, 0)

Line : 187
File : sessions.php

Arkadaslar Nerdeyse Haftada Bir kez Böyle Hata Alıyorum ve phpbb_sesions tablosunu bosaltınca düzeliyor neden böyle bi hata verebilir veya düzeltme Yolu Varmıdır İyi Günler

15-09-2006, 03:39:04

#2

Alexis

How to fix the dreaded 'phpbb_sessions' is full error. Also has information on HEAP and MyISAM tables, sessions and why the error occurs in the first place.

http://www.phpbb.com/kb/article.php?article_id=42

15-09-2006, 10:06:42

#3

KariZMa

Automatic table emptying script

This fix is the first one you should try and nearly always works. Thanks to Ashe for writing it and morpheus2matrix for providing it. Open includes/sessions.php using a text/code editor such as Wordpad, 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" || $row["Engine"] == "MEMORY")
{
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);
}

Orda Bu Yazıyor Bunla Düzeltebilir miyim Alexis

15-09-2006, 11:27:26

#4

~~Likeliness~~

Üyeliği durduruldu

message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql);

bunu bul

$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" || $row["Engine"] == "MEMORY")
{
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);
}

bununla değiştirip dene.

19-09-2006, 14:25:40

#5

KariZMa

Hocam Yinede Saol O kAdarını anladım bul değişi sadece işe Yararmı diye Sordum denedim Suan için Bi sorun yok