How can I reset "who is online: guests" counter?
Hi, I check my web-site frequently and noticed there are *always* at least 6 guests in "who is online". It is strange, because I have been observing it for about month, and it never drops below this value. I do not believe there are really at least 6 guests all the time. But number of users is counted correctly. I think the guest-counter got somehow screwed up, so how can I reset it? Jarry -- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted.
Are your block cache turned on? Att, Pablo Lacerda de Miranda Analista de Sistemas Pontifícia Universidade Católica de São Paulo pablolmiranda@gmail.com +55 11 8701-1086
On 12. 7. 2010 22:56, Pablo L. de Miranda wrote:
Are your block cache turned on?
cache is off, because it did not work well with some of my modules... Jarry -- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted.
The "sessions" table holds who is currently logged on, and this table is queried during by the User module to generate that block. You can clear that table and it should reset your counters to zero. Note that doing this will log everyone out who is logged in at the moment you clear the database and those users would have to re-log in, but otherwise should do no harm. You may want to look at the sessions expiration settings in the settings.php file, but for 6 hangers-on it's likely not a big problem. Brian On Mon, Jul 12, 2010 at 2:53 PM, Jarry <mr.jarry@gmail.com> wrote:
Hi,
I check my web-site frequently and noticed there are *always* at least 6 guests in "who is online". It is strange, because I have been observing it for about month, and it never drops below this value. I do not believe there are really at least 6 guests all the time. But number of users is counted correctly.
I think the guest-counter got somehow screwed up, so how can I reset it?
Jarry -- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted. -- [ Drupal support list | http://lists.drupal.org/ ]
-- Brian Choc Technology Director Teaming for Technology Colorado 2505 18th St. Denver, CO 80211 P: 303.561.2377, F: 303.455.6462 http://www.t4tcolorado.org
But my problem is there are always at least 6 GUESTS. Logged in users are counted correctly, but guests are not logged in... I do not know how those guests are counted, but do you think this might fix the problem? Jarry On 12. 7. 2010 23:25, Brian Choc wrote:
The "sessions" table holds who is currently logged on, and this table is queried during by the User module to generate that block. You can clear that table and it should reset your counters to zero. Note that doing this will log everyone out who is logged in at the moment you clear the database and those users would have to re-log in, but otherwise should do no harm.
You may want to look at the sessions expiration settings in the settings.php file, but for 6 hangers-on it's likely not a big problem.
Brian
On Mon, Jul 12, 2010 at 2:53 PM, Jarry <mr.jarry@gmail.com <mailto:mr.jarry@gmail.com>> wrote:
Hi,
I check my web-site frequently and noticed there are *always* at least 6 guests in "who is online". It is strange, because I have been observing it for about month, and it never drops below this value. I do not believe there are really at least 6 guests all the time. But number of users is counted correctly.
I think the guest-counter got somehow screwed up, so how can I reset it?
-- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted.
Like Brian said empty the table and take a look in your settings. Try to lower your session time. Take a moment and think about the time your users needs to stay logged in the Drupal and set this time in yout settings.php file. Pablo
Do you mean the whole `sessions` table, with all fields, or just some of them (uid, sid, hostname, timestamp, cache, sesssion)? Should I use "TRUNCATE TABLE" or "DROP TABLE" (phpmyadmin)? I'm a little bit scared, because I'm not familiar with mysql and I do not want to do something wrong. Are you sure this table will be re-created later, when needed? Jarry On 12. 7. 2010 23:25, Brian Choc wrote:
The "sessions" table holds who is currently logged on, and this table is queried during by the User module to generate that block. You can clear that table and it should reset your counters to zero. Note that doing this will log everyone out who is logged in at the moment you clear the database and those users would have to re-log in, but otherwise should do no harm.
You may want to look at the sessions expiration settings in the settings.php file, but for 6 hangers-on it's likely not a big problem.
Brian
On Mon, Jul 12, 2010 at 2:53 PM, Jarry <mr.jarry@gmail.com <mailto:mr.jarry@gmail.com>> wrote:
Hi,
I check my web-site frequently and noticed there are *always* at least 6 guests in "who is online". It is strange, because I have been observing it for about month, and it never drops below this value. I do not believe there are really at least 6 guests all the time. But number of users is counted correctly.
I think the guest-counter got somehow screwed up, so how can I reset it?
-- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted.
You must use "TRUNCATE TABLE 'sessions'", if you use DROP TABLE the table will be removed from database. And you want just clean the table. Pablo
You can also delete the anonymous sessions only by running this query: DELETE FROM sessions WHERE uid=0; Jamie Holly http://www.intoxination.net http://www.hollyit.net On 7/13/2010 12:36 PM, Pablo L. de Miranda wrote:
You must use "TRUNCATE TABLE 'sessions'", if you use DROP TABLE the table will be removed from database. And you want just clean the table.
Pablo
participants (4)
-
Brian Choc -
Jamie Holly -
Jarry -
Pablo L. de Miranda