Events-Manager Database Error

  • I’m having a the same problem despite installing different versions of Events Manager,and I can’t quite figure out how to solve it. I’ve tried installing other similar plug-ins like Events Manager Extended, but have had problems with the widgets. EM seems to be working well, except I’m having problems saving locations, which making saving new events impossible. I need to solve this soon! So if anyone has any ideas I’d be very thankful.

    The message i’m getting is:

    WordPress database error: [Table ‘…/em_bookings’ doesn’t exist]

    and

    WordPress database error: [Table ‘…/em_events’ doesn’t exist]

    I’ve now upgraded to EM 4.04, also, I’m posting here since their forums are currently down.

    Any solutions?!

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)

  • I also installed EM, then EME, then went back to EM (latest)… Started first w/ Jet Pack. I had to manually delete the EM(E) plug-ins and manually clear the database tables. Unfortunately, now I cannot create locations and get “Could not save the location details due to a database error.”

    Hopefully someone can help…

    Thread Starter drelan

    (@drelan)

    how did you clear the tables? and do you know if there’s anyway to create an event in that case without a location?

    you’re going to have issues if you’ve installed/uninstalled all these plugins. too many possibilities.

    I suggest you first delete all tables in the form of wp_em_… (note that wp_ might be a little different on your db).

    Then you need to delete all wp_options with ‘dbem_’ so you could use this:

    DELETE FROM wp_options WHERE option_name LIKE '%dbem_%';

    After that just install the latest v from scratch and you should be fine.

    @drelan, currently you need a location. people that want this behaviour usually just assign a default blank location (you can set default locations in the Events > Settings) and ommit all location placeholders and widgets from the front-end.

    Thread Starter drelan

    (@drelan)

    Thanks Marcus, ideally the location would be needed for the bookings, I only figured if it might be a way around the problem. Thank you for the help, though I’m not sure I understand it. I’ve installed DBManager, but i’m still unsure of how I might find and delete the em tables, and this command

    DELETE FROM wp_options WHERE option_name LIKE '%dbem_%';

    do i run it as an SLQ query.

    Very sorry, am not so familiar with SLQ or php for that matter, will continue googling, thanks for the help!

    Marcus, Thanks.

    The SQL line was the life saver, everything is working great now. Thanks for supporting your plugin. The buddypress integration is killer… perfect compliments.

    Other feedback: when bookings are disabled, subscribers still get the bookings menu… couldn’t find another setting other than unchecking user capabilities, which didn’t remove “my event bookings” either

    categories creation dead-ends after you “update category”. I have to click categories, Add New, then create another category. The EMExtended interfacing was a bit smoother here.

    Thanks again… will be using this plugin on another site next week.

    Thread Starter drelan

    (@drelan)

    still having database problems here which are preventing a location save. hmphf, any other ideas?

    you need to remove all traces of EM, since I don’t know how EME conflicts with it these days, remove EME and then install EM.

    what I gave you was SQL you need to feed your mysql database e.g. with phpmyadmin

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Events-Manager Database Error’ is closed to new replies.