Posted: December 31, 2014 at 9:47 am
|
There is a registration record that was created in EE3, and we want to delete it. The price is listed as: |
Hi Lawrence, Can you try updating the matching transaction record first? |
|
|
I found the matching transaction record (price was “free”), but I do not see an option to “update” |
Hi Lawrence, Was the site running Event Espresso 3.1.36 before the migration, or was this running a lower version like 3.1.30? |
|
|
Version: 3.1.30.5P |
Hi Lawrence, The migration scripts were built to migrate data from EE 3.1.36 or greater to EE4. The error message indicates something was not converted over correctly, which could be more than just this one registration. If you’re familiar with phpmyadmin, it may help to look in the _esp_ticket table to see if there’s any tickets that don’t have a value for TKT_name. If not, if you can send detailed log in credentials via our secure form someone from support can take a look. If you need to send credentials please send them via the contact form on this page: |
|
|
I looked in that one table, but I do not see anything wrong. I have sent you credentials to login. Thank you. |
Hi Lawrence, It turns out that we do need FTP credentials or access to your server’s PHPmyadmin to look at the database. Can you resend those credentials and include either of the above? |
|
Hi there, I checked the tables and there are 18 registrations that aren’t associated with any tickets. You can do a quick fix for this by running a SQL query in the phpmyadmin interface. Here’s an example query you can use: https://gist.github.com/joshfeck/4d9f80ac65ff67bc31fa The above linked query will make it so the un-associated registrations (due to not updating to EE 3.1.36 before migrating to EE4) will become associated with a ticket. We recommend backing up the database before doing any database work. |
|
|
This seems to have corrected the error. Thank you very much. |
Hi Lawrence, Thanks for confirming. If you need help with anything else, be sure to create a new support post via our support forums: https://eventespresso.com/support/forums/ — |
|
The support post ‘Can't delete old registration’ 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.