|
Rosemary Miller
|
January 7, 2016 at 6:02 pm
http://learningforwardkansas.org
Events are broken after EE4 update 4.8.29.p and WordPress 4.4.1 update
404 message for each event page
And this error message appears on the EE4 events list page
“The incoming statuses argument must be an array with keys as the $status_id and values as the $status_code EEM_Status – localized_status – 240”
|
|
Lorenzo Orlando Caum
|
January 7, 2016 at 6:16 pm
Hi Rosemary,
Could you deactivate and reactivate Event Espresso 4 and then go to WP-admin –> Settings –> Permalinks?
—
Lorenzo
|
|
Rosemary Miller
|
January 7, 2016 at 6:21 pm
Did this but it didn’t work. HELP!! We have people trying to register as we “speak”.
|
|
Josh
|
January 7, 2016 at 6:30 pm
Hi Rosemary,
The error message indicates that the database user’s permissions are not allowing WordPress to create any new tables. It’s able to write to the existing tables, but not create new tables. This issue will occur with any new WordPress plugin you may try to install or run an update where a new table needs to be added.
I’m afraid this is something that will need to be changed by the server administrator, at least temporarily in order to re-run the Event Espresso update. What they will need to do is make sure that the database user has the permission to create new database tables at least for the times when software updates are made. This is a note in the WordPress codex that explains this further:
Note: Some plugins, themes and major WordPress updates might require to make database structural changes, such as add new tables or change the schema. In such case, before installing the plugin or updating a software, you will need to temporarily allow the database user the required privileges.
http://codex.wordpress.org/Hardening_WordPress#Restricting_Database_User_Privileges
Hopefully you can get in contact with the server admin and they’ll be able to make this adjustment soon.
|
|
Rosemary Miller
|
January 7, 2016 at 6:32 pm
Can I downgrade to the previous version temporarily to get the registrations running again?
|
|
Josh
|
January 7, 2016 at 6:39 pm
That might work, especially if the WordPress update didn’t need to create or alter any of the database tables.
If you know the version that you updated from, you can get a zip file copy of the version from one of the release tags available here:
https://github.com/eventespresso/event-espresso-core/releases
Once you have the zip file downloaded, you deactivate and remove the Event Espresso plugin from your site and upload/activate the older copy.
|
|
Rosemary Miller
|
January 7, 2016 at 6:47 pm
Going down one level did not work, either.
|
|
Rosemary Miller
|
January 7, 2016 at 7:06 pm
In looking at my database while waiting on server support, I see that I have all privileges as a database user. Does this complicate things?
ALL PRIVILEGES
ALTER ALTER ROUTINE
CREATE CREATE ROUTINE
CREATE TEMPORARY TABLES CREATE VIEW
DELETE DROP
EVENT EXECUTE
INDEX INSERT
LOCK TABLES REFERENCES
SELECT SHOW VIEW
TRIGGER UPDATE
|
|
Josh
|
January 7, 2016 at 7:06 pm
You can also check with your host to see if they can restore your site to a backup point made before doing the updates.
|
|
Rosemary Miller
|
January 7, 2016 at 7:12 pm
Do you think it was caused by the WP update, the EE4 update, or a combination?
|
|
Josh
|
January 7, 2016 at 7:32 pm
I don’t think it was caused by the updates if the updates were minor point releases. The error indicates a problem with the database, do you have a backup of the database that can be restored to?
|
|
Rosemary Miller
|
January 7, 2016 at 7:52 pm
Can someone help me if I provide credentials for WP and for hosting? I absolutely must get this going again before tomorrow morning.
|
|
Rosemary Miller
|
January 7, 2016 at 7:53 pm
Also, if I restore to a database backup, will I lose event registrations that have been made since then?
|
|
Rosemary Miller
|
January 7, 2016 at 8:01 pm
A third question in this series: can I delete the EE4 plugin completely without losing all the registrations and then install it again? Will the files be lost?
|
|
Josh
|
January 7, 2016 at 9:28 pm
Can someone help me if I provide credentials for WP and for hosting? I absolutely must get this going again before tomorrow morning.
When support staff is back online tomorrow someone can take a look at the database and WP installation to assess what’s going on, and to do so we’ll need to receive the hosting credentials via the form on this page:
https://eventespresso.com/send-login-details/
Also, if I restore to a database backup, will I lose event registrations that have been made since then?
Yes. If no database backups were made recently, then restoring to an old database backup would be a last resort. You can also take a database back up now if to capture the current data before restoring to the older backup.
A third question in this series: can I delete the EE4 plugin completely without losing all the registrations and then install it again? Will the files be lost?
Simply deleting the plugin files, then reinstalling them on the server does not delete the registrations. The registrations are stored in the server’s database outside of the wp-content folder. That said, there’s an button in the Event Espresso > Maintenance > Reset/Delete Data page that can be used for completely erasing everything. This option is not recommended in this case because it will delete everything.
|
|
Rosemary Miller
|
January 8, 2016 at 9:15 am
Thanks for all your assistance. We restored to a backup from the night before, and everything is working, including the updates. We lost a few registrations in the process, but luckily, we had downloaded the registrations list that morning before the problems occurred.
|
|
Josh
|
January 8, 2016 at 9:31 am
Good to know. You might consider checking out VaultPress as it can really help to keep the site backed up regularly and allows for easy 1-click restore from earlier backups.
|
