Support

Home Forums Event Espresso Premium Attendees import FAILS. Trying to import database backup into phpMyAdmin. Help!

Attendees import FAILS. Trying to import database backup into phpMyAdmin. Help!

Posted: June 29, 2013 at 1:02 am

Viewing 3 reply threads


Jonathan P Ledbetter

June 29, 2013 at 1:02 am

I’m in the process of recreating a website that failed to update properly. Website is using version 3.1.17.P. I know this is outdated, upgrading breaks the website design so I’m in the process of redesigning and using event espresso to build the registration from the ground up.

The current issue is importing eventespresso data via phpMyAdmin. This is the error I am getting.

SQL query:

— — Dumping data for table wp_events_attendee — INSERT INTO wp_events_attendee (id, registration_id, is_primary, lname, fname, address, address2, city, state, zip, country_id, organization_name, vat_number, email, phone, date, price_option, orig_price, final_price, quantity, total_cost, amount_pd, coupon_code, payment, payment_status, txn_type, txn_id, payment_date, event_id, event_time, end_time, start_date, end_date, attendee_session, transaction_details, pre_approve, checked_in, checked_in_quantity, hashSalt) VALUES (11, '4f43b526328a41.96641902'……………there is more, but it starts to show random attendee data.

MySQL said:

#1054 – Unknown column 'is_primary' in 'field list'

Any advice with this would be appreciated. Thank you.


Sidney Harrell

June 29, 2013 at 9:38 pm

In phpmyadmin, go to the attendee table, go to the “structure” tab. Scroll down to where you see: “Add column(s) At End of Table At Beginning of Table After “. Select “after” and put the new column after the “hash salt” field. Make the new field so that it’s name is “is_primary”, it’s type is tinyint, it can be null, and it’s default is 0. Then try your import again.


Jonathan P Ledbetter

July 2, 2013 at 2:06 pm

@Sidney tried it still won’t take.


Josh

  • Support Staff

July 3, 2013 at 8:30 am

Hi Steve,

I’m not sure why this would not work. One thing you could try since you’re importing data into a new install would be to start with a fresh install (no Event Espresso tables added) import the db, then run the Event Espresso install. That will update the tables automatically when the installation scripts run.

With the issues you’re having with the site’s design: You can disable the themeroller option in Event Espresso>Template settings. These were added after 3.1.17 and may be causing the issues with the layout. You can also override the current version’s base style that it loads up as well, and add in the styles that 3.1.17 had.

Basically what you do is copy the stylesheets that you were using in Event Espresso 3.1.17.P into a file named espresso_default.css and upload it to /wp-content/uploads/espresso/templates/css/.

Viewing 3 reply threads

The support post ‘Attendees import FAILS. Trying to import database backup into phpMyAdmin. Help!’ 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