Events-Manager Database Error

  • drelan

    (@drelan)


    15 years ago

    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)
  • grindflow

    (@grindflow)

    15 years ago

    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)

    15 years ago

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

    Marcus (aka @msykes)

    (@netweblogic)

    15 years ago

    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.

    Marcus (aka @msykes)

    (@netweblogic)

    15 years ago

    @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)

    15 years ago

    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!

    grindflow

    (@grindflow)

    15 years ago

    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)

    15 years ago

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

    Marcus (aka @msykes)

    (@netweblogic)

    15 years ago

    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.