PDA

View Full Version : Why Does This Happen?

Beverly
08-12-2005, 05:28 PM
Over the last few days, I've occasionally been getting the following message when responding to email notifications of a thread I'm subscribed to. Is anybody else experiencing this? What's going on?

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'canreefsessions' is full

INSERT INTO canreefsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('b878d97b16c1a705e931bb53f37c967f', 526, 1123867273, 1123867273, 'a1b808f1', 8, 1)

Line : 158
File : sessions.php
Ruth
08-12-2005, 05:54 PM
Yup - me too and not always when I do the e-mail thing - sometimes it has been just signing on.
danny zubot
08-12-2005, 06:00 PM
Me three, I got it twice yesterday.
Manny
08-12-2005, 06:05 PM
happend to me this morning :evil:
Willow
08-12-2005, 10:32 PM
it means the database is getting to full and needs a purge.
Doug
08-12-2005, 11:54 PM
I,m sure Titus will check into it when he lands somewhere. :smile:
marie
08-13-2005, 01:02 AM
it means the database is getting to full and needs a purge.

Well somebody stick their fingers down its throat so we can all get back to business :razz:
Willow
08-13-2005, 02:03 AM
it seems to be getting worse, ive had phpbb go mental before, you had better get some maintance done soon of the whole database will crash.
Beverly
08-13-2005, 02:39 AM
Land, Titus, land :eek:
Doug
08-13-2005, 11:37 PM
Was it down all day for you guys also? Not sure where anyone is? And I have trouble looking after myself, let alone a website. :lol:

Titus must be chasing kangaroo,s or something. :lol:

Mind you it was doing something different today. Perhaps it was Titus. :smile:
LostMind
08-14-2005, 12:08 AM
Yah someone needs to look at the DB and clean it up. Perhaps the mysql server could use a tweak or two as well.

Hope you guys have backups :)
Beverly
08-14-2005, 12:41 AM
Today the board was totally unresponsive, until NOW :biggrin:

Glad it's back :cool:
titus
08-15-2005, 08:50 AM
Hello,

Sorry I haven't been able to go online for a few days. Please let me know if this happens again.

Titus
vanreefer
08-16-2005, 01:20 AM
Hello,

Sorry I haven't been able to go online for a few days. Please let me know if this happens again.

Titus

I was unable to access the bb all day today

The gallery was there but I got the above message when trying to go to the bb of login

Thanks
Dan
christyf5
08-16-2005, 01:33 AM
Same here. I can't get on in the mornings but evenings seem to work. :confused:
Beverly
08-16-2005, 02:10 AM
Ditto what Christy said.
Bob I
08-16-2005, 02:21 AM
It happened twice today. Once for about three hours, and the second time shorter.

.
titus
08-16-2005, 03:05 AM
Hello,

I saw the error too and have just fixed it. I don't think it'd come back again. But in case it does, please post here.

Titus
christyf5
08-16-2005, 03:29 AM
Thanks Titus!!! You rock :cool:
Funky_Fish14
08-16-2005, 03:48 AM
Yeah I was getting that for a couple days but thanks for fixing it now!

Chris
vanreefer
08-16-2005, 06:04 AM
10:45 same error.... I have the auto log in option selected... and if I close my browser; reopen it then just type the addy It will load without errors... sometimes.... I have gotten on twice this way :biggrin:

Thanks
Dan
Samw
08-17-2005, 08:38 AM
I got the error again this evening. Why is the session table getting full? Is someone flooding your session table maliciously with scripts to create sessions or is your MAX_ROWS set too low? Have you applied any of the Mods suggested from the PHPBB KB?
titus
08-17-2005, 02:01 PM
Hello,

I did the temporary fix. Didn't anticpate so many visitors to the site. Okay it should be good now.

Titus
bulletsworld
08-17-2005, 05:14 PM
eek..I'm still having problems.

Barely was able to get to this part to message you here. I still can't get into my PMs either. :sad:
titus
08-18-2005, 07:28 AM
Hello,

Are you still getting the same error message? If not, what is the message you get?

Titus
bulletsworld
08-18-2005, 09:04 PM
Yup Titus,

Still having problems. I am now able to get in my PM box but problem comes when just after loggin I click on the "Bulletin Board" tab to go into forums, which I am not able to. :frown: UNLESS, I go back and login again only to have the forums on right side load and allowed to click one forum, then error again. :frown:

Here is a copy of error (below)

__________________________________________________ ___________
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'canreefsessions' is full

INSERT INTO canreefsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('a01c31814eabe9e05c2e7eecf6221ec4', -1, 1124123367, 1124123367, '4494eddd', 0, 0)

Line : 158
File : sessions.php

__________________________________________________ __


:neutral:
christyf5
08-18-2005, 09:22 PM
Lee,

Can't you just bookmark the bulletin board itself at http://www.canreef.com/phpBB2 and go straight there to log in and stuff (unless you've already selected "keep me logged in"). I find thats the easiest. I've had problems with that main page before and now I just skip it altogether.

Christy :)
titus
08-20-2005, 06:16 AM
Hello,

Um... that's strange guys because everytime I do a login, I'd do it on the front page. After typing my login info on the right side (above the Last 10 Topics), it'd take me directly to the Bulletin Board. I'm not sure why you'd have to click Bulletin Board after login.....

Titus