• Resolved fullworks

    (@fullworks)


    Just installed and getting database errors on some functions, seems a table is missing. Should I reinstall?

    WordPress database error: [Table ‘wp.wp_eme_people’ doesn’t exist]

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

    (@liedekef)

    Yes, first uninstall by first setting the EME option to remove all database tables and settings (see the EME options page). Then deactivate, uninstall and reinstall.
    After that, check your webserver logfiles for errors, maybe there’s a hint in there (make sure to log php errors of course).

    Thread Starter fullworks

    (@fullworks)

    Sorry should have looked in debug log straight away – looks like an an extra comma on line 953 of events-manager.php

    events-manager.php:953: KEY (status),

    [25-Aug-2018 10:32:02 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci’ at line 24 for query CREATE TABLE wp_eme_people (
    person_id mediumint(9) NOT NULL AUTO_INCREMENT,
    lastname tinytext NOT NULL,
    firstname tinytext DEFAULT ”,
    email tinytext NOT NULL,
    status tinyint DEFAULT 1,
    phone tinytext DEFAULT NULL,
    wp_id bigint(20) unsigned DEFAULT NULL,
    address1 tinytext DEFAULT ”,
    address2 tinytext DEFAULT ”,
    city tinytext DEFAULT ”,
    zip tinytext DEFAULT ”,
    state tinytext DEFAULT ”,
    country tinytext DEFAULT ”,
    state_code tinytext,
    country_code tinytext,
    lang varchar(10) DEFAULT ”,
    massmail bool DEFAULT 1,
    properties text DEFAULT NULL,
    creation_date datetime DEFAULT CURRENT_TIMESTAMP,
    modif_date datetime DEFAULT CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    UNIQUE KEY (person_id),
    KEY (status),
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; made by activate_plugin, do_action(‘activate_events-made-easy/events-manager.php’), WP_Hook->do_action, WP_Hook->apply_filters, eme_install, _eme_install, eme_create_tables, eme_create_people_table, maybe_create_table

    • This reply was modified 6 years, 7 months ago by fullworks.
    Plugin Author Franky

    (@liedekef)

    You’re absolutely correct! I’ll fix and release a new version asap (the new version also no longer supports the now-almost-paying google maps but OpenStreetMap)

    Thread Starter fullworks

    (@fullworks)

    I look forward to seeing it.

    Plugin Author Franky

    (@liedekef)

    Just released the new version.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database tables missing’ is closed to new replies.