|
samatmaxx
|
February 1, 2023 at 9:10 am
Hi there,
Hopefully someone is able to help. I have just purchased an EE Everything licence, have just attempted to install it on my local install, and get the wordpress error screen on all admin pages.
Looking in the logs, I am getting the following –
Got error ‘PHP message: WordPress database error Table ‘wordpress.myf_esp_event_meta’ doesn’t exist for query SELECT COUNT(Event_CPT.ID) FROM myf_posts AS Event_CPT LEFT JOIN myf_esp_event_meta AS Event_Meta ON Event_CPT.ID = Event_Meta.EVT_ID WHERE Event_CPT.post_type = ‘espresso_events’ AND Event_CPT.post_status NOT IN (‘auto-draft’,’trash’) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘/site/docs/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, EE_System->initialize_last, do_action(‘AHEE__EE_System__initialize_last’), WP_Hook->do_action, WP_Hook->apply_filters, EE_Admin->init, EE_Admin->initModelsReady, EE_Admin->maybeSetDatetimeWarningNotice, EEM_Base->count, EEM_Base->_do_wpdb_query…..
Looking in my database, none of the ee tables have been created…
Any help much appreciated.
Thanks,
S
|
|
Tony
|
February 1, 2023 at 10:19 am
Hi there,
That’s odd!
What are you using for local development?
Which version of Event Espresso have you installed?
|
|
samatmaxx
|
February 1, 2023 at 10:26 am
Hi there,
Thanks for getting back to me.
Im using a Docker/Debian local dev environment, running wordpress 6.1.1, mysql:8.0.28, phpmyadmin:5.2.0-apache, php:7.4.3
I am using event espresso 4.10.44.p
Thanks,
S
|
|
Tony
|
February 1, 2023 at 10:40 am
Yeah very strange!
I assume you have de-activated and re-activated Event Espresso at least once?
Does the site have the correct permissions to create new tables within the DB?
|
|
samatmaxx
|
February 1, 2023 at 10:50 am
Hi again,
Yes, I have de and re-activated event espresso several times with the same result.
The site has all the correct permissions, as I have installed other plugins that have automatically generated their own database tables e.g. redirection.
|
|
Tony
|
February 1, 2023 at 11:24 am
Redirection only generates its tables after setup, so just to confirm you’ve ran through the redirection setup process, correct?
I’ve just setup up a few new test sites, one locally using laragon and installed 4.10.44, no issues.
Another with local by flywheel, again no issues there.
Another on a ‘live’ server, again no issues.
Sounds like something may be tripping up the activation check within core with the above setup, I’ll check with one of our devs to see if there is an easy way to check that.
|
|
Tony
|
February 1, 2023 at 12:45 pm
Waiting on feedback for the above but I’ve thought of a test you can do for this.
EE has a feature were you can reset the DB tabls (or drop them completely) and this sounds like a new test site so does Event Espresso -> Maintenance -> Reset/Delete Data (tab) load?
URI: /wp-admin/admin.php?page=espresso_maintenance_settings&action=data_reset
On that page hit, Reset Event Espresso Data are the tables generated?
If not try ‘Permanently Delete ALL Event Espresso Data’ which will drop all EE tables (I know you have none) and deactivate Event Espresso.
Try reactivating after that, any different?
|
|
samatmaxx
|
February 2, 2023 at 1:17 am
Hi again Tony,
Thanks for your help on this, your above link did work, and after clicking ‘Permanently Delete ALL Event Espresso Data’ and de/reactivating EE genertaed the tables and everything appears to be working as expected.
Thanks again,
S
|
|
Tony
|
February 2, 2023 at 4:20 am
Awesome, I’m glad that worked.
I’m not sure why the initial activation didn’t create those tables though, very odd.
|
