Database error: table not found after installation

  • Resolved cseto

    (@cseto)


    7 years, 1 month ago

    Hi,

    I’m running a multisite and installed Events Manager. With Query Monitor on, I’m getting the following error:

    Table ‘xxx.wp_em_events’ doesn’t exist

    Error code: 1146

    Because that table doesn’t exist, events on subsites can’t be saved – on subsites there is the additional error for the booking table not existing.

    The strange thing is that on my local multisite install, it works right out of the box, no errors from Query Monitor.

    I’ve been searching for answers and some suggestions are:
    1. to create the table manually
    2. drop the table and recreate the table, because the error is that the table actually exists but is not detected
    3. reinstall plugin – did that but no result
    4. talk to host about restarting mySQL – did that but no result

    Any help would be greatly appreciated.

    Thanks,
    Conrad

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter cseto

    (@cseto)

    7 years, 1 month ago

    Checking my pages, there is a set of Events, Tags, Booking, Categories, Locations pages from my initial install and for each time I uninstalled and re-installed it.

    timrv

    (@timrv)

    7 years, 1 month ago

    Hello,

    Have you made sure that the Database User of your WordPress have the correct database persmissions? ie: make sure that the user could create/modify tables. Have you also checked the Full Documentation for Multi-Site? https://wp-events-plugin.com/documentation/multisite/

    Thread Starter cseto

    (@cseto)

    7 years, 1 month ago

    Hi,

    I will check about the database permissions and update.

    Thanks

    Thread Starter cseto

    (@cseto)

    7 years, 1 month ago

    Hi,

    I talked to support and they confirmed that the database user has the privileges and it is set properly.

    Thanks

    Thread Starter cseto

    (@cseto)

    7 years, 1 month ago

    Hi,

    I checked the database in phpMyAdmin and the main site’s tables are wp_1_x rather than wp_x.
    So the plugin did create a table, but it is wp_1_em_events.

    What would be the solution for this situation?
    Should I manually create a wp_em_events table?
    If I do, would the fact that all of the main site’s tables are wp_1_x affect the plugin?

    Thanks

    Plugin Support angelo_nwl

    (@angelo_nwl)

    7 years, 1 month ago

    seems you are also an EMpro user? we already answered you in your EMPro thread.

    Thread Starter cseto

    (@cseto)

    7 years, 1 month ago

    Yes, I upgraded to pro after posting this thread. Thank you for addressing my issue.

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

The topic ‘Database error: table not found after installation’ is closed to new replies.