Welcome to Geeklog, Anonymous Sunday, July 20 2025 @ 12:25 am EDT

Geeklog Forums

1062: Duplicate entry '0' for key 1


Status: offline
Forum User
Newbie
Registered: 10/03/03
Posts: 12
Hi!

I am upgrading from the rather old 1.3.8-1 to 1.3.11sr1

I get this error:

Text Formatted Code
1062: Duplicate entry '0' for key 1
 


Any idea?

 Quote

Status: offline
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Is that all you get? Not even a table name?

bye, Dirk
 Quote

I am getting that very same error, followed byt a table name and the table fields listed with the values.

it says:
insert into orders (.... fields.....) values (.... values....)

 Quote

Status: offline
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Quote by Laney: I am getting that very same error, followed byt a table name and the table fields listed with the values.

Well, it would have been nice and helpful of you to quote them then ...

bye, Dirk
 Quote

I am sorry, I didn't quote them because the values had actually real information in them, like name, address, phone number, email, etc.

However, I was told to do this:
"ChHange the order id field in the orders table to auto-increment."

I haven't tried that yet. I am not the least comfortable with editing the database... I will try it today though, and will post here...

thanks Dirk!

Elaine
 Quote

Status: offline
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
If the name of the table is really "orders" then that's not one of Geeklog's tables anyway. Sounds like OSCommerce or some such add-on.

bye, Dirk
 Quote

All times are EDT. The time is now 12:25 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