Geeklog Forums

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.

Check the table in error and check the index that is on it.

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?

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

Visitor Stats plugin

bye, Dirk