Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 08:16 pm EDT

Geeklog Forums

User Stats Plugin problem


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.
 Quote

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.
 Quote

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?
 Quote

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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Visitor Stats plugin

bye, Dirk
 Quote

All times are EDT. The time is now 08:16 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content