Error creating new session

Moderator: The Merrimack Volunteer Moderators

Error creating new session

Postby chrisorteg » Wed Jul 26, 2006 9:08 am

In the past week, fairly consistently each morning, I've received the error below when trying to access the site. Has anybody else experienced this?

As someone who works with databases, it would appear that each day a little more space is being added to the table that keeps track of sessions or old sessions are purged out (or perhaps a little of both) in order to keep things going for that day.

Is there a longer term fix planned?

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 ('6ffdfb1826038b4e80c1547e7ffa524a', -1, 1153914878, 1153914878, 'c0dff306', -1, 0, 0)

Line : 187
File : sessions.php
Christopher S. Ortega
chrisorteg
 
Posts: 212
Joined: Sat Jan 04, 2003 12:34 pm

Postby Nat Fairbanks » Wed Jul 26, 2006 10:28 am

Here's a synopsis of the problem.

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

At one point I had implemented the "Automatic table emptying script" suggested in the article. However that got overwritten in one of the upgrades to the forum software to patch security holes. Even still the session table should not be filling up daily unless the site is getting hit hard by automated scripts attempting to register spam accounts with registration information designed to increase their google page rank. I have managed to keep those code changes in place during the past few software upgrades.

-Nat
Nat Fairbanks
 
Posts: 1020
Joined: Wed Nov 20, 2002 1:05 am
Location: Merrimack NH

Postby chrisorteg » Wed Jul 26, 2006 11:10 am

Thanks Nat.
Christopher S. Ortega
chrisorteg
 
Posts: 212
Joined: Sat Jan 04, 2003 12:34 pm


Return to Forum Software Information

Who is online

Users browsing this forum: No registered users and 1 guest

cron