Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 08:27 am EST
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!
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.
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.
11
6
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
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
8
6
Quote
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
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
9
8
Quote
All times are EST. The time is now 08:27 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