Posted on: 08/05/03 03:31pm
By: Anonymous (Diesel)
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.
Re:User Stats Plugin problem
Posted on: 08/11/03 10:53am
By: DTrumbower
Check the table in error and check the index that is on it.
Re:User Stats Plugin problem
Posted on: 08/13/03 10:52am
By: diesel
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?
User Stats Plugin problem
Posted on: 09/19/04 10:27am
By: greenhil
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
User Stats Plugin problem
Posted on: 09/19/04 11:06am
By: Dirk