|
Sebastien Marchal
|
January 14, 2016 at 11:49 am
Hello,
I am having the exact same issue as another user outlined in this post:
https://eventespresso.com/topic/duplicate-registration-starts-and-prices/
Would you be able to provide instructions on how the fixes should be applied to the database please?
We are running EE3 on WordPress 4.2.6.
The calendar is used by a department at Brock University, where I work, so unfortunately I am unable to give you direct access to the database as it is on an internal server. I would be grateful if you could provide some instructions so that we can apply the database fixes ourselves (through PhpMyAdmin). Thank you so much.
Sebastien
-
This topic was modified 8 years, 11 months ago by
 Sebastien Marchal.
-
This topic was modified 4 years, 9 months ago by
 Garth.
|
|
Lorenzo Orlando Caum
|
January 14, 2016 at 1:17 pm
Hi Sebastian,
Please note that issue will continue if your Event Espresso 3 software is out of date due to security fixes in WordPress.
Here are the steps:
1) Backup your WordPress site including the database (https://eventespresso.com/wiki/how-to-back-up-your-site/)
2) Deactivate Event Espresso through the Plugins screen in your WP dashboard
3) Login to your database using a tool like PHPMyAdmin
4) You’ll be making changes to three database tables:
wp_events_start_end
wp_events_prices
wp_events_category_rel
Go ahead and locate the wp_events_start_end database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.
5) Locate the wp_events_prices database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.
6) Locate the wp_events_category_rel database table and click on it. Then click on the event id column to sort and you’ll see some rows that have 0 (zero) for the event id. Remove only these rows that have 0 for the event id.
7) Return to your WordPress dashboard and then reactivate Event Espresso 3 along with its add-ons.
Thanks
—
Lorenzo
|
|
Sebastien Marchal
|
January 15, 2016 at 6:46 am
hi Lorenzo,
Thank you for your quick reply. I’ve made these changes to the database and the issue appears to be gone.
Thank you very much!
Sebastien
|
|
Lorenzo Orlando Caum
|
January 15, 2016 at 8:41 am
Thanks for confirming Sebastien. Enjoy your weekend!
—
Lorenzo
|
