 | [Solved] website not loading |  |
 Posted: 05/22/2007 5:13 AM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 1:24 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
| Code:
|
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 ('d88b58b8bf3e0d33624c74e46e4e9db1', 2, 1179828524, 1179828524, 'ac9f43ee', 0, 1, 0)
Line : 189
File : sessions.php
|
http://www.djpassions.com what's wrong? 
was fine when i last the left the site in a good state last sunday |
|
|
|
|
| Back to Top |
|
|
| Re: website not loading | |
| Posted: 05/22/2007 5:37 AM |
|
|
|
|
|
| Site Admin |
| Posts |
49593 |
| Word Cnt. |
2,756,445 |
| BDay |
Apr 22 |
| Sign |
Taurus |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 6:24 PM
Location: Texas
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] website not loading | |
| Posted: 05/22/2007 6:48 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:24 PM
Location: Denver, PA
|
|
|
|
|
|
Ohhhh. I don't like that error. I had to deal with that one with a friends forum. It's basically telling you that your sessions table is full, or it could be that your server limits the amount of allowed sessions per hour, and your forum has gone over that amount.
rb2ds linked you to a great article about this error with some possible ways to fix it. If you go through all of the fixes, and your still getting the error, you will need to talk to your host. You might be getting too big for your server. |
|
|
|
|
| Back to Top |
|
|
| Re: website not loading | |
| Posted: 05/22/2007 3:28 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:24 PM
Location: St Pete, FL
|
|
|
|
|
|
This is what I did to help you. I emptied the Sessions table and changed the max record count to 3000 rather than the 500 record limit that you had. Then I added the following code to your sessions.php file per the instructions that rb2d2 linked to:
OPEN
includes/sessions.php
FIND
| Code:
|
|
message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql);
|
REPLACE WITH
| 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);
}
|
Hopefully if this replacement code works as advertised, you will never encounter a session error again because it will never allow the number of records to exceed the 2500 record limit, well short of the 3000 record limit in the table itself...
The reason why this happens is because the phpBB code doesn't do a very good job of cleaning out unused records from the sessions table. Your forum is not active enough to have exceeded the limit, so the sessions table was storing a lot of garbage, which ended up causing this problem. Hopefully it won't happen again...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] website not loading | |
| Posted: 05/22/2007 7:40 PM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:24 PM
Location: Denver, PA
|
|
|
|
|
|
| Do you think we all could benefit from checking and changing our max record count? Is it 500 by default for everyone? |
|
|
|
|
| Back to Top |
|
|
| Re: website not loading | |
| Posted: 05/22/2007 11:38 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:24 PM
Location: St Pete, FL
|
|
|
|
|
|
It probably wouldn't hurt to make the changes even if you've never encountered this problem before. It's probably only a matter of time before you do and when it happens, you may not remember where to find this topic and the link explaining how to correct the problem. So it would be a bit of preventative maintanence to go ahead and do it now...
I think the default is set to 500 records when you install phpBB for the first time. I think that's standard for everyone regardless of your host. I changed it hear in RCF ages ago...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] website not loading | |
| Posted: 05/23/2007 7:39 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 8:24 PM
Location: Denver, PA
|
|
|
|
|
|
Thanks Nightrider, I will get this taken care of on all of my forums.  |
|
|
|
|
| Back to Top |
|
|
| Re: website not loading | |
| Posted: 05/23/2007 11:44 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:24 PM
Location: St Pete, FL
|
|
|
|
|
|
Sounds like a plan. This little preventative maintenance may have saved you some downtime in the future, so I'm sure it is well worth it...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] website not loading | |
| Posted: 05/24/2007 6:25 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 1:24 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Cheers guys! will report back if I get the problem again although I doubt it will happen again going by what you said Nightrider
Again cheers  |
|
|
|
|
| Back to Top |
|
|
| Re: website not loading | |
| Posted: 05/25/2007 12:15 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:24 PM
Location: St Pete, FL
|
|
|
|
|
|
I would be surprised if you ever see that error again on that forum. Please don't surprise me...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
