|
britorthopaedic
|
July 5, 2016 at 7:08 am
Hi
My wordpress site is saying that there is an error with the espresso database since an update, and my whole site is now playing up. I have to keep diactivating the plugin so the site can work but this means then events are switched off. Can you advise whats the best solution?
Thanks
Melanie
|
|
britorthopaedic
|
July 5, 2016 at 7:16 am
The error is stated
An error has potentially occured while attempting to update some of the information in your database. Please contact Event Espresso Customer Service so that they may look further into this matter and ensure that all data is correct
|
|
Tony
|
July 5, 2016 at 8:49 am
Hi Melanie,
Which version of Event Espresso are you using?
Which version of WordPress are you using?
That error usually means the DB user for your site does not have the correct privileges so EE can’t update the database correctly.
Did you make any changes to the site to cause the notice to be thrown?
|
|
britorthopaedic
|
July 5, 2016 at 9:18 am
Event Espresso version 3.1.37.7.P
WordPress version WP 4.4.4
Installed plugins
Gravity Forms by rocketgenius version 2.0.1,
Recent Category Posts Widget by E. George Stephanis version 2.0,
Custom Post Type Widgets by thingsym version 1.1.1,
Date and Time Widget by Donna Peplinskie version 1.1.0,
Event Espresso by Event Espresso version 3.1.37.7.P,
Google Doc Embedder by Kevin Davis, Dan Lester version 2.6,
Gravity Forms PayPal Standard Add-On by rocketgenius version 2.6,
Gravity Forms Zapier Add-on by rocketgenius version 1.8,
ImageMapper by A.Sandberg AKA Spike, Tarmo Toikkanen version 1.2.6,
Jetpack by WordPress.com by Automattic version 4.0.4,
Mailchimp Forms by Optin Cat by Fatcat Apps version 1.5.8,
PHP Code Widget by Otto version 2.3,
Pods – Custom Content Types and Fields by Pods Framework Team version 2.6.6,
Post Types Order by Nsp Code version 1.8.9.2,
Seriously Simple Podcasting by Hugh Lashbrooke version 1.14.8,
Seriously Simple Stats by Hugh Lashbrooke version 1.0,
ShiftNav Pro – Responsive Mobile Menu by Chris Mavricos, SevenSpark version 1.1.1-beta-1,
Simple 301 Redirects by Scott Nellé version 1.07,
UberMenu 2 – WordPress Mega Menu Plugin by Chris Mavricos, SevenSpark version 2.4.0.3,
User Role Editor by Vladimir Garagulya version 4.25.2,
Yoast SEO by Team Yoast version 3.3.2,
WP Business Intelligence Lite by WP Business Intelligence version 1.6.7
Settings
Home URL http://www.boa.ac.uk
Site URL https://www.boa.ac.uk
Registration Pages
Event Page #4460 – http://www.boa.ac.uk/event-registration/
Payment/Thank You Page #4462 – http://www.boa.ac.uk/thank-you/
Transaction Notification Page #4466 – http://www.boa.ac.uk/transactions/
Cancel Return Page #4464 – http://www.boa.ac.uk/registration-cancelled/
Server Environment
PHP Version 5.6.22
Server Software Apache/2.2.31 (Unix) mod_hive/5.0 mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.9
WP Max Upload Size 10 MB
Server upload_max_filesize 10 MB
Server post_max_size 20 MB
WP Memory Limit 256 MB
WP Debug Mode No
Espresso Logging Log directory is writable.
PHP Sessions
Session save path /home/boadev33/public_html/tmp/ is writable.
Session name PHPSESSID
Remote Posting/IPN
fsockopen/cURL Your server has fsockopen and cURL enabled.
|
|
britorthopaedic
|
July 5, 2016 at 9:20 am
I have not intentionally made changes to the site, this only started happening thursday last week. I am logged in as an administrator on the site and so there shouldnt be permission issues.
|
|
Tony
|
July 5, 2016 at 9:43 am
I have not intentionally made changes to the site, this only started happening thursday last week.
Did you update EE to trigger that notice?
The function that displays that notice is only ran when EE is attempting to migrate the data from one format to another. So I’m just trying to figure out what caused the function to run.
I am logged in as an administrator on the site and so there shouldnt be permission issues.
That’s your user account permissions which is different from the database user your site uses.
|
|
britorthopaedic
|
July 5, 2016 at 9:50 am
I did try and upgrade the site to EE4 which failed so I left it as it was, but that was a few weeks ago and I havent done anything since. The events were working fine in EE3 after that.
Melanie
|
|
britorthopaedic
|
July 6, 2016 at 3:41 am
Hi
Whats the best way to move forward with this? Can I role back or is there a script I can run to look at the resolving the issue?
Melanie
|
|
Josh
|
July 6, 2016 at 8:43 am
Hi Melanie,
We logged in and took a look at the site and logged some errors. The reason that you’re not able to activate or deactivate plugins is because the WordPress options table needs to be repaired. Here’s the error message that appears throughout the log file (with server details removed)
[06-Jul-2016 14:28:14 UTC] WordPress database error Table 'x_options' is marked as crashed and should be repaired for query INSERT INTO
Once the table is repaired your site’s plugins page and anything else that writes to the options table (like EE3) will be able to function again. It looks like this site is hosted on Siteground, so you can run the repair script by logging into your account and following this guide:
https://www.siteground.com/kb/how_to_repair_a_mysql_database/
|
