Page 1 of 2

phpbb sessions question

PostPosted: Mon May 01, 2006 7:22 pm
Author: Driver 7
OK. I have just about had it with the sessions table.

It's constantly filling up. It used to fill up like once a month, but over the last month or so it has been filling up constantly. About every 3 or 4 days.

Does anyone else have this problem? or advice?

Re: phpbb sessions question

PostPosted: Mon May 01, 2006 8:30 pm
Author: Helter
were having that problem here too. I did go to ACP/security/configuration and lower the max sessions from 50 to 30. So far so good.

Re: phpbb sessions question

PostPosted: Mon May 01, 2006 8:56 pm
Author: Driver 7
Thanks bro. I'll give that a shot and see how it works out.

PostPosted: Mon May 01, 2006 9:02 pm
Author: Jason Sanborn
Wouldn't lowering the max sessions make the problem worse, not better?

Re: phpbb sessions question

PostPosted: Mon May 01, 2006 9:11 pm
Author: Driver 7
The explanation for that setting says "If your sessions table gets bigger than this number, the mod will automatically get it below this number."

So it is not actually changing the size of your Max settings I dont think.

Re: phpbb sessions question

PostPosted: Mon May 01, 2006 9:29 pm
Author: Helter
it should make your max smaller, so ideally it will dump the older sessions before the table fills up

PostPosted: Tue May 02, 2006 9:03 am
Author: Jason Sanborn
That is true, but that would also cause users to be logged out unexpectedly, correct? That is an issue my users are experiencing, so I actually upped my count from 50 to 100 to stop it.

Re: phpbb sessions question

PostPosted: Tue May 02, 2006 9:49 am
Author: Dragonsys
The problem is that some ppl's DB has a limit on the sessions table. When this limit is reached you get the above error.

Therefore, if you are getting this error, then you cannot up the limit, you must decrease it.

PostPosted: Wed May 03, 2006 10:37 am
Author: Jason Sanborn
Ok, that makes sense. Thanks for clarifying for me. <img>

Re: phpbb sessions question

PostPosted: Wed May 03, 2006 8:53 pm
Author: Driver 7
Damn. When I made the first post. It was May 1st at 7:22 pm. That was right after I went to phpMyAdmin and emptied the sessions. I just had to do it again. wtf man this is retarted. just 2 days and it's full.

arghhhhhhhhhh

Re: phpbb sessions question

PostPosted: Wed May 03, 2006 8:58 pm
Author: Driver 7
Has anyone else got Google Analytics installed? I wonder if that could be the reason why it's filling up so fast now.

PostPosted: Thu May 04, 2006 8:58 am
Author: Jason Sanborn
I don't have Google Analytics, but I do have Google AdSense, and I notice that Google bots do hit me pretty hard.

Re: phpbb sessions question

PostPosted: Thu May 04, 2006 8:00 pm
Author: Driver 7
I did have As Sence. But I got fired because my squad members would click the ad's 4 or 5 times a day. And I have over 100 members in my squad. lol. I guess Google did not like seeing the same IP's clicking the ad's over the period of a year! The crappy thing was I had kept my earnings in my google account and when they fired my ass they took all the money away. Was over $500.00. But whatever.

I will see if my sessions last longer then this weekend and if it does not then I will remove Anylitics and see if that makes the difference.

Re: phpbb sessions question

PostPosted: Sat Jul 08, 2006 8:41 am
Author: Driver 7
I think I found a solution finally for my sessions problem.

It seems to be working for me now.

I went to php my admin and under operations for the sessions table, I changed the table type from HEAP to MYISAM.

Perhaps anyone having the same problem could try this and see if it works for them.

Re: phpbb sessions question [Solved]

PostPosted: Tue Jul 18, 2006 6:50 am
Author: Driver 7
It has been well over a week since I changed the table to MYISAM and it's not giving me any problems what so ever.

Problem solved!