|
joe6079
|
June 22, 2021 at 9:22 am
Hi,
Emails aren’t going out, they are set to go via cron..and they are always stuck in the queue or they fail but never get delivered.
We’re also getting a critical error message whenever trying to send the email manually.
We are also noticing this query error in error_log:
WordPress database error Table 'pluc_sers' doesn't exist for query SELECT WP_User.ID AS 'WP_User.ID', WP_User.user_login AS 'WP_User.user_login', WP_User.user_pass AS 'WP_User.user_pass', WP_User.user_nicename AS 'WP_User.user_nicename', WP_User.user_email AS 'WP_User.user_email', WP_User.user_registered AS 'WP_User.user_registered', WP_User.user_activation_key AS 'WP_User.user_activation_key', WP_User.user_status AS 'WP_User.user_status', WP_User.display_name AS 'WP_User.display_name' FROM pluc_sers AS WP_User WHERE WP_User.ID = 1 GROUP BY WP_User.ID LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/pluctv/page_col_right_sub.php'), get_template_part, locate_template, load_template, require('/themes/pluctv/template-parts/content/content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, EED_Event_Single::event_details, EE_Template_Part_Manager->apply_template_part_filters, EE_Template_Part_Manager->_position_template_part, EEH_Template::locate_template, EEH_Template::display_template, include('/plugins/event-espresso-core-reg/public/Espresso_Arabica_2014/content-espresso_events-tickets.php'), espresso_ticket_selector, EED_Ticket_Selector::display_ticket_selector, EventEspresso\\modules\\ticket_selector\\DisplayTicketSelector->display, EventEspresso\\modules\\ticket_selector\\DisplayTicketSelector->loadTicketSelector, EventEspresso\\modules\\ticket_selector\\DisplayTicketSelector->simpleTicketSelector, EE_Ticket->is_free, EE_Ticket->get_ticket_total_with_taxes, EE_Ticket->get_ticket_subtotal, EE_Taxes::get_subtotal_for_admin, EE_Taxes::_get_subtotal_for_admin, EE_Base_Class->get_many_related, EEM_Base->get_all_related, EE_Model_Relation_Base->get_all_related, EEM_Base->get_all, EEM_Base->_create_objects, EEM_Base->instantiate_class_from_array_or_object, EEM_Base->_deduce_fields_n_values_from_cols_n_values, EEM_Base->_get_column_value_with_table_alias_or_not, EEM_Base->get_one_by_ID, EEM_Base->get_one, EEM_Base->get_all, EEM_Base->_get_all_wpdb_results, EEM_Base->_do_wpdb_query, EEM_Base->_process_wpdb_query, EEM_Base->_process_wpdb_query
There is no table named pluc_sers but there is a table named pluc_users.
Can you please help make this work, the error removed, and emails working?
|
|
joe6079
|
June 23, 2021 at 1:49 am
This reply has been marked as private.
|
|
joe6079
|
June 23, 2021 at 2:06 am
Alos wanted to add one more thing on changing the option “On same request” the registration stops working. Get this error “Regosteratin could not be completed. Try refreshing the page”.
|
|
Tony
|
June 23, 2021 at 6:01 am
Hi there,
Emails aren’t going out, they are set to go via cron..and they are always stuck in the queue or they fail but never get delivered.
How long do emails get ‘stuck in the queue’ for?
Te message queue uses WP_CRON and sets schedule of 5 mins for each of the tasks. It can take longer than 5 mins for the task to trigger as WP_CRON relies on page hits to load and check for tasks, so low traffic sites or a site that has longer gaps between visits can take longer.
However, the fact that you’ve switched to on same request and get the above error means there is another error being thrown which needs to be fixed first.
When you test with the above option and get the “Regosteratin could not be completed. Try refreshing the page” error, what is logged in the error logs? There will usually be a fatal error being thrown and the above is EE catch all to show users there is an issue.
There is no table named pluc_sers but there is a table named pluc_users
That’s an odd error and I’ve asked one of our developers for some feedback on this, I’ll come ack to that shortly.
|
|
joe6079
|
June 24, 2021 at 2:58 am
This reply has been marked as private.
|
|
Tony
|
June 24, 2021 at 7:46 am
we checked there is low traffic and the emails in queue never get delivered..Please provide a fix for this asap.
I can’t fix it until I know the problem.
You mentioned they are not delivered, but does that mean they tried to send and then failed, or that sat in the queue and still show ‘Queued for generation’?
What language is the site set to use?
Can you link me to an EE test event I can register on to view this?
|
|
Tony
|
June 24, 2021 at 8:12 am
pluc_sers is taken directly from the global $wpdb using this code:
$this->_tables = array(
'WP_User' => new EE_Primary_Table($wpdb->users, 'ID', true),
);
$wpdb->users is setting the table name there so its odd that the above is being thrown.
Are you comfortable with PHP? If so, add this on the site:
global $wpdb;
var_dump($wpdb->users);
What does it output?
In your site’s wp-config.php file do you have anything defining CUSTOM_USER_TABLE?
|
|
joe6079
|
June 25, 2021 at 10:06 am
This reply has been marked as private.
|
|
Tony
|
June 28, 2021 at 6:42 am
The table name is really strange and I think we’ll need to add some debug code to the site to investigate further, however, that shouldn’t be causing the issue you are reporting with the emails.
Is there no other error in the logs?
For example, if you set the message queue to send on the same request, then test another registration so that it shows the “Regosteratin could not be completed. Try refreshing the page” error again, then immediately check the error logs, is there no other error other than the one you’ve already posted?
(Note remember to set the setting back once you’ve tested this)
|
