|
Flam Chen
|
July 7, 2014 at 2:15 pm
I can’t find another comparable post on the forum. I’ve got EE4 with the correct, matching Calendar Add-on installed, and there are no Javascript errors, and I get no calendar display at all on the front end, either with my custom theme or with the default theme. Everything on the back end looks fine, but on the front end, the shortcode won’t render a calendar: http://flamchen.com/calendar/
|
|
Lorenzo Orlando Caum
|
July 7, 2014 at 2:36 pm
Hi Chad,
What shortcode do you have on that page?
Does it appear if you temporarily deactivate other plugins through WordPress admin –> Plugins?
—
Lorenzo
|
|
Flam Chen
|
July 7, 2014 at 3:31 pm
Hi Lorenzo,
No, the calendar does not appear even with no other plugins activated.
This site did have EE3 installed on it previously. I tried to reset the settings for the whole plugin when I upgraded to EE4, but I’m not sure if the reset worked. Could there be something corrupted in the database leftover from EE3 with the previous calendar addon?
-Chad
|
|
Tony
|
July 7, 2014 at 5:06 pm
Hi Chad,
Can you please confirm the shortcode in use within that Calendar Page?
The scripts for the Calendar aren’t being called at all on that page, if there was an issue with parsing the Calendar we’d at least expect some of the files being loaded.
You could also try enabling WP_DEBUG to see if any errors are being thrown on that page.
|
|
Flam Chen
|
July 7, 2014 at 6:32 pm
I’m using [ESPRESSO_CALENDAR], and I’ve tried it also by using <?php echo do_shortcode(); ?> with the same result. Nothing shows up with WP_DEBUG enabled, but I do get this PHP error in my server logs:
[Mon Jul 07 20:10:42 2014] [error] [client 68.228.221.60] LONG QUERY (1069 characters long generated in /nas/wp/www/cluster-2258/flamchen/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php:478): SELECT State.STA_ID AS 'State.STA_ID', State.CNT_ISO AS 'State.CNT_ISO', State.STA_abbrev AS 'State.STA_abbrev', State.STA_name AS 'State.STA_name', State.STA_active AS 'State.STA_active', Country.CNT_active AS 'Country.CNT_active', Country.CNT_ISO AS 'Country.CNT_ISO', Country.CNT_ISO3 AS 'Country.CNT_ISO3', Country.RGN_ID AS 'Country.RGN_ID', Country.CNT_name AS 'Country.CNT_name', Country.CNT_cur_code AS 'Country.CNT_cur_code', Country.CNT_cur_single AS 'Country.CNT_cur_single', Country.CNT_cur_plural AS 'Country.CNT_cur_plural', Country.CNT_cur_sign AS 'Country.CNT_cur_sign', Country.CNT_cur_sign_b4 AS 'Country.CNT_cur_sign_b4', Country.CNT_cur_dec_plc AS 'Country.CNT_cur_dec_plc', Country.CNT_cur_dec_mrk AS 'Country.CNT_cur_dec_mrk', Country.CNT_cur_thsnds AS 'Country.CNT_cur_thsnds', Country.CNT_tel_code AS 'Country.CNT_tel_code', Country.CNT_is_EU AS 'Country.CNT_is_EU' FROM wp_esp_state AS State LEFT JOIN wp_esp_country AS Country ON Country.CNT_ISO=State.CNT_ISO WHERE Country.CNT_ISO IN ('US') ORDER BY Country.CNT_name ASC,State.STA_name ASC, referer: http://flamchen.com/wp-admin/admin.php?page=espresso_general_settings&action=country_settings&country_settings_nonce=2ccd2f7001&return=admin_option_settings
This appears each time I try to load the Calendar page.
|
|
Flam Chen
|
July 7, 2014 at 6:45 pm
I just tried using the EE’s built-in function to delete all data from the database again, and deleted both plugins, then reinstalled them from fresh downloads. Upon activation, all my previous settings were retained. So the “delete all data” feature definitely does not work, and that means there probably is a mess of old data cruft in the database from the previous version. Any suggestions before I try to hand-pick the data from my database?
|
|
Flam Chen
|
July 7, 2014 at 6:47 pm
Oh, so now there’s a new error in my server error log, apparently a missing table in the database:
WordPress database error Table 'wp_mydatabse.wp_esp_status' doesn't exist for query SELECT STS_ID, STS_code FROM wp_esp_status WHERE STS_type = "registration"...
|
|
Dean
|
July 8, 2014 at 3:03 am
Hi,
Not sure exactly what has gone on here, but I think you might be on the right path with removing the tables and re-installing.
I tested the “delete all data” and it function correctly, but perhaps whatever had caused the initial issues also interfered with that.
|
|
Flam Chen
|
July 8, 2014 at 10:51 am
Okay, I was able to delete all the tables from the database beginnin with esp_ but now when I re-activate the plugin, there are serious errors preventing me from saving any settings screen from Event Espresso. Here’s an example:
An error has occurred:
An error occurred. The Your Organization Settings were not updated.
GNRSTT-GNRSTTDMNPG-UPDYOUORGSET-474
|
|
Flam Chen
|
July 8, 2014 at 10:57 am
Wow, now I can’t even delete the plugins from within WordPress. I have to use FTP.
|
|
Flam Chen
|
July 8, 2014 at 11:18 am
Okay, I deleted the plugins, then installed the old version of EE, activated it, and all the settings are still there from the old version. Is there any way to reliably delete all the settings in EE 3.x?
|
|
Lorenzo Orlando Caum
|
July 8, 2014 at 11:19 am
Hi Chad,
Is this WP Engine?
If so, please request no-cache rules for your Event Espresso pages: https://eventespresso.com/wiki/setup-nocache-exclusion-rules-event-espresso/
Try using an SFTP client to remove the core plugin and the calendar. Then download new copies from your Event Espresso account and upload and activate through WP-admin –> Plugins.
—
Lorenzo
|
|
Flam Chen
|
July 8, 2014 at 11:25 am
Hi Lorenzo,
Yes, it is WP Engine. I have to submit no cache rules to support. I’d like first to clear out my database of all the EE 3.x data which does seem to be interfering with EE 4.x, then remove EE 3.x, install EE 4.x again, clear the cache, and hopefully this will work.
The problem with my calendar not showing up started happening even on my local dev server, and is not cache related.
|
|
Tony
|
July 8, 2014 at 11:32 am
EE4 use’s separate tables from EE3 so your EE3 data will remain intact when using EE4.
If you install EE4 and choose NOT to migrate your data your EE4 tables should be free from any previous settings.
The LONG QUERY ‘error’ can safely be ignored. This is triggered on WP Engine whenever a query is over 1,024 characters but does not take into account what the query is actually doing.
Have you tried de-activating all Non EE plugins and retesting the Calendar page?
|
|
Flam Chen
|
July 8, 2014 at 11:45 am
Hi Tony,
Than you for explaining about the LONG QUERY warning.
I just now saw the migration screens appear when activating EE4. I did not see anywhere in any documentation that the EE3 plugins actually must be installed in order to trigger those screens in EE4. Previously, I only had the EE4 plugins installed, and I never saw an option to migrate any data.
However, even after going through the migration and deleting all EE3 data, the calendar shortcode still does not work.
If you look earlier in this thread, you’ll see that I already tried running this site with the default 2014 theme and all other plugins deactivated, and the calendar still did not show. Now, my license key doesn’t seem to work any more either for some reason. The key icon on the settings page now remains red.
|
|
Flam Chen
|
July 8, 2014 at 12:08 pm
I’ve decided for now to revert to EE3. I’ve spent too much time on this right now, and my client is happy enough with EE3, and the calendar with EE3 works fine. Perhaps I’ll give EE4 another try after some more development has been done, or perhaps I’ll seek another solution. Thank you for trying!
|
|
Tony
|
July 8, 2014 at 1:47 pm
Hi Chad,
I’m sorry you ran into issues when trying to use EE4.
Just to note, the data migrations are not based on your current active plugins but rather the EE data stored within the database, EE4 checks the version number for last version installed (so lets say 3.1.36.5) if this is greater than 3.1.36 but less than 4.1 (which is the initial release version of EE4) then migration scripts are called.
Once the migration scripts are called you are offered the option to migrate, or not. If you select No, EE4 will remember this and not offer to migrate again (unless the tables are reset/removed)
There’s a little more to it than that, but in a nutshell that’s how it should work.
It is likely you were seeing the migrations scripts as you had just removed all of the EE4 tables.
It is also possible that activating the EE4 Calendar Add-on EE4 put into ‘Maintenance mode’ expecting to Migrate the Calendar details also, which would prevent the Calendar from being displayed.
|
