---
title: "Rank Math SEO no es capaz de crear las tablas para activa redirecciones"
description: "Cuando no es posible crear las tablas de redirecciones en el plugin de SEO Rank Math desde el escritorio de WordPress solemos obtener algún error similar al siguiente: 73404#0: *13547595 FastCGI sent..."
url: https://wpdirecto.com/rank-math-seo-no-es-capaz-de-crear-las-tablas-para-activa-redirecciones/
date: 2023-05-31
modified: 2023-06-04
author: "David Carrero Fernández-Baillo"
image: https://wpdirecto.com/wp-content/uploads/2022/11/Rank-Math-PRO-ads-scaled.jpg
categories: ["Plugins"]
type: post
lang: es
---

# Rank Math SEO no es capaz de crear las tablas para activa redirecciones

Cuando no es posible crear las tablas de redirecciones en el [plugin de SEO Rank Math](https://wpdirecto.com/rankmath) desde el escritorio de WordPress solemos obtener algún error similar al siguiente:

*73404#0: *13547595 FastCGI sent in stderr: «PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
url_to text NOT NULL,
header_code smallint(4) …’ at line 3 for query CREATE TABLE cY2mOu61_rank_math_redirections (
id bigint(20) unsigned NOT NULL auto_increment,
sources text CHARACTER SET COLLATE _bin NOT NULL,
url_to text NOT NULL,
header_code smallint(4) unsigned NOT NULL,
hits bigint(20) unsigned NOT NULL default ‘0’,
status varchar(25) NOT NULL default ‘active’,
created datetime NOT NULL default ‘0000-00-00 00:00:00’,
updated datetime NOT NULL default ‘0000-00-00 00:00:00’,
last_accessed datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (id),
KEY status (status)
) 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…; PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
redirection_id bigint(20) unsigned NOT NULL,
o…’ at line 3 for query CREATE TABLE cY2mOu61_rank_math_redirections_cache (
id bigint(20) unsigned NOT NULL auto_increment,
from_url text CHARACTER SET COLLATE _bin NOT NULL,
redirection_id bigint(20) unsigned NOT NULL,
object_id bigint(20) unsigned NOT NULL default ‘0’,
object_type varchar(10) NOT NULL default ‘post’,
is_redirected tinyint(1) NOT NULL default ‘0’,
PRIMARY KEY (id),
KEY redirection_id (redirection_id)
) 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_RES*

Y la única forma posible que hemos encontrato para solucionar es ejecutar la creación de las 2 tablas que nos faltan de forma manual desde consola Mysql o MariaDB o también desde el PHPmyadmin de tu panel de control Plesk o Cpanel.

Puedes ejecutar este código SQL cambiando el prefijo de tu base de datos por el que tengas en tu instalación. Hemos puesto wpdirecto_ para que sea fácil de localizar y cambiar.

`DROP TABLE IF EXISTS `wpdirecto_rank_math_redirections`;
CREATE TABLE `wpdirecto_rank_math_redirections` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sources` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`url_to` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`header_code` smallint(4) unsigned NOT NULL,
`hits` bigint(20) unsigned NOT NULL DEFAULT '0',
`status` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

DROP TABLE IF EXISTS `wpdirecto_rank_math_redirections_cache`;
CREATE TABLE `wpdirecto_rank_math_redirections_cache` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`from_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`redirection_id` bigint(20) unsigned NOT NULL,
`object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`object_type` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
`is_redirected` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `redirection_id` (`redirection_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;`Lenguaje del código: JavaScript (javascript)

Esperamos que te sirva para poder utilizar el servicio de Redirección que incluye [Rank Math SEO](https://wpdirecto.com/rankmath).