Posted on: 07/08/06 02:54pm
By: Anonymous (monoclast)
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?
Who's Online shows incorrect number of Guest Users?
Posted on: 07/08/06 04:10pm
By: Dirk
Try clearing your gl_sessions table.
bye, Dirk
Who's Online shows incorrect number of Guest Users?
Posted on: 07/08/06 06:28pm
By: Anonymous (monoclast)
[QUOTE BY= Dirk] Try clearing your gl_sessions table.
bye, Dirk[/QUOTE]
Thanks so much! That did the trick!
-mono
Who's Online shows incorrect number of Guest Users?
Posted on: 07/08/06 10:14pm
By: Anonymous (monoclast)
Whoops, it looks like I spoke too soon! 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:
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?