EME Installation – DB tables missing

  • Resolved nicecap

    (@nicecap)


    6 years, 2 months ago

    Hello.

    I recently installed EME to my website – when I try to add an event I get the following error: “An error occured while communicating to the server” in the backend. I can move on but then I get errors when I press the SAVE button on the Add Events page:
    WordPress database error: [Table ‘wp_heyday.wphd_eme_events’ doesn’t exist]
    SHOW FULL COLUMNS FROM wphd_eme_events

    WordPress database error: [Table ‘wp_heyday.wphd_eme_events’ doesn’t exist]
    SHOW FULL COLUMNS FROM wphd_eme_events

    WordPress database error: [Table ‘wp_heyday.wphd_eme_categories’ doesn’t exist]
    SELECT * FROM wphd_eme_categories ORDER BY category_name ASC

    When I check my database I find 4 EME tables
    wpcn_eme_events_cf
    WPcn_eme_groups
    wpcn_eme_locations_cf
    wpcn_eme_usergroups

    Obviously, there are at least 2 eme tables missing – wpcn_eme_events and wpcn_eme_categories.

    I don’t think that my database is the problem because I run into the same issues when I install the plugin on a brandnew wordpress site with a brandnew database; no other plugin installed.

    I cannot find any logfiles on my linux/Apache server which would include any eme_ database SQL.

    Please help
    Best
    Chris

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Franky

    (@liedekef)

    You’re missing a lot of EME tables. Which version of mysql are you using?

    Thread Starter nicecap

    (@nicecap)

    Hi Franky.

    MySQL Version is 5.5.62
    PHP Version is 7.1.25

    Chris

    Plugin Author Franky

    (@liedekef)

    I think 5.5 went EOL end 2018, so I advise to update to a newer version ??
    I no longer have a provider that even presents 5.5 as an option, but I’ll check this evening for 5.5 issues (I think I know the reason, but in fact I should just stop supporting 5.5).

    Same problem here. My Hoster offers only MySQL 5.5. Is there already a version of the plugin in which the problem is solved?

    Edit Hoster is 1&1 Ionos

    • This reply was modified 6 years, 1 month ago by stefda.
    Plugin Author Franky

    (@liedekef)

    No support for mysql 5.5 anymore. Either use an older version of the plugin or use another hoster.

    … mir geht es leider genauso … ein Wechsel zu einem anden Hoster mit h?herer SQL Version ist derzeit eher schwierig. Mit welcher Version von EME würden denn MySQL 5.5 funktionieren und wo k?nnt man die noch herbekommen. Ich sonst überhaupt keine M?glichkeit das Plugin zu testen.

    Vielen Dank.

    Plugin Author Franky

    (@liedekef)

    I’m sorry but asking the same question won’t result in a different answer. 5.5 is unsupported, see https://endoflife.software/applications/databases/mysql
    I’m not advertising older versions of EME, for the simple reason that those contain other flaws, bugs or security issues, next to the fact they lack newer features.
    If you currently use EME and it works: stay on that version. If you’re a new user: ask your provider to change mysql versions or change provider.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘EME Installation – DB tables missing’ is closed to new replies.