Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. MySQL duplicate entry error

MySQL duplicate entry error

1 Nov 13, 2006 19:47    

Your b2evolution version: 1.8.5
Your level of knowledge of Internet technologies: Basic Knowledge
Link to your b2evolution blog: http://www.i4veritas.com/blogs

PHP Version:
MySQL Version:

What actions led up to your current issue?
[/i]

g>What have you tried to solve the issue?
[i]

Description and Message

I've seen a couple threads on duplicate entry errors related to the hitlog, but none that directly address my problem.

When someone other than a blog member trys to visit the blog, they get the following error:
Duplicate entry '1800709' for key 1(Errno=1062)

Your query:

INSERT INTO evo_sessions( sess_key, sess_lastseen, sess_ipaddress )

VALUES (
"ZBliUiM0cJzVtqvB8YOMgjCjVjI9Nw4y",
"2006-11-08 07:05:14",
"24.173.98.17"
)

Does anyone know what my problem with the evo_sessions table might be?

Back to top

2 Nov 13, 2006 20:52

Have you fixed it? I did not get the error, but the session ID 1801082.

The sess_ID field is the field the error refers to ("key 1").

This should not happen at all.. sess_ID is an AUTO_INCREMENT field, so it should get the next free number..

Back to top

3 Nov 13, 2006 21:25

blueyed wrote:

Have you fixed it? I did not get the error, but the session ID 1801082.

The sess_ID field is the field the error refers to ("key 1").

This should not happen at all.. sess_ID is an AUTO_INCREMENT field, so it should get the next free number..

Yes, I fixed it. The session table was corrupted and needed to be repaired.

Back to top

4 Nov 19, 2006 18:22

I have to same problem...
You can check it at www.azso.hu
Please check it and tell very detailed, what should I do as a repair action!

Thanks in advance!

Back to top

5 Nov 19, 2006 18:32

Go with phpMyAdmin to your database, select the evo_hitlog table and repair it.

Back to top

6 Nov 19, 2006 18:38

blueyed wrote:

Go with phpMyAdmin to your database, select the evo_hitlog table and repair it.

OK, I have the phpmyAdmin. I see the table.
Can you be more specific, how should I repair it?

Thanks in advance...

Back to top

7 Nov 19, 2006 18:56

Go to the databse view, which shows all the tables. Click the checknox next to the one you want to repair, and choose "Repair" in the "With selected" dropdown.

Back to top

8 Nov 19, 2006 19:07

blueyed wrote:

Go to the databse view, which shows all the tables. Click the checknox next to the one you want to repair, and choose "Repair" in the "With selected" dropdown.

Coool. It's working.
There was two tables to repair, evo_hitlog and evo_sessions.

Thanks for your help. You're great.

Back to top


Form is loading...