Posted: 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.
— — Dumping data for table
#1054 – Unknown column 'is_primary' in 'field list'
Any advice with this would be appreciated. Thank you.
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.
@sidney tried it still won’t take.
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/.
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.