Debugging errors upon activation

  • vickita

    (@vickita)


    6 years ago

    I had occasion to deactivate this plugin on my dev server today in the process of debugging another issue, and when I reactivated it, I got a boatload of entries in my debugging logs of the form

    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEXfaulh_user_traker_index; check that it exists for query ALTER TABLEmydb_fa_user_loginsDROP INDEXfaulh_user_traker_index made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index
    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEX faulh_user_traker_index_0; check that it exists for query ALTER TABLE mydb_fa_user_logins DROP INDEX faulh_user_traker_index_0 made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index
    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEX faulh_user_traker_index_1; check that it exists for query ALTER TABLE mydb_fa_user_logins DROP INDEX faulh_user_traker_index_1 made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index
    …
    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEX faulh_user_traker_index_22; check that it exists for query ALTER TABLE mydb_23_fa_user_logins DROP INDEX faulh_user_traker_index_22 made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index
    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEX faulh_user_traker_index_23; check that it exists for query ALTER TABLE mydb_23_fa_user_logins DROP INDEX faulh_user_traker_index_23 made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index
    [17-Dec-2019 23:10:05 UTC] WordPress database error Can’t DROP INDEX faulh_user_traker_index_24; check that it exists for query ALTER TABLE mydb_23_fa_user_logins DROP INDEX faulh_user_traker_index_24 made by require(‘wp-admin/plugins.php’), activate_plugin, do_action(‘activate_user-login-history/user-login-history.php’), WP_Hook->do_action, WP_Hook->apply_filters, activate_faulh, Faulh_Activator::activate, Faulh_Activator::create_table, drop_index

    where it ran for each site id in the multisite network.

    So then I tried deactivating and reactivating on one of my ops sites, and had the exact same experience.

    Both sites running current versions of WP and the plugin. The dev site had plugins deactivated and running TwentyTwenty.

    It seems to be running now, but do you have any idea what this was about?

    • This topic was modified 6 years ago by vickita.
Viewing 1 replies (of 1 total)
  • Plugin Author Faiyaz Alam

    (@faiyazalam)

    5 years, 12 months ago

    @vickita

    During activation, it deletes index “faulh_user_traker_index” from the plugin table. In your case, it could not find the index to be deleted. This is the reason of the error log. You do not need to worry about this index error message.

    Hope this helps.

Viewing 1 replies (of 1 total)

The topic ‘Debugging errors upon activation’ is closed to new replies.