|
lee@safeswim.com
|
July 23, 2017 at 9:10 pm
Hi, I just updated event espresso to Version 4.9.44.p and the event selector page does not advance to the registration page after the update. Instead the following error massage is popping up:
The following errors have occurred:
A database error has occurred. Turn on WP_DEBUG for more information.
A valid Transaction was not found when attempting to update the model entity mapper.
|
|
Tony
|
July 24, 2017 at 6:31 am
Hi there,
If you enable WP_DEBUG on the site do you see the full error message?
|
|
lee@safeswim.com
|
July 24, 2017 at 8:53 am
I eblieve this is the error code when in WP-DEBUG:
An EE_Error exception was thrown! code: EEM_Base – _do_wpdb_query – 2201
“WPDB Error: “INSERT command denied to user ‘dbo353408887’@’66.175.239.44’ for table ‘wpesp_line_item'””
click to view backtrace and class/method details
/homepages/18/d156217255/htdocs/CprTraingingPro.comNEW/CprTrainingPro.com/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php ( line no: 2201 )
|
|
Tony
|
July 24, 2017 at 9:03 am
Yes, that’s the one.
The user for your site does not have access to insert rows into the tables of the database (if not all then some).
I’d recommend contacting your host to have them update the permissions on your MySQL user account to fix this, if you provide them with the above error they should be able to take it from there.
|
|
lee@safeswim.com
|
July 24, 2017 at 9:57 am
Ok I will contact my host. I submitted a priority support token, can you hold on it until I contact my host? In case more issues need to be resolved. thanks.
|
|
lee@safeswim.com
|
July 24, 2017 at 10:26 am
I contacted my host and they said it the error was due to Event Espresso plugin. I submitted a priority support token, can you please proceed with the priority support? I don not think I am going to get help from 1and1 (website host). Thank you.
|
|
Josh
|
July 24, 2017 at 10:33 am
Hi there,
I don’t see how we could have the access level to change the permissions for your database user. Dose the support tech from your host have the ability to at least verify database user permissions? The error message indicates that it isn’t due to Event Espresso, it’s a database permissions issue.
|
|
lee@safeswim.com
|
July 24, 2017 at 10:43 am
The problem didn’t occur until I did the update yesterday to event espresso to Version 4.9.44.p. Is there a previous version I can try to install to see if it will work?
|
|
Josh
|
July 24, 2017 at 10:52 am
I tried your previously installed version (4.9.40.p) and the same error occurs.
Does the support tech from your host have the ability to at least verify database user permissions?
|
|
Josh
|
July 24, 2017 at 11:21 am
Along with the above, your site doesn’t allow doing any common WordPress tasks like adding new categories, posts, and pages. It appears that the database user’s INSERT privilege for all of the WP tables needs to be restored.
|
|
lee@safeswim.com
|
July 24, 2017 at 11:31 am
If there is not enough storage in the database could that be causing the issues?
|
|
lee@safeswim.com
|
July 24, 2017 at 11:39 am
The database is over the storage limit. I am having the database storage increased and will see if that resolves the issue. I will report back asap.
|
|
Josh
|
July 24, 2017 at 11:44 am
If there is not enough storage in the database could that be causing the issues?
Yes.
|
|
lee@safeswim.com
|
July 24, 2017 at 12:51 pm
Hi, so my host increased the database storage which resolved the first issue (step 1 Attendee Information) however the payment screen options are not showing after the registration form (step 2 Payment Options). It should show payment form and then braintree credit card form at the bottom of the page.
|
|
Josh
|
July 24, 2017 at 1:40 pm
It looks like someone added some CSS to your site that hides all the payment forms:
https://www.evernote.com/l/AAQfazSVwlZJdreF5Y9DRfOcNllyx0OCQxM
I can go ahead and remove the errant CSS.
|
|
lee@safeswim.com
|
July 24, 2017 at 1:44 pm
Yes, please do. I’m not sure why that CSS would have been used. Where did you find that?
|
|
Josh
|
July 24, 2017 at 1:49 pm
in wp-content/themes/u-design-child/style.css line 733. It’s removed now and you’ll need to clear your browser’s cache to use the updated stylesheet.
|
