|
Fred Dreiling
|
November 15, 2017 at 2:15 am
http://www.fndponyclub.org.uk/bookings/ is the url of the install in question!
This is a new install of WP and all EE4 plugins are current! All third party plugins have been disabled. All caching has been disabled. I have done “define( ‘WP_MEMORY_LIMIT’, ‘128M’ );” and still I get this error. I have tried ingonito mode, various browsers but still the same!
But, the first person to register for our first event on Saturday did so without any issues! Our secretary has also tried to refister and does get to PayPal without problems. I cannot as I recieve the Subject message and we have had reports from a club member that their registration also failed with the same message!
Suggestions will be appreciated and thanks in advance!
Kind regards
Fred
|
|
Tony
|
November 15, 2017 at 3:39 am
Hi there,
I tested a registration and got the same error.
Do you have access to the servers error logs? You’ll usually find a section on your host’s control panel to view the logs.
The above error usually means a fatal error is being thrown on the request which should show in the logs but if not you can add this snippet:
https://gist.github.com/Pebblo/8787f5530ea777c84aaf62f075e55b32
To your wp-config.php file to which will log the errors in a debug.log file that we can view to see what is happening.
|
|
Fred Dreiling
|
November 15, 2017 at 4:52 am
Thank you for your swift reply. We do have access to cPanel but the Error Log in Metrics is empty!
I have added the snippet to wp-config.php to the Bookings WP Install!
I forgot to mention, not sure if it is relevant, but http://www.fndponyclub.org.uk and http://www.fndponyclub.org.uk/bookings use separate WP installs!
Do I need to do anything else?
Thanks
|
|
Tony
|
November 15, 2017 at 5:26 am
Can you go to:
Event Espresso -> General Settings -> Countries.
Select UK and then take a screenshot of your counties please?
https://eventespresso.com/wiki/troubleshooting-checklist/#screenshots
|
|
Fred Dreiling
|
November 15, 2017 at 8:13 am
https://cl.ly/0e3m3M0n1N1M shows the general EE4 tabs/options available
https://cl.ly/1h0M1P3n2U1F shows what is displayed when General settings is selected.
I cannot see <Event Espresso -> General Settings -> Countries> option yet I have the <Event Espresso – Counties Pack: United Kingdom> plugin installed!
|
|
Tony
|
November 15, 2017 at 9:39 am
https://cl.ly/0e3m3M0n1N1M
That’s the event listing and is loading ok as far as I can tell.
https://cl.ly/1h0M1P3n2U1F
That general settings page is missing sections, this is how it should look – http://take.ms/79Gco
The error logs now save to a debug.log file on your site so I can view them and it looks like an issue with your country/states DB table although your site is also throwing memory exhausted errors:
[15-Nov-2017 15:34:02 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 16384 bytes) in /wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Template.helper.php on line 697
[15-Nov-2017 15:34:02 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 266240 bytes) in /wp-includes/functions.php on line 3721
[15-Nov-2017 15:34:02 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 319488 bytes) in Unknown on line 0
Meaning your site is running out of memory around 256MB which would generally be considered high but it depends on all of your plugins and theme.
Do you have more memory available on the server? If so try upping the limit and see if the page loads.
|
|
Fred Dreiling
|
November 15, 2017 at 10:50 am
Am I correct that you are not referring to increasing:
define( ‘WP_MEMORY_LIMIT’, ‘128M’ );
in wp-config.php?
I have increased it in any case to “define( ‘WP_MEMORY_LIMIT’, ‘512M’ );”
I am still getting errors. The only plugins are EE4 and EE Extensions supplied by EE. Theme is Divi and is up to date!
|
|
Tony
|
November 15, 2017 at 11:21 am
Hmm, ok, I’d like to take a quick look at the database, can you send temporary login details I use to log in?
If so you can use this form https://eventespresso.com/send-login-details/
|
|
Fred Dreiling
|
November 16, 2017 at 4:46 am
Did you receive the form?
|
|
Tony
|
November 16, 2017 at 5:03 am
Hi Fred,
I just checked and no, I’ve not received any details, could you retry please.
|
|
Fred Dreiling
|
November 16, 2017 at 8:20 am
Form resubmitted!
|
|
Tony
|
November 16, 2017 at 9:30 am
Thank you.
I received them this time, however the login credentials for wp-admin don’t work, can you recheck and resend those, please?
The FTP credentials work fine.
|
|
Fred Dreiling
|
November 16, 2017 at 10:12 am
Resubmitted!
|
|
Tony
|
November 16, 2017 at 11:50 am
Hmm, strange.
So the reason for the crash is your site only had 25 of the countries EE adds to its esp_country table when there should be 250, did you remove those?
It meant that when all of your states loaded and it pulled the countries for those states to list the country name, you had states that then had no country and it crashed (because that should never happen).
To fix that I dropped the EE country table and EE then automatically fixed it.
Now you have a new problem, your database tables are using 2 different collations utf8mb4_unicode_ci and utf8mb4_unicode_520_ci, was this site created on another server?
|
|
Fred Dreiling
|
November 16, 2017 at 12:06 pm
Thanks for help to date!
An EE_Error exception was thrown! code: EEM_Base – _do_wpdb_query – 2329
“WPDB Error: “Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation ‘='””
click to view backtrace and class/method details
Yikes, that is new!! The site was not built on a different server, but built in its present location! As I have mentioned earlier, all was well until last weekend. We launched the Bookings site, and someone used it and successfully paid. Then it all fell apart!
How can the database issue be resolved? Is it restart from the beginning?
|
|
Tony
|
November 16, 2017 at 12:49 pm
The something has changed on the server and your tables are now using utf8mb4_unicode_520_ci
I’ve ran a command on your site to change the collation back to utf8mb4_unicode_ci for all of your current tables and registrations now work.
You’ll need to reset your address in Event Espresso -> General Settings but EE should work correctly now.
|
|
Fred Dreiling
|
November 16, 2017 at 2:16 pm
Many, many thanks Tony! I will get committe members to check using varied OS, platform combiations, but I am sure now all will be well!
|
|
Tony
|
November 17, 2017 at 3:23 pm
You’re most welcome 🙂
I’ve just removed the plugin I installed from the site again as if you don’t need it you don’t want it just sitting around.
Please do let us know if you run into any further problems, you may want to contact your host and have them set your DB to use utf8mb4_unicode_ci to try and prevent the same happening in the future.
|
