Support

Home Forums Event Espresso Premium Payment Issues after Migrating the site

Payment Issues after Migrating the site

Posted: August 13, 2012 at 7:45 am


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

  • Support Staff

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 11 years, 8 months ago by  obowman.


Chris Reynolds

  • Support Staff

August 15, 2012 at 1:59 pm

It’s not the structure that you’re looking for. It’s the collation.

enter image description here


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

  • Support Staff

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.

The support post ‘Payment Issues after Migrating the site’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso