Elementor e_event Database Errors

  • Resolved MellowLyric

    (@darrylbosch)


    2 years ago

    On my local site running on WampServer 3.3.0, I get the following two errors in my PHP_Error.log file with every click of the mouse whether I’m working in wp-admin or navigating the site while not logged in:

    [19-Feb-2023 16:15:21 UTC] WordPress database error Table ‘_prefix_e_events’ already exists for query CREATE TABLE _PREFIX_e_events (
    id bigint(20) unsigned auto_increment primary key,
    event_data text null,
    created_at datetime not null
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Frontend->init, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->create_table

    [19-Feb-2023 16:15:21 UTC] WordPress database error Duplicate key name ‘created_at_index’ for query ALTER TABLE _PREFIX_e_events
    ADD INDEX created_at_index (created_at)
    made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Frontend->init, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->add_indexes

    This site was created using an export/import using Duplicator Pro from my live site. I don’t not get these errors on my live site. On my local site, I quickly get thousands of errors in my PHP_Error.log file. So many that it makes it hard to find if there are any other errors.

    I’m using OceanWP child theme with several OceanWP plugins. I have changed my theme to WordPress twenty twenty-two theme and still get the same errors. I have deactivated all plugins and the errors remain. Only deactivating Elementor plugin removes the errors.

    This error was present before the most recent plugin update. I’ve also confirmed with OceanWP that all their plugins are compatible with the latest release of Elementor plugin.

    I have used Duplicator Pro to move the local site back to the live site hosted on Bluehost and there are no errors on the live site.

    I’ve captured the information requested in “Before You Post” post and saved it to pastebin. There are two pastes: PHP Errors and System Info.

    Note: In the reports, I’ve changed the actual table prefix to “prefix” for security reasons.

    Thanks for your assistance.

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

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

  • Hi,

    Kindly check at this documentation at StackOverflow –?https://stackoverflow.com/questions/35999802/where-to-change-the-value-of-lower-case-table-names-2-on-windows-mysql

    So you may open the SQL configuration file. (On XAMPP it is?my.ini)
    immediately below?#[mysqld]:
    Add line?lower_case_table_names = 2

    Please note that through this channel, we can only provide support for Elementor’s existing features and do not provide support for custom code solutions, as it goes out of our support scope.

    Currently, development/custom code queries (custom widgets and functions, Theme Child, custom code and CSS, BETA testing issues, compatibility issues, etc.) have to be directed to our GitHub project, where our developers will be able to assist. Kindly note that our GitHub project is not a support channel; therefore, the response times may vary. We appreciate your understanding.

    Thread Starter MellowLyric

    (@darrylbosch)

    Thank you for the reply. I understand the problem related to case sensitivity between my live (Linux) and local (Windows) systems.

    I tried your solution but my WampServer wouldn’t start with the MySQL error: “Different lower_case_table_names settings for server (‘2’) and data dictionary (‘1’)”

    After some more research, I have learned that I need to start over and reinitialize MySQL data directory. This is beyond the scope of this forum, so I’ll leave it there.

    Thanks for pointing me in the right direction.

    • This reply was modified 2 years ago by MellowLyric. Reason: typo
    Thread Starter MellowLyric

    (@darrylbosch)

    A follow up comment for anyone interested. I was able to eliminate the errors by editing wp-config.php and leaving my.ini untouched.

    After shutting down WampServer, I edited wp-config.php, changing the prefix in $table_prefix from uppercase to lowercase. I restarted WampServer and the errors are gone. I did not make the suggested any changes to my.ini.

    Thanks again for setting me on the right path regarding case sensitivity.

    Thread Starter MellowLyric

    (@darrylbosch)

    Another follow up. The error logs are gone but after logging out, I could not log back in until I reversed my change to the wp-config.php file. Simply changing the prefix to lower case did not solve the problem. Back to initializing mySQL.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Elementor e_event Database Errors’ is closed to new replies.