DB problem after install

  • Resolved ABoooo

    (@aboooo)


    5 years, 1 month ago

    Hello,
    I’ve installed plugin, but I get a DB error message when I activate plugin.

    WordPress-Datenbank-Fehler: [Table '1314863db3.wp_em_events' doesn't exist]
SELECT COUNT(*) FROM wp_em_bookings LEFT JOIN wp_em_events ON wp_em_events.event_id=wp_em_bookings.event_id LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id WHERE ( event_start >= '2020-01-29 21:39:08' OR (event_end >= '2020-01-29 21:39:08')) AND event_owner=2 AND booking_status=0 AND wp_em_bookings.event_id != 0 ORDER BY booking_date

WordPress-Datenbank-Fehler: [Table '1314863db3.wp_em_events' doesn't exist]
SELECT COUNT(DISTINCT wp_em_events.event_id) FROM wp_em_events LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id WHERE (<code>event_status</code>=0) AND (<code>recurrence</code>!=1 OR <code>recurrence</code> IS NULL) AND event_owner=2 AND (<code>event_private</code>=0) ORDER BY event_start_date ASC, event_start_time ASC, event_name ASC LIMIT 1 OFFSET 0

WordPress-Datenbank-Fehler: [Table '1314863db3.wp_em_events' doesn't exist]
SELECT COUNT(DISTINCT wp_em_events.event_id) FROM wp_em_events LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id WHERE (<code>event_status</code>=0) AND <code>recurrence</code>=1 AND event_owner=2 AND (<code>event_private</code>=0) ORDER BY event_start_date ASC, event_start_time ASC, event_name ASC LIMIT 1 OFFSET 0

    If I add empty tables from another installation, then I cannot add any events as in the menu there is no option to add an event.

    Any suggestion how can I solve this?
    Thx

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

  • Hello,

    What versions of WP and EM are you using?

    Could you perhaps try and install a fresh copy of WordPress and Install EM on your hosting? This is to minimize possible conflicts. Please make also that the database user used on the database have all the permissions to add/remove/install on the database.

    Does doing a full uninstall then deleting of the plugin under Dashboard > Plugin doesn’t work also?

    Thread Starter ABoooo

    (@aboooo)

    Hello,

    I am using latest WP and EM versions.

    Yes, that is a possibility. I was just hoping I wouldn’t have to do it.

    Correct, deleting plugin through WP doesn’t work also. I tried to installed it through WP and with direct upload. It is the same. I also have admin rights in WP and DB.

    Thanks for your reply!

    Thread Starter ABoooo

    (@aboooo)

    Hello,

    I’ve reinstalled WP and now it is working again.

    Best regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘DB problem after install’ is closed to new replies.