Diesel

Anonymous
magical
Hello. I have made the move over to GL and am currently running the new version 1.3.8. I installed the User Stats plugin (which is great by the way) and was working fine until this morning. I opened up my home page to the error \"1062: Duplicate entry \'Aug\' for key 3\". I logged into mysql via the shell and disabled the plugin and then I was able to access my home page. In that table, obviously Aug is going to be in there more than once every time I get a hit this month, so I guess I am at a loss for a solution. Any help is appreciated.

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
Check the table in error and check the index that is on it.

Status: offline

diesel

Forum User
Junior
Registered: 08/05/03
Posts: 32
confused
I did check that. The index was on the month field and it was a MUL index. I believe that if I were to remove the index, this would cause very long select queries and run my CPU and memory through the roof. I could be wrong though. Does this help?

Status: offline

greenhil

Forum User
Chatty
Registered: 07/20/04
Posts: 51
i gather there is a user stats plugin...but where can i find it? doesnt seem to be posted on gl.net anymore...??

specifically, i am looking for a plugin or hack that will allow me to easily see you is the most active user by the week and/or month, etc...

any help appreciated.

Jonathan

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073