phpErrorlog entries DB error

  • Hello,
    After the last update I get the folllowing db error
    CREATE TABLE IF NOT EXISTS xxxxx_twofas_trusted_devices (
    id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    user_id bigint(20) unsigned NOT NULL,
    device_id varchar(255) NOT NULL,
    cookie_value varchar(255) NOT NULL,
    ip varchar(50) NOT NULL,
    created_at bigint(20) NOT NULL,
    last_logged_in bigint(20) unsigned DEFAULT NULL,
    user_agent text NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (user_id) REFERENCES xxxxx_users (id) ON DELETE CASCADE
    ) ENGINE = INNODB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci von require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, twofas_start, require_once(‘/plugins/2fas/start.php’), TwoFAS\TwoFAS\Core\Plugin->run, TwoFAS\TwoFAS\Update\Updater->update_plugin, TwoFAS\TwoFAS\Update\Migrator->migrate, TwoFAS\TwoFAS\Update\Migrations\Migration_2018_11_30_Create_Trusted_Devices_Table->up, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query

    How can i fix it ?
    best regards
    Marco

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author 2FAS

    (@2fas)

    We’ve released a new version of the plugin. Please update the plugin to the newest version. We hope it solves the problem.

    • This reply was modified 5 years, 8 months ago by 2FAS.
    Thread Starter marcooderkerk

    (@marcooderkerk)

    Hi , no it doesn’t help but i found the error.
    i guess because my wordpress db had been created with wp 4.? my users table was myisam.
    the twofas_trusted_devices is innodb.
    as i know there is no possibility to add a foreign key constraint on myisam. i switched to innodb an create the table manually.

    Plugin Author 2FAS

    (@2fas)

    Thank you for the information.
    This is a problem but we cannot help it, if two related tables are of a different engines. Innodb is standard engine of mysql 5.5 and it’s prevent from orphan rows in database by relationships.
    We are glad that you managed with this problem.
    If you can, please contact us at [email protected], we have one more suggestion for you regarding to this problem.

    • This reply was modified 5 years, 8 months ago by 2FAS.
    Plugin Author 2FAS

    (@2fas)

    We decided to change our migration in new version 2.4.2 and remove foreign keys to wp_users table because there are more users with this problem.
    For users who have already made an update, nothing will change.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘phpErrorlog entries DB error’ is closed to new replies.