Hi Michael,
Yes, that worked and was able to add the table, and now I can add redirections.
Both modules are activated since the first install, so yeah a bit puzzling why their respective tables were not added.
Could I trouble you for the SQL CREATE TABLE for the other 3 missing tables?
rank_math_redirections_cache
rank_math_schema
rank_math_schema_cache
Thanks in advance,
Jaume
Hello,
Thank you for contacting Rank Math today.
You can use this for the Rank math redirection cache table.
CREATE TABLE wp_rank_math_redirections_cache (
id bigint(20) UNSIGNED NOT NULL,
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_ci NOT NULL DEFAULT 'post',
is_redirected tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
—
— Indexes for dumped tables
—
—
— Indexes for table wp_rank_math_redirections_cache
—
ALTER TABLE wp_rank_math_redirections_cache
ADD PRIMARY KEY (id),
ADD KEY redirection_id (redirection_id);
Allow me to consult concerning the remaining tables
Looking forward to helping you. Thank you.
Hi Jaume,
Please head over to WordPress Dashboard > Rank Math > Dashboard.
Enable the Schema/Rich Snippets module.
If it is already enabled, please disable it and enable it again.
That should add the missing Schema tables.
Hi Todd,
unfortunately, turning the schema on and off didn’t work, even after updating to 1.0.43.
Hello,
Thank you for contacting Rank Math today.
You can try performing a clean installation Deactivate and delete the plugin then reinstall and activate itof the plugin to recreate the tables. Don’t forget to back up your settings first by heading over to Rank math> Status & Tools > Import/Export and Export your settings.
Looking forward to helping you. Thank you.
Hi Michael,
Yes, I did that, deleting the plugin and reinstalling, but it did not help. The schema-related tables have still not been created.
Jaume
Hello,
Thank you for contacting Rank Math today.
Allow me to consult further on the details of the schema table and will get back to you.
Looking forward to helping you. Thank you.
Hi,
Let’s take a step back here.
Please explain the issue.
I mean, you see the table is missing but are you facing any issues?
If so, please give us the steps so we can try and replicate it from our end.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.
