|
Susan Butterfield
|
January 18, 2018 at 1:11 pm
I recently upgraded my http://pcea1.org site to WordPress 4.9.2 running WP-Radiance theme and I got a lot of errors related to both EE Requirements Check and API Plugin. I disabled Requirements Check and upgraded to PHP 5.6.17 and I’m still getting EE API errors such as those below when the plugin is enabled. Ideally, I would like to upgrade EE 4 and PHP 7:
Warning: mysql_real_escape_string(): No such file or directory in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 44
Warning: mysql_real_escape_string(): A link to the server could not be established in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 44
Warning: mysql_real_escape_string(): No such file or directory in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 46
Warning: mysql_real_escape_string(): A link to the server could not be established in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 46
Warning: mysql_real_escape_string(): No such file or directory in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 47
Warning: mysql_real_escape_string(): A link to the server could not be established in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 47
Warning: mysql_real_escape_string(): No such file or directory in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 48
Warning: mysql_real_escape_string(): A link to the server could not be established in /data/25/3/9/27/3009516/user/3341508/htdocs/WordPress/wp-content/plugins/espresso-json-api/includes/EspressoAPI_Router.class.php on line 48
|
|
Josh
|
January 18, 2018 at 1:33 pm
Hi Susan,
You can deactivate and remove the Espresso JSON API plugin. Event Espresso 4 has a built in API so a separate API plugin is no longer needed.
|
|
Susan Butterfield
|
January 18, 2018 at 1:48 pm
Cool. Is there any special I need to do to upgrade from 3.1.37.12.P to 4? Will I retain all my evenT and attendee data?
|
|
Josh
|
January 18, 2018 at 2:04 pm
You can opt to migrate all of your event and attendee data. When you first activate EE4, it will check for any EE3 data and when it sees the data, it will print a message that asks you if you want to migrate the data, where you click on “Yes”. There’s more information about migrating from Event Espresso 3 to Event Espresso 4 here:
https://eventespresso.com/wiki/how-to-upgrade-event-espresso/#migrate-to-event-espresso-4
|
|
Susan Butterfield
|
January 18, 2018 at 2:09 pm
Awesome. I’ll give it a go. Thanks so much for your quick response. Truly appreciate it!
|
|
Susan Butterfield
|
January 18, 2018 at 2:16 pm
I see a boatload of downloads listed in my EE4 Downloads list. Which is the right one? ‘Event Espresso 4 Core Regular v4.9.55.p’?
|
|
Susan Butterfield
|
January 18, 2018 at 4:51 pm
Just installed and activated ‘Event Espresso 4 Core Regular v4.9.55.p’, backed up my date, updated the database and got a boatload of warnings.
Any chance I can just give you access and let you do the update before I mess things up?
|
|
Susan Butterfield
|
January 18, 2018 at 8:04 pm
Database update now says:
The following 6 tasks need to be performed:
Data Update to Event Espresso 4.3.0
Data Update to Event Espresso 4.5.0
Data Update to Event Espresso 4.6.0
Data Update to Event Espresso 4.7.0
Data Update to Event Espresso 4.8.0
Data Update to Event Espresso 4.9.0
|
|
Tony
|
January 19, 2018 at 3:19 am
Just installed and activated ‘Event Espresso 4 Core Regular v4.9.55.p’, backed up my date, updated the database and got a boatload of warnings.
As long as you didn’t get a fatal error (it would tell you if you had) the warnings are just advisory, it usually means EE couldn’t match some data to X, so it did Y instead. For example, it couldn’t match a registrant to a previous registration so it created another.
Any chance I can just give you access and let you do the update before I mess things up?
We can run through the migration for you, however you would need to purchase support tokens to cover the time, depending on your server this can take a little while and we essentially do the same as you would for a migration.
You would be better running through all of the migrations first too see if ther is a problem imo.
Database update now says:
The following 6 tasks need to be performed:
Data Update to Event Espresso 4.3.0
Data Update to Event Espresso 4.5.0
Data Update to Event Espresso 4.6.0
Data Update to Event Espresso 4.7.0
Data Update to Event Espresso 4.8.0
Data Update to Event Espresso 4.9.0
There are multiple migrations needed, the migration you have just done likely migrated the data from EE3 to the first EE4 version, however as we make changes to the database structure of EE4 a new migration is needed so there are multiple steps to bring all of the data up to the latest version.
On the above page there will be a button to continue the migration, run through the on-screen steps to run through all of the migrations.
|
|
Susan Butterfield
|
January 22, 2018 at 12:40 pm
Migration seems to have gone well. The only thing wrong is my event times are off. For example, in the Admin I entered 4:00 pm – 8:00 pm – but on the site it reads: 11:00 am – 3:00 pm.
|
|
Josh
|
January 22, 2018 at 12:57 pm
Hi Susan,
When the times shift like that it’s usually caused by another plugin resetting the timezone. Can you try temporarily deactivating the other plugins on the website, then save the event, then check to see if the times display correctly?
|
|
Susan Butterfield
|
January 22, 2018 at 1:06 pm
OK. Looks like the ‘Ajax Event Calendar’ plugin is the culprit. But, I need that plugin for my calendar page: http://pcea1.org/calendar
Any suggestions?
|
|
Josh
|
January 22, 2018 at 1:42 pm
My first suggestion would be to use the EE4 calendar add-on for your calendar page.
If you absolutely need to use the AJAX Event Calendar plugin, you could make an edit to its localize_plugin() method where it has this:
date_default_timezone_set($timezone);
you can change it to be this instead:
date_default_timezone_set('UTC');
For what it’s worth, ‘Ajax Event Calendar’ has been retired and is no longer available to download from wordpress.org:
https://wordpress.org/plugins/ajax-event-calendar/
|
|
Susan Butterfield
|
January 22, 2018 at 1:55 pm
OK. I installed and activated the EE4 Calendar – but when I go to Event Espresso –> Settings –> [there is no calendar?].
And, if I go to the Plugins page and click the Settings link under the Events Calendar plugin, I get a screen with this message: “Sorry, you are not allowed to access this page.”
|
|
Josh
|
January 22, 2018 at 2:08 pm
Can you verify that you have EE4 Events Calendar Add-on version 3.2.11.p? If the calendar has a different version number, then you’ll need to get the one from your account page under the EE4 tab.
|
|
Susan Butterfield
|
January 24, 2018 at 7:26 am
Yup. That was it. Thanks!
|
