|
Fred Dreiling
|
March 15, 2022 at 3:46 am
WP 5.92
I initially refer to the post on Link to a post covering same issue
I followed all advice contacting hosting support, but nothing has changed at their end.
We have been very successfully using the app for some 3 or 4 years without major issue. But last Thursday 10th March 2022 the site was upset an I as admin could no longer login and further, our 11 event organisers received the “You are not allowed….” error message.
Hosting support restored the site to the Tuesday prvious, the 8th March, but still the issues remained! After some frantic hair pulling using PhpMyAdmin I checked my Admin creds and I was no longer admin. I restored the capabilities to Admin and I can now log in to Dashboard where as previously, my details were recognised but dashboard was denied!
So apart from the obvious, how do I fix this, my detailed question, is how are the capabilites of the “Event Administrators” and “Event administraors (Own)” held in the database. I am thinking as my creds were compromised, then probably so too are the Organisers, but I would welcome some pointers as to which rows in the database!
I hope that makes sense!
Kindest Fred
|
|
Tony
|
March 15, 2022 at 7:31 am
Hi Fred,
The capabilities for those roles are stored in the same way as all of the other roles within WordPress so if your admin caps have been compromised it is likely the others have.
However, without meaning to state the obvious here, capabilities on your admin account should not just end up broken like this out of the blue, for me it would be a red flag to start checking into that site hadn’t been compromised, which I assume you have done?
Fixing the admin account is all well and good, but if there’s a vulnerability on the site allowing ‘someone’ to access the site it will likely just happen again or is an indication of a bigger issue.
—
To answer your question about the Events Admin role, the first thing I would do is install a plugin such as User Role Editor.
Then go to Users -> User role editor.
Select the ‘Events Administrator’ role in the dropdown
You can find the default capabilities that should be set on that account HERE.
Do they match up?
|
|
Fred Dreiling
|
March 16, 2022 at 6:40 pm
I am now really frustrated by my lack of deep knowledge of both WP and EE.
I checked the roles and capabilities appear to match.
When the site https://fndponyclub.org.uk was set up it was suggested a few years later when we awere setting up the ecommerce EE to set it up in a separate WP install in a subfolder fndponyclub.org.uk/bookings/
WE have had minor issues with the site running slow, deleting hundreds of events and 1000’s of registrations sorted that.
So when we try to login to the app, Android or Apple, we continue with the error first discussed. I set up a new install of EE4 on a different VH to check the hosting ws still compatible and it worked.
Using the FnD domain, and a new user for testing purposes I do not get the initail response but “the provided password is an invalid application password”
I understand from previous posts on other subjects, it is not possible to exposrt and import events and registrations. I really need to get this working. Do you have any other ideas please?
Thanks Fred
|
|
Fred Dreiling
|
March 17, 2022 at 12:28 pm
After further investigations I found the Error_Log in root… prior to the indicated time and date all errors were truly aged and did not appear to impact on this situation. The timing on the error_log ties in with the EE App errors appearing.
The line that follows ———— line was repeated with slightly varying details 785 times …
Perhaps this can give some clue to how I can restore the app functionality!
Hoping, thanks Fred
[10-Mar-2022 12:13:19 UTC] —————————————————————————————-
[2022-03-10 12:13:19] Exception Details
Message: The class file EE_Caf_Messages could not be located or is not readable due to file permissions. Please ensure that the following filepath(s) are correct: <br />
Code: EE_Registry – _require_file – 1131
File: /home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/core/EE_Registry.core.php
Line No: 1131
Stack trace:
#0 /home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/core/EE_Registry.core.php(890): EE_Registry->_require_file(false, ‘EE_Caf_Messages’, ‘class’, ‘/home/fndponyc/…’)
#1 /home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/core/EE_Registry.core.php(668): EE_Registry->_load(‘/home/fndponyc/…’, ”, ‘EE_Caf_Messages’, ‘class’, Array, false, true, false)
#2 /home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/caffeinated/brewing_regular.php(272): EE_Registry->load_file(‘/home/fndponyc/…’, ‘EE_Caf_Messages’, ‘class’, Array, false)
#3 /home/fndponyc/public_html/bookings/wp-includes/class-wp-hook.php(307): EE_Brewing_Regular->caffeinated_init(”)
#4 /home/fndponyc/public_html/bookings/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#5 /home/fndponyc/public_html/bookings/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#6 /home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/core/EE_System.core.php(1066): do_action(‘AHEE__EE_System…’)
#7 /home/fndponyc/public_html/bookings/wp-includes/class-wp-hook.php(307): EE_System->set_hooks_for_core(”)
#8 /home/fndponyc/public_html/bookings/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#9 /home/fndponyc/public_html/bookings/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#10 /home/fndponyc/public_html/bookings/wp-settings.php(587): do_action(‘init’)
#11 /home/fndponyc/public_html/bookings/wp-config.php(198): require_once(‘/home/fndponyc/…’)
#12 /home/fndponyc/public_html/bookings/wp-load.php(50): require_once(‘/home/fndponyc/…’)
#13 /home/fndponyc/public_html/bookings/wp-cron.php(44): require_once(‘/home/fndponyc/…’)
#14 {main}
—————————————————————————————-
[10-Mar-2022 13:29:09 UTC] WordPress database error Unknown column ‘message_id’ in ‘field list’ for query INSERT INTO wp_wpmailsmtp_emails_log (message_id, subject, people, headers, error_text, content_plain, content_html, status, date_sent, mailer, attachments, initiator_name, initiator_file) VALUES (”, ‘Event Payment Details’, ‘{\”to\”:[\”Nickyhudson21@outlook.com\”],\”from\”:\”support@fndponyclub.org.uk\”}’, ‘[\”Date: Thu, 10 Mar 2022 13:29:09 +0000\”,\”From: Flint and Denbigh Pony Club Booking System <support@fndponyclub.org.uk>\”,\”Reply-To: support@fndponyclub.org.uk\”,\”Message-ID: <@www.fndponyclub.org.uk>\”,\”X-Mailer: WPMailSMTP\\/Mailer\\/outlook 3.3.0\”,\”MIME-Version: 1.0\”,\”Content-Type: text\\/html; charset=utf-8\”,\”Content-Transfer-Encoding: 8bit\”]’, ”, ”, ”, ‘0’, ‘2022-03-10 13:29:09’, ‘outlook’, 0, ‘Event Espresso’, ‘/home/fndponyc/public_html/bookings/wp-content/plugins/event-espresso-core-reg/core/libraries/messages/messenger/EE_Email_messenger.class.php:439’) made by do_action_ref_array(‘AHEE__EE_Messages_Scheduler__generation’), WP_Hook->do_action, WP_Hook->apply_filters, EE_Messages_Scheduler::batch_generation, EE_Messages_Scheduler::initiate_immediate_request_on_cron, EED_Messages->run_cron, EE_Messages_Processor->batch_generate_from_queue, EE_Messages_Queue->initiate_request_by_priority, EE_Messages_Processor->process_immediately_from_queue, EE_Messages_Processor->batch_send_from_queue, EE_Messages_Queue->execute, EE_Messages_Queue->_process_message, EE_Messages_Queue->_do_send, EE_messenger->send_message, EE_Email_messenger->_send_message, wp_mail, WPMailSMTP\MailCatcherV6->send, do_action(‘wp_mail_smtp_mailcatcher_pre_send_before’), WP_Hook->do_action, WP_Hook->apply_filters, WPMailSMTP\Pro\Emails\Logs\Logs->process_pre_send_before, WPMailSMTP\Pro\Emails\Logs\Providers\Common->save_before, WPMailSMTP\Pro\Emails\Logs\Email->save
|
|
Fred Dreiling
|
March 17, 2022 at 1:26 pm
I have just set up a new Admin User and set hime up on a new phone with one test event.
The user logs into the app but is presented with “Error occurred. The requested resource could not be found but may be available in the future. Subsequent requests are permissible. OK”
|
|
Tony
|
March 18, 2022 at 6:48 am
[2022-03-10 12:13:19] Exception Details
Message: The class file EE_Caf_Messages could not be located or is not readable due to file permissions. Please ensure that the following filepath(s) are correct:
That error usually means there are missing files fro your install (either that or your site doesn’t have the correct permissions to read them, but then I’d expect more errors).
Do you normally update plugins via the Admin dashboard or manually using FTP?
[10-Mar-2022 13:29:09 UTC] WordPress database error Unknown column ‘message_id’ in ‘field list’ for query INSERT INTO wp_wpmailsmtp_emails_log (message_id, subject, people, headers, error_text, content_plain, content_html, status, date_sent, mailer, attachments, initiator_name, initiator_file)
That error is from WP Mail SMTP Pro
Event Espresso is triggering an email there and WP Mail SMTP is hooking into wp_mail to log the email that it being sent, then throwing a fatal error.
Are you using the latest version of that plugin? You’ll need to check in with their support on the above error as it’s not from EE itself and I can’t give you more details on it.
I have just set up a new Admin User and set hime up on a new phone with one test event.
The user logs into the app but is presented with “Error occurred. The requested resource could not be found but may be available in the future. Subsequent requests are permissible. OK”
Can you send over temp login details so I can take a look at this?
If so use this form: https://eventespresso.com/send-login-details/
|
|
Fred Dreiling
|
March 18, 2022 at 8:55 am
This reply has been marked as private.
|
|
Tony
|
March 23, 2022 at 7:14 am
Hi Fred,
Apologies for the delay but I’ve been investigating this and would like to add some debug code to the site if that’s ok?
If so I’ll need FTP credentials to access the files for a little but please do include those on the forum and send them via the form I liked to above:
https://eventespresso.com/send-login-details/
|
|
Fred Dreiling
|
March 29, 2022 at 1:20 pm
Did you receive my response to last message that contained the detailed you asked.
Thanks
Fred
|
|
Tony
|
April 4, 2022 at 9:42 am
Hi Fred,
Apologies for the delay, this took a little bit of a deep dive to find.
Can you test out the app again now please and see if it works for you?
|
|
Fred Dreiling
|
April 4, 2022 at 3:35 pm
Wow, well it works on my mobile device. I will post a WhatsApp message to ask organisers to test their phones and apps. I will get back to you this time tomorrow.
Thanks so much. I would love to know in broad terms the cause and resolution, but more tomorrow. Thanks to you and the team.
|
|
Tony
|
April 5, 2022 at 6:00 am
I would love to know in broad terms the cause and resolution
Its an issue caused by some setups when using a subsite on a domain, so:
www.domain.com works as expected.
www.domain.com/subsite/ would fail in the app.
This depended on a couple of different configs for it to go wrong which then meant the code we use to detect the request type would not be able to identify when it was for the WP API or EE API and then did not set up the various sections we use on those requests (which the app then required).
In short, a config issue meant that EE could not detect when a request was for it’s API when using a subsite, which meant the app didn’t have the details it needed to function. A quick change to the context checker to fix that and got it working as normal 🙂
|
|
Fred Dreiling
|
April 5, 2022 at 9:19 am
This reply has been marked as private.
|
|
Tony
|
April 6, 2022 at 7:28 am
This reply has been marked as private.
|
