Sub Menu
Links Menu
Online Users

In total there are 318 users online :: 2 registered, 0 hidden and 316 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot] based on users active over the past 60 minutes

phpbb sessions question

Support for IntegraMOD 140

Moderator: Integra Moderator

phpbb sessions question

PostAuthor: Driver 7 » Mon May 01, 2006 7:22 pm

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?
Last edited by Driver 7 on Mon Jul 24, 2006 7:31 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Re: phpbb sessions question

PostAuthor: Helter » Mon May 01, 2006 8:30 pm

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.
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: phpbb sessions question

PostAuthor: Driver 7 » Mon May 01, 2006 8:56 pm

Thanks bro. I'll give that a shot and see how it works out.
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

PostAuthor: Jason Sanborn » Mon May 01, 2006 9:02 pm

Wouldn't lowering the max sessions make the problem worse, not better?
Last edited by Jason Sanborn on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://images.cbreview.net/banners/cloney2.gif[/img]
Comic Book Review: Comics, Role Playing and More[/url]
User avatar
Jason Sanborn
Sr Integra Member
Sr Integra Member
 
Posts: 436
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 9:40 am
Cash on hand: 0.00
Location: Marina, CA

Re: phpbb sessions question

PostAuthor: Driver 7 » Mon May 01, 2006 9:11 pm

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.
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Re: phpbb sessions question

PostAuthor: Helter » Mon May 01, 2006 9:29 pm

it should make your max smaller, so ideally it will dump the older sessions before the table fills up
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

PostAuthor: Jason Sanborn » Tue May 02, 2006 9:03 am

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.
Last edited by Jason Sanborn on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://images.cbreview.net/banners/cloney2.gif[/img]
Comic Book Review: Comics, Role Playing and More[/url]
User avatar
Jason Sanborn
Sr Integra Member
Sr Integra Member
 
Posts: 436
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 9:40 am
Cash on hand: 0.00
Location: Marina, CA

Re: phpbb sessions question

PostAuthor: Dragonsys » Tue May 02, 2006 9:49 am

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.
Last edited by Dragonsys on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Image
User avatar
Dragonsys
Sr Integra Member
Sr Integra Member
 
Posts: 326
Likes: 0 post
Liked in: 0 post
Joined: Mon Apr 10, 2006 6:45 am
Cash on hand: 0.00
Location: Springtown, TX

PostAuthor: Jason Sanborn » Wed May 03, 2006 10:37 am

Ok, that makes sense. Thanks for clarifying for me. <img>
Last edited by Jason Sanborn on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://images.cbreview.net/banners/cloney2.gif[/img]
Comic Book Review: Comics, Role Playing and More[/url]
User avatar
Jason Sanborn
Sr Integra Member
Sr Integra Member
 
Posts: 436
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 9:40 am
Cash on hand: 0.00
Location: Marina, CA

Re: phpbb sessions question

PostAuthor: Driver 7 » Wed May 03, 2006 8:53 pm

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
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Re: phpbb sessions question

PostAuthor: Driver 7 » Wed May 03, 2006 8:58 pm

Has anyone else got Google Analytics installed? I wonder if that could be the reason why it's filling up so fast now.
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

PostAuthor: Jason Sanborn » Thu May 04, 2006 8:58 am

I don't have Google Analytics, but I do have Google AdSense, and I notice that Google bots do hit me pretty hard.
Last edited by Jason Sanborn on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://images.cbreview.net/banners/cloney2.gif[/img]
Comic Book Review: Comics, Role Playing and More[/url]
User avatar
Jason Sanborn
Sr Integra Member
Sr Integra Member
 
Posts: 436
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 9:40 am
Cash on hand: 0.00
Location: Marina, CA

Re: phpbb sessions question

PostAuthor: Driver 7 » Thu May 04, 2006 8:00 pm

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.
Last edited by Driver 7 on Mon Jul 24, 2006 6:23 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Re: phpbb sessions question

PostAuthor: Driver 7 » Sat Jul 08, 2006 8:41 am

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.
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Re: phpbb sessions question [Solved]

PostAuthor: Driver 7 » Tue Jul 18, 2006 6:50 am

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!
Last edited by Driver 7 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[img=left]http://www.btusquad.net/stuff/new_sig.gif[/img]
User avatar
Driver 7
Integra Member
Integra Member
 
Posts: 129
Likes: 0 post
Liked in: 0 post
Joined: Sun Mar 26, 2006 5:25 pm
Cash on hand: 0.00
Location: Vancouver, BC

Next

Return to IntegraMOD 140

Who is online

Registered users: Bing [Bot], Google [Bot]

cron