Can’t DROP FOREIGN KEY Apache error

  • Resolved solvemyproblemuk

    (@solvemyproblemuk)


    3 years, 4 months ago

    Seeing these errors in the Apache log

    [Sat Jan 21 09:43:02.014846 2023] [php7:notice] [pid 411636] [client 114.219.22.70:33896] WordPress database error Can’t DROP FOREIGN KEY glsr_assigned_users_user_id_foreign; check that it exists for query \n ALTER TABLE wpdn_glsr_assigned_users DROP FOREIGN KEY glsr_assigned_users_user_id_foreign;\n made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘site-reviews/queue/migration’), WP_Hook->do_action, WP_Hook->apply_filters, GeminiLabs\SiteReviews\Controllers\QueueController->runMigration, GeminiLabs\SiteReviews\Modules\Migrate->run, GeminiLabs\SiteReviews\Modules\Migrate->runMigrations, GeminiLabs\SiteReviews\Migrations\Migrate_6_2_1->run, GeminiLabs\SiteReviews\Migrations\Migrate_6_2_1->migrateDatabaseIndexes, GeminiLabs\SiteReviews\Database\Tables\TableAssignedUsers->dropForeignConstraints, GeminiLabs\SiteReviews\Database\Tables\AbstractTable->dropForeignConstraint, GeminiLabs\SiteReviews\Database->dbQuery, referer: https://example/wp-cron.php?doing_wp_cron=1674294180.5959689617156982421875

Viewing 1 replies (of 1 total)
  • Plugin Author Gemini Labs

    (@geminilabs)

    3 years, 4 months ago

    Try this:

    1. Go to the Site Reviews > Tools > Console page and clear the log
    2. Deactivate Site Reviews
    3. Activate Site Reviews
    4. Go to the Site Reviews > Tools page, hold down the ALT key (option key on macOS) and run the Migrate Plugin tool
    5. Check the Console log and let me know if there are still error messages.

Viewing 1 replies (of 1 total)

The topic ‘Can’t DROP FOREIGN KEY Apache error’ is closed to new replies.