-
I have the same problem as here:
https://support.rankmath.com/ticket/cant-add-redirections/
I’ve tried recreating the missing database tables,
(in Rank Math > Status & Tools > Database Tools > Re-create Tables) – no luck.Error log does show:
[05-Aug-2021 08:49:53 UTC] WordPress database error Incorrect table definition; there can be only one auto column and it must be defined as a key for query ALTER TABLE wp_rank_math_404_logs CHANGE COLUMN
idid BIGINT(20) unsigned NOT NULL AUTO_INCREMENT made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMathRestAdmin->tools_actions, apply_filters(‘rank_math/tools/recreate_tables’), WP_Hook->apply_filters, RankMathToolsDatabase_Tools->recreate_tables, RankMathInstaller::create_tables, dbDelta[05-Aug-2021 08:49:53 UTC] WordPress database error ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’ for query ALTER TABLE wp_rank_math_redirections CHANGE COLUMN
idid BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMathRestAdmin->tools_actions, apply_filters(‘rank_math/tools/recreate_tables’), WP_Hook->apply_filters, RankMathToolsDatabase_Tools->recreate_tables, RankMathInstaller::create_tables, dbDelta[05-Aug-2021 08:49:53 UTC] WordPress database error ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’ for query ALTER TABLE wp_rank_math_redirections_cache CHANGE COLUMN
idid BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, RankMathRestAdmin->tools_actions, apply_filters(‘rank_math/tools/recreate_tables’), WP_Hook->apply_filters, RankMathToolsDatabase_Tools->recreate_tables, RankMathInstaller::create_tables, dbDeltaI’ve tried the troubleshooting/conflicting plugins guide
https://rankmath.com/kb/check-plugin-conflicts/ and no luck there either.
There’s 10GB of space and site is taking up 2GB.I’ve taken a backup of rankmath and uninstalled the plugin, then reinstalled, that didn’t work either.
Similar problems here:
https://support.rankmath.com/ticket/cant-add-redirect-from-www/
https://support.rankmath.com/ticket/not-able-to-add-redirection/
https://support.rankmath.com/ticket/unable-to-add-redirect/
-
Hello,
Thank you for contacting the support, and sorry for any inconvenience that might have been caused due to that.
Could you please share your WordPress admin login and your PHPmyadmin panel so we can further investigate your issue and provide a solution?
Please edit the first post on this ticket and include your WordPress, Phpmyadmin & FTP logins in the designated Sensitive Data section.
Please do take a complete backup of your website before sharing the information with us.
It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:
https://wordpress.org/plugins/temporary-login-without-password/
You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):
https://wordpress.org/plugins/wp-security-audit-log/
We really look forward to helping you.
You must be logged in to reply to this ticket.