Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 08:56 am EDT

Geeklog Forums

1062: Duplicate entry '0' for key 1


Status: offline

Samelborp

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

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Is that all you get? Not even a table name?

bye, Dirk
 Quote

Laney

Anonymous
blah
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

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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

Elaine

Anonymous
artistic
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

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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 08:56 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