Support

Home Forums MailChimp Integration This registration step could not be completed

This registration step could not be completed

Posted: July 2, 2018 at 6:03 am


PropertyNL PropertyNL

July 2, 2018 at 6:03 am

Hi,

We just installed the Mailchimp add-on to our website to get people added to a Mailchimp list after registering, and set it up on this event:
https://investment-briefings.propertyeu.info/events/global-capital-flows-briefing-4/

Now on that particular event, after submitting the credentials, the error ‘This registration step could not be completed’ pops up. People don’t get redirected to the thank-you-page.

I tested a different event: https://investment-briefings.propertyeu.info/events/netherlands-investment-briefing/ which does in fact work.

So I looked around the forums and found memory limit could cause this. So I defined 128M on memory in the wp-config. However that didn’t take effect.
We run on WP Engine so caching could be a thing as well, but this has been addressed already way back. This error now only pops up for this event and so we suspect Mailchimp Add-on to be the cause.

What did we do wrong? We selected a list for this event, all fields are connected. There are no groups (tested WITH groups as well but didn’t make a difference).


PropertyNL PropertyNL

July 2, 2018 at 6:05 am

Btw the attendee does get an e-mail confirming his registration. So in fact only the redirection part doesn’t do its job.
However no Mailchimp opt-in is being sent.


Tony

  • Support Staff

July 2, 2018 at 6:39 am

Hi there,

That error is a general error that just means EE didn’t get the response it was expected at some point and it usually means a fatal error is being thrown, we’ll need that full error to know what the problem is.

WPEngine usually show you the error logs in the control panel, can you check there and see if any errors are shown from EE?

Or if you add this bit of code:

https://eventespresso.com/wiki/troubleshooting-checklist/#wpdebug

to your wp-config.php file we can run a test to see if the error then gets captured.


PropertyNL PropertyNL

July 3, 2018 at 5:53 am

This error keeps coming back in WP Engine’s error logs:

[Mon Jul 02 03:22:36.208238 2018] [:error] [pid 22810] [client 66.249.66.72:61234] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT path FROM wp_ngg_gallery WHERE gid = /* From [investment-briefings.propertyeu.info/events/expo-real-e-commerce-logistics-investment-briefing/] in [/nas/content/live/propertyeu/wp-content/themes/PropertyEU_SB/functions.php:1432] */ made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/PropertyEU_SB/single-espresso_events.php’), include_once(‘/themes/PropertyEU_SB/template-past-event-detail.php’), peu_get_nggallery_picture_url, peu_get_nggallery_path


Tony

  • Support Staff

July 3, 2018 at 6:08 am

Any others? I don’t think that relates to this issue.


PropertyNL PropertyNL

July 3, 2018 at 6:49 am

Yes, got this one which seems more relevant, from WP’s Debug log:

[03-Jul-2018 12:52:37 UTC] PHP Fatal error: Call to a member function name() on null in /nas/content/live/propertyeu/wp-content/plugins/eea-mailchimp/includes/EE_MCI_Controller.class.php on line 404


Tony

  • Support Staff

July 3, 2018 at 7:03 am

Yes, that’s the problem.

Ok, I’m going to need to take a look in the admin as that error is from trying to pull in the attendees country name and getting no country to pull it from.

Can you send me temporary login details over so I can take a look?

If so you can use this form: https://eventespresso.com/send-login-details/


PropertyNL PropertyNL

July 3, 2018 at 7:17 am

All right I filed the login details.


Tony

  • Support Staff

July 3, 2018 at 8:18 am

The problem is that your sites system question ‘Country’ has been changed to a text box rather than a dropdown but EE doesn’t allow you to change the system question field types.

Did you manually change that question type in the database?


PropertyNL PropertyNL

July 4, 2018 at 1:36 am

I don’t think so. Might have something to do with the migration to EE4 a couple of years ago.
Is the solution to revert this back to a dropdown via db? Only problem then would be that I would have to know the db value that contains all countries.


PropertyNL PropertyNL

July 4, 2018 at 6:00 am

Also, what I found, is that if you look at this list, there’s all sorts of weird country names in the list:

https://investment-briefings.propertyeu.info/wp-admin/admin.php?page=espresso_general_settings&action=country_settings&country_settings_nonce=fde15738e5&return=country_settings

Thought it might give you an extra clue.


Tony

  • Support Staff

July 4, 2018 at 10:00 am

Also, what I found, is that if you look at this list, there’s all sorts of weird country names in the list

That can happen when the EE3 country question was repurposed to something else, there’s phone numbers as countries in your list so as an example the country question may have been swapped out for phone number at one point (or the user just entered the phone number in that section).

Is the solution to revert this back to a dropdown via db? Only problem then would be that I would have to know the db value that contains all countries.

There isn’t a single DB value for this, EE knows that questions of type COUNTRY pull the values from the _esp_country table in the DB. The problem is going to be with how your current country questions relate to the ‘correct’ country question type.

Are you comfortable editing the DB?

Do you have a development copy of the site? If not I recommend creating one from the current version and testing any fixes on this there as you may find registrations/contacts throw fatal errors anywhere they pull the country details in once this is fixed.

If you are comfortable editing the database you can try changing the QST_type of Country - System Question to COUNTRY in the esp_question table.

Then confirm that you can view registrations and contacts within the admin and run a test registration to confirm that also works.

I highly recommend creating a database backup before you make any changes just to be safe.


PropertyNL PropertyNL

July 6, 2018 at 7:30 am

Thanks. Concerning this:

If you are comfortable editing the database you can try changing the QST_type of Country – System Question to COUNTRY in the esp_question table

We have a staging server in fact so we can test.
However; what value should it be instead of TEXT?

And another question; will the dropdown be filled with all the faulty Country values like phone numbers?
How do we get them out in bulk?


PropertyNL PropertyNL

July 6, 2018 at 7:40 am

On what I said:

However; what value should it be instead of TEXT?

Wait a moment; did I overlook what you mentioned above? I guess it should be COUNTRY then instead of TEXT.


Tony

  • Support Staff

July 6, 2018 at 9:55 am

Wait a moment; did I overlook what you mentioned above? I guess it should be COUNTRY then instead of TEXT.

Yes and Yes.

Heres an example of the table from one of my test sites – http://take.ms/To3dY

And another question; will the dropdown be filled with all the faulty Country values like phone numbers?
How do we get them out in bulk?

Yes, it will, but you can’t disable them in bulk.

The problem with just fixing this now in bulk is that you’re going to have registrations with relationships to those ‘faulty countries’ so you can’t just remove them.

The safest method to removing them from view, is to go to Event Espresso -> General Settings -> Countries and set any country that is incorrect to not show in the dropdowns (theres a setting for it in each countries settings).


PropertyNL PropertyNL

July 9, 2018 at 8:40 am

What I noticed was inside of the existing Attendees, the Country field was empty anyway (for all the contacts I checked).
This could be mainly because we switched from Text to Country. It can’t convert back to a dropdown field.

Now not only do we have to remove some countries, we also need to add in a lot of countries because it’s missing a lot.
So is there like a default list of countries we can somehow insert?

Countries list


PropertyNL PropertyNL

July 9, 2018 at 8:40 am

So this is the countries dropdown currently:
https://imgur.com/a/nA6gQIx


Tony

  • Support Staff

July 9, 2018 at 2:50 pm

What I noticed was inside of the existing Attendees, the Country field was empty anyway (for all the contacts I checked).
This could be mainly because we switched from Text to Country. It can’t convert back to a dropdown field.

Based on this you have a couple of choices, if you are not concerned with trying to pull in the current contacts country you can test what happens if you start with a fresh esp_country table.

The way I would do that is to rename the current table to something else (do this on the test site, not live).

So if your table prefix is wp_, rename wp_esp_country to wp_esp_country_temp

Visit a page in the admin and EE should automatically regenerate the default country table for you. Now test some contacts and confirm you’re not getting fatal errors and that contacts that DO display a country (if any) display the correct one.


PropertyNL PropertyNL

July 10, 2018 at 9:03 am

All right that works.
I even saw some registrants that display a country.

Only problem left is that the frontend dropdown only shows Canada and the US.
Can we turn on the rest? You can imagine it’s quite a waste of time having to turn on every country by hand.

countries dropdown


PropertyNL PropertyNL

July 10, 2018 at 9:21 am

Also I noticed the countries return an error in the back-end:
http://propertyeu.staging.wpengine.com/wp-admin/admin.php?page=espresso_general_settings&action=country_settings&country_settings_nonce=391d5fb7c4

Error

Btw I found the solution for enabling all countries using this plugin:
https://gist.github.com/lorenzocaum/8293c68d5d1bc3bb6403

Only thing that remains is the error…


Tony

  • Support Staff

July 12, 2018 at 2:33 pm

Hmm ok, so the problem is that there’s more broken than just the country table, it looks like the states are missing?

Do you have any states in your wp_esp_state table?


PropertyNL PropertyNL

July 13, 2018 at 5:25 am

Do you have any states in your wp_esp_state table?

Just for Canada and the US. Is that a problem?


Tony

  • Support Staff

July 13, 2018 at 8:40 am

No, but even when I load the US in the countries settings I don’t see any states on your site – http://take.ms/4H3QK

Does the table look similar to this? – http://take.ms/uvyIR


PropertyNL PropertyNL

July 16, 2018 at 11:12 pm

Yes it does.

Table


PropertyNL PropertyNL

July 16, 2018 at 11:12 pm

table


PropertyNL PropertyNL

July 16, 2018 at 11:14 pm

And it ends with:
end of table


PropertyNL PropertyNL

July 17, 2018 at 4:36 pm

Is it an idea to rename this table as well so that EE creates a new esp_state table?
Please tell me if that helps.


Tony

  • Support Staff

July 18, 2018 at 2:22 am

With the exception of row 70, that table looks correct, but as your simply renaming a table for EE to recreate, there is no harm in testing it (as you can always delete the ‘new’ table EE creates and go back to the original, so give it a shot by all means.

I’ve ask one of our developers for some further feedback on the above to see if they can think of a reasons for the error.


PropertyNL PropertyNL

July 18, 2018 at 1:24 pm

All right done that and it seems to fix the issue.
No more errors in the Countries list.

You can still let the developer check, but maybe this was the problem.


Tony

  • Support Staff

July 19, 2018 at 4:47 am

Hmm, strange.

I’m glad it’s working for you now but really sure why, I recreated the same setup and added another row without values and it worked fine, it was obviously an issue with the state table but the above doesn’t really point to what that issue was.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for the MailChimp integration.
Documentation for MailChimp integration and EE4 MailChimp Integration
http://eventespresso.com/wiki/mailchimp-integration/

Status: publish

Updated by  Tony 4 days ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!