- This topic has 3 replies, 2 voices, and was last updated 10 years, 5 months ago by .
Viewing 4 posts - 1 through 4 (of 4 total)
Viewing 4 posts - 1 through 4 (of 4 total)
- The forum ‘Generic’ is closed to new topics and replies.
Events Made Easy › Forums › Generic › WordPress database error…EME caused?
Tagged: database missing
I just got notified of a problem with our online reservation system. It’s been working fine for a few days, but now the calendar page displays this error:
[Table 'bigs4263_wp2.wp_eme_events' doesn't exist]
SELECT * FROM wp_eme_events WHERE event_status IN (1,2) AND (event_rsvp=0 OR (event_rsvp=1 AND event_seats > (SELECT COALESCE(SUM(booking_seats),0) AS booked_seats FROM wp_eme_bookings WHERE wp_eme_bookings.event_id = wp_eme_events.event_id))) AND ((event_start_date BETWEEN '2014-05-32' AND '2014-07-07') OR (event_end_date BETWEEN '2014-05-32' AND '2014-07-07') OR (event_start_date <= '2014-05-32' AND event_end_date >= '2014-07-07')) ORDER BY event_start_date ASC , event_start_time ASC
The internal event list is also not displaying, with a similar error at the top of the page.
I updated the plug-in a few days ago when the new version was posted, but it was working fine both before and after the update. Also, the option in the settings to delete the database when updating is set to NO, so I don’t know how/why the database would suddenly be missing. Not sure if it’s a plug-in flaw or not, but I’m reporting it anyway in case it is.
And is the table in fact gone? If it was working fine after the update, something else is wrong with your database.
I don’t know how to look for the table manually.
Just checked again. The database is back. I wrote to the web host admin earlier (the site is privately hosted), so perhaps he was able to do something. He didn’t write back, so I’m only guessing. Weird and annoying, but it’s working again.