Support

Home Forums Event Espresso Premium EE3 Custom Template (event table) not working on new host

EE3 Custom Template (event table) not working on new host

Posted: April 25, 2018 at 12:16 pm


lokimac

April 25, 2018 at 12:16 pm

Hi

I recently moved our EE3-powered site to new hosting, and we had a customized template which was making the site hang on loading. So I wanted to start fresh with the Custom Template plugin. I backed up the customizations and copied in a fresh download of the Custom Template 1.1p plugin, but when I insert the shortcode in a page, I get the below error in the PHP log (and the event table is blank). Can you assist?

[25-Apr-2018 18:01:03 UTC] WordPress database error Table ‘dpalive_wordpress.EVENTS_DETAIL_TABLE’ doesn’t exist for query SELECT e.*, ese.start_time, ese.end_time, p.event_cost , v.name venue_name, v.address venue_address, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta, v.id venue_id FROM EVENTS_DETAIL_TABLE e LEFT JOIN EVENTS_START_END_TABLE ese ON ese.event_id = e.id LEFT JOIN EVENTS_PRICES_TABLE p ON p.event_id=e.id LEFT JOIN EVENTS_VENUE_REL_TABLE vr ON vr.event_id = e.id LEFT JOIN EVENTS_VENUE_TABLE v ON v.id = vr.venue_id WHERE e.is_active = ‘Y’ AND (e.start_date >= ‘2018-04-25’ OR e.event_status = ‘O’ OR e.registration_end >= ‘2018-04-25’) AND e.event_status != ‘D’ AND e.event_status != ‘S’ GROUP BY e.id ORDER BY date(e.start_date), ese.start_time ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/forte/single-wide-portfolio.php’), apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, espresso_custom_template_output, do_action(‘action_hook_espresso_custom_template_output’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, espresso_custom_template_display
[25-Apr-2018 18:01:03 UTC] WordPress database error Table ‘dpalive_wordpress.EVENTS_CATEGORY_TABLE’ doesn’t exist for query SELECT * FROM EVENTS_CATEGORY_TABLE made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/forte/single-wide-portfolio.php’), apply_filters(‘the_content’), WP_Hook->apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, espresso_custom_template_output, do_action(‘action_hook_espresso_custom_template_output’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, espresso_custom_template_display, do_action(‘action_hook_espresso_custom_template_events-table’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, espresso_custom_template_events_table


lokimac

April 25, 2018 at 12:18 pm

OK, my bad, I just had a faulty category ID in the shortcode. The plain shortcode with no flags works, so I just have to correct the category ID. Oops.

The support post ‘EE3 Custom Template (event table) not working on new host’ 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.

Event Espresso