Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 05:00 am EDT

Geeklog Forums

Who's Online shows incorrect number of Guest Users?


monoclast

Anonymous
confused
I recently upgraded to GeekLog 1.4.0 sr3, and I notice now that the Who's Online block consistently shows one more Guest User online than there really is.

For instance, if I block access to the web log so that only I have access, restart apache, and view the site, it shows TWO guest users logged in! If I then log into geeklog, Who's Online lists my logged in user name and ONE Guest User.

How do I go about fixing this?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Try clearing your gl_sessions table.

bye, Dirk
 Quote

monoclast

Anonymous
Quote by Dirk: Try clearing your gl_sessions table.

bye, Dirk


Thanks so much! Very Happy That did the trick!

-mono
 Quote

monoclast

Anonymous
Whoops, it looks like I spoke too soon! Sad Clearing the gl_sessions table only fixed things temporarily. After I left the server alonee for a while and came back, the problem is back again.

I noticed something that may give a clue as to why this is happening. If I use phpMyAdmin to examine the Indexes of the gl_session table, here is what my Indexes look like for this table:

Text Formatted Code

Keyname         Type            Cardinality     Field
----------------------------------------------------------
PRIMARY         PRIMARY         2               sess_id
sess_id         INDEX           2               sess_id
start_time      INDEX           2               start_time
remote_ip       INDEX           2               remote_ip

 


There is a phpMyAdmin alert just under the Indexes section:

"PRIMARY and INDEX keys should not both be set for column 'sess_id'."

What does this mean? Should the first index entry with the key named "PRIMARY" be there? Could this be the cause of my problem?
 Quote

All times are EDT. The time is now 05:00 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content