Welcome to Geeklog, Anonymous Sunday, October 06 2024 @ 10:29 am EDT

Geeklog Forums

1062: Duplicate entry '921165255' for key 1. SQL in question:


Status: offline

xardoz

Forum User
Regular Poster
Registered: 02/24/04
Posts: 98
Help! I'm getting these errors in my error.log and I'm not sure what they are or how to track them down!
Text Formatted Code
Tuesday, May 4, 2004 11:45:27 - 1062: Duplicate entry '921165255' for key 1. SQL in question:  
Tuesday, May 4, 2004 11:45:27 - 1062: Duplicate entry '921165255' for key 1. SQL in question:  
Tuesday, May 4, 2004 11:45:27 - 1062: Duplicate entry '921165255' for key 1. SQL in question:  
Tuesday, May 4, 2004 11:48:25 - 1062: Duplicate entry '532697189' for key 1. SQL in question:  

 


I THINK they may be associated with the Weather block plugin v.2, but I'm not sure.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Those are harmless (and not caused by the weather plugin).

Geeklog uses random numbers for session ids for anonymous users (as anon. users don't really have sessions) and sometimes, the selected number already serves as the session id for someone else and the result is that error message.

Actually, those error messages shouldn't show up in error.log in the first place, as Geeklog catches the error and simply assigns another random session id then. Have to look into this ...

For now, you can safely ignore them.

bye, Dirk
 Quote

Status: offline

xardoz

Forum User
Regular Poster
Registered: 02/24/04
Posts: 98

That is certainly a relief.
Thanks!
 Quote

Status: offline

languageaddict

Forum User
Newbie
Registered: 03/11/05
Posts: 1
confused
I'm running version 1.3.11 with forum version 2.3.2 but I had something really odd happen. A user of my site deleted their account and now logged-in users can no longer read forum posts. Guest users can read without a problem. I also get this error on submitting a post to the forum:

Fri Mar 11 15:02:30 2005 - 1062: Duplicate entry '3' for key 3. SQL in question: INSERT INTO gl_forum_log (uid,forum,topic,time) VALUES ('2','3','267','1110571350')

Is there a way to fix this without blasting the whole database? I do regular backups, but would lose a lot of data...

Thanks,
TOm
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Your problem is unrelated to the one above. I'd suggest you bring it to Blaine's attention.

bye, Dirk
 Quote

All times are EDT. The time is now 10:29 am.

  • 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