|
obowman
|
August 13, 2012 at 7:45 am
Hi,
I’ve had my site running fine on a local testing server, and i’ve just migrated it to a live server and i’m getting the following errors at the confirm payment page.
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT into wp_events_answer (registration_id, attendee_id, question_id, answer) values (‘502903c30b21f9.46073000’, ‘0’, ‘1’, ‘Olly’)
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT into wp_events_answer (registration_id, attendee_id, question_id, answer) values (‘502903c30b21f9.46073000’, ‘0’, ‘2’, ‘Bowman’)
WordPress database error: [Duplicate entry ‘0’ for key 1]
INSERT into wp_events_answer (registration_id, attendee_id, question_id, answer) values (‘502903c30b21f9.46073000’, ‘0’, ‘3’, ‘olly@*********.co.uk’)
Then when i try to pay with paypal i get a shopping cart is empty error.
This is very frustrating, and i’ve got my client on my back who wants this fixed.
|
|
Josh
|
August 13, 2012 at 11:40 am
Can you compare the database tables between the local server (where I assume this was working?) and the live site. What you want to to look for is the collation for these tables.
|
|
obowman
|
August 15, 2012 at 9:50 am
I’m not really sure what you mean Josh, what am i looking for?
The only difference i can see between the structure of the two tables is the cardinality in the indexes, everything else is the same.
-
This reply was modified 12 years, 3 months ago by
 obowman.
|
|
Chris Reynolds
|
August 15, 2012 at 1:59 pm
It’s not the structure that you’re looking for. It’s the collation.
|
|
obowman
|
August 15, 2012 at 3:26 pm
The collation is the same in both databases, and i’m still getting the same messages.
|
|
Chris Reynolds
|
August 15, 2012 at 3:36 pm
Duplicate entry means it’s trying to store a database value that already exists. I’m guessing that this is because it’s trying to save an Attendee ID 1 and you already have an Attendee ID 1 from the old install. Not sure why this would happen as I’ve personally migrated databases all over the place and never seen this, but you might want to try just dumping the contents of that wp_events_answer table (this just stores attendee responses to the questions, so it wouldn’t be relevant if what you had on the other server was just test data).
|
|
obowman
|
August 15, 2012 at 4:55 pm
I’ve done that, and i’ve had to set the id to auto-increment but i get the same error on other tables now. I also get a similar error when i try to add an event.
I’m thinking something else might be corrupted somewhere, because when i also can’t add posts or pages.
I’ve deleted the whole site and database a couple of times now, and it’s the same errors every time.
|
|
obowman
|
August 15, 2012 at 6:55 pm
Looks like i’ve solved this now, i was using backupbuddy to migrate the site, i updated this to the latest version migrated again, and now it works, so i guess it was a backupbuddy issue.
|
