[Plugin: Events Manager] Upgrade 4.0.4

is this in 4.0.4?

Yes, 4.0.4, i was locked out of WP altogether.

I deleted the EM folder which allowed me back into WP. I then installed 3.0.98 and all the events were back, but it would not allow me to add a new event… ‘Could not save the event details due to a database error.’ So i upgraded to 4.0.5 and it said it was successful, but then it closed that window and sent me to the WP Login page, which then gave a ‘500.htm’ message, and locked me out.
I put 3.0.98 back so people can see events, but i have been making changes in EM every week for almost two years and am not ready to lose a good thing. How should i proceed?

First step, have you checked the upgrade walkthrough? https://wp-events-plugin.com/news/upgrade-issues-screencast-walkthrough/

Then you need to import bookings, go to your Event settings page after installing. FYI, I just rewrote the import script today for bookings, which’ll go into the next update. I advise you wait for that (or try the dev version, i updated it just now)

I tried 4.0.6 with basically the same results. The installation stalls out, and then it gives me a blank white page. I can go to the website and see that a new version has been installed, but i can not go to WP admin to add a post, or to add an event, or go to the events settings page, or do anything at all. I am locked out of WP until i re-install 3.0.98.

we’ll be releasing a new update but I’m not sure this will help you. if you follow the instructions, it should work.

When you get the 500 error, do you get any errors in your php logs?

With 4.0.6 i did not get a 500.htm, just a blank white screen.

There are about 20 errors that start out the same as these two.

1) Too many keys
[04-Jun-2011 12:32:21] WordPress database error Too many keys specified; max 64 keys allowed for query ALTER TABLE wp_em_tickets_bookings ADD INDEX (ticket_id) made by require_once, require_once, require_once, require_once, do_action, call_user_func_array, em_init, em_install, em_create_tickets_bookings_table, dbDelta

2) Unknown column
[04-Jun-2011 12:41:20] WordPress database error Unknown column ‘event_seats’ in ‘wp_em_events’ for query ALTER TABLE wp_em_events CHANGE event_seats event_spaces int(5) made by require_once, require_once, require_once, require_once, do_action, call_user_func_array, em_init, em_install, em_create_events_table

I will try 4.0.7 when it comes out.
But if that doesnt work, i cant use 3.9.8, and i cant use 4.0.6, so please tell me what to delete (even if it means losing everything) so i can start over with a clean 4.0.x. Or, i would be more than happy to pay you for extra help to resolve this.

Same thing happened to me. Install hangs and then white screen on both the home page and admin page preventing any reversal. I’d say this does not work.

there’s an issue with the home screen not working if you assign the Events Page, haven’t had a chance to look into this yet.

there’s a problem with dbdelta and adding keys when they already exist. in theory it shouldn’t add extra keys but it does. looking into this too

if you go into your db and delete the indexes manually, that’ll fix that issue for now.

just fixed this in the dev version, it should prevent adding duplicates and also remove the duplicate keys.

update may take longer than usual if you have lots of duplicate keys. this should probably speed things up a bit for some

Not sure if this is the right place to post a bug, but the most recent version of events manager seems to require a date picker (which I presume to be a little java or ajax calendar of some description).

However, there is no such ‘date picker’ in my install. So when I try to manually enter the date, the predictable ‘can’t do that, please use the date picker’ type of error shows up.

Can anyone help?

you probalby have a conflicting theme or plugin preventing the datepicker from showing up