|
PCOS Challenge
|
August 12, 2014 at 1:32 pm
WordPress Version: 3.9.2
Event Espresso: 4.3.0.p (Recently Upgraded)
Registration Page: PCOSChallenge.org/symposium/registration
When I try to view any transaction through the Event Espresso section of WordPress dashboard, I receive the following error message, “Table alias Status does not exist in EEM_Base child’s _tables array. Only tables defined are Array EEM_Base – __construct – 228”
|
|
Lorenzo Orlando Caum
|
August 12, 2014 at 3:33 pm
Hi,
Could you let us know if you have made any customizations to Event Espresso?
Also, do you remember what version you updated from and was that an automatic upgrade through the WordPress plugins screen?
—
Lorenzo
|
|
PCOS Challenge
|
August 12, 2014 at 8:20 pm
1) I updated from 4.2.9.p.
2) No, due to the size of the EE4 plugin, I’m unable to do automatic updates, so I had to replace the folder through FTP.
3) In addition to CSS changes through Reaktiv CSS Builder, the only other customization that I believe I made was through a site plugin that I created via the instructions in one of the forum posts for changing the text for “VAT/Tax Number.”
The code I used was:
<?php
/*
Plugin Name: Site Plugin for PCOSChallenge.org
Description: Site specific code changes for PCOSChallenge.org symposium website.
*/
function mycustom_filter_gettext( $translated, $original, $domain ) {
// This is an array of original strings
// and what they should be replaced with
$strings = array(
'VAT/Tax Number' => 'EIN',
// Add some more strings here
);
// See if the current string is in the $strings array
// If so, replace its translation
if ( isset( $strings[$original] ) ) {
// This accomplishes the same thing as __()
// but without running it through the filter again
$translations = &get_translations_for_domain( $domain );
$translated = $translations->translate( $strings[$original] );
}
return $translated;
}
add_filter( 'gettext', 'mycustom_filter_gettext', 10, 3 );
|
|
Tony
|
August 13, 2014 at 4:07 am
When you updated through FTP, did you de-activate, delete, upload new version and re-activate?
Or just copy over the update replacing the originally files?
When initially activated 4.3.0 your site should have been put into Maintenance Mode and Event Espresso request database migrations from 4.2.X to 4.3.X, did you run through those?
|
|
PCOS Challenge
|
August 13, 2014 at 8:10 am
No, I just overwrote the files.
|
|
Tony
|
August 13, 2014 at 8:35 am
When you updated, was EE maintenance mode activated and EE asking to perform migrations?
When updating plugins it is recommend to de-activate, deleted and re-upload the latest version.
EE4 checks the database version on activation to ensure you are running the latest DB schema, it will also run migrations on your data to ensure it is using the latest changes. If the plugin has not been de/re-activated this may not have taken place.
|
|
PCOS Challenge
|
August 13, 2014 at 9:29 am
No, I just overwrote the files. So would suggest that I try reinstalling the latest update using the steps that you recommended above or do I need to restore the backup and then do the update?
|
|
Tony
|
August 13, 2014 at 10:13 am
If you have a back-up from just before the update I would restore to that and re-apply the update.
If the EE4 migrations have not ran but the database version number updated (it should be is possible) then you may struggle to trigger the migrations again.
I would backup the site as it is now (just to be safe) restore your previous backup, de-activate and delete 4.2.9 and update to the latest version of EE4 and the Calendar, activate and run through the migrations.
2) No, due to the size of the EE4 plugin, I’m unable to do automatic updates, so I had to replace the folder through FTP.
Depending on the server setup EE4 should still be small enough to allow you to update via Plugins -> Add New -> Upload and use Auto Updates. Is there an error shown when you try to auto update?
|
|
PCOS Challenge
|
August 13, 2014 at 11:40 am
Ok, if I have transactions that have occurred since the last back up, will I need to re-enter them manually?
|
|
Tony
|
August 13, 2014 at 12:15 pm
Before reverting to a previous backup, have you made a new backup of the site as it is now?
First try de-activating, deleting and re-uploading EE4 (download a fresh copy from your account page to be sure). If you do this via the Plugin uploader (Plugins -> Add new -> Upload) does it not install?
|
|
PCOS Challenge
|
August 13, 2014 at 2:01 pm
Tony,
The error message has gone away after de-activating, deleting and re-uploading EE4. I was also able to upload the plugin through the uploader, which I was not able to do previously. Everything seems to be working correctly now.
Thank you for your help.
|
