Icy Phoenix

     
 

Home » Forum » Icy Phoenix Support » Documentation And How To

The time now is Thu 23 May, 2013 11:24 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic

DEBUG - Error Creating New Session

DEBUG - Error Creating New Session

Article
Reply with quote    Download Post  
Post DEBUG - Error Creating New Session 
 
If you are told that phpbb_session table is full and must be empty manually.

Untill you don't have problem with sessions, you shoudn't touch anything but if you want to prevent any problem, apply it

OPEN:

Code: [Download] [Hide] [Select]
include/sessions.php


FIND:

Code: [Download] [Hide] [Select]
message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql);


REPLACE WITH:

Code: [Download] [Hide] [Select]
$error = TRUE;
$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"] > 550)
        {
            $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);
}




 
Edited by Mighty Gorgon, Sun 08 Apr, 2007 11:25: Adapted the code to Icy Phoenix
Zuker - View user's profile Send private message  
Zuker [ Thu 05 Apr, 2007 15:38 ]
Sponsors
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us


DEBUG - Error Creating New Session

Comments
Reply with quote    Download Post  
Post Re: Error Creating New Session 
 
I've edited the code to Icy Phoenix.

Anyway you may even decide to convert the table from HEAP to MyISAM.

HEAP type has the advantage to remain loaded in memory, so SQL are a bit faster, but MyISAM should not have the problem listed above.

I use MyISAM...



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sun 08 Apr, 2007 11:34 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 1
 
 

Home » Forum » Icy Phoenix Support » Documentation And How To

The time now is Thu 23 May, 2013 11:24 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic




 

 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version
Generation Time: 0.1764s (PHP: 31% SQL: 69%)
SQL queries: 18 - Debug On - GZIP Enabled
Design by Mighty Gorgon