Can’t save meta title and description WPML

Also we have this error: WordPress database error Table ‘imstest1_gggtest.wp_rank_math_redirections_cache’ doesn’t exist

We tried to recreate database tables using rankmath tools, but the problem still exists.

When we try to recreate database tables we get this

[16-Jul-2023 12:41:27 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
url_to text NOT NULL,
header_code smallint(4) uns’ at line 3 for query CREATE TABLE wp_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, call_user_func_array, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, call_user_func, RankMath\Rest\Admin->tools_actions, apply_filters(‘rank_math/tools/recreate_tables’), WP_Hook->apply_filters, call_user_func_array, RankMath\Tools\Database_Tools->recreate_tables, RankMath\Installer::create_tables, dbDelta

mysqli

MysqlI SupportenabledClient API library versionmysqlnd 7.4.33

Hello @johnferz,

Thank you for contacting the support and sorry for the inconvenience caused.

We are already aware of the issue and working on resolving it. Currently, there is no quick fix for this as the query we use to create tables is failing on your site. You can disable the Redirections module of our plugin for now from WP Dashboard > Rank Math > Dashboard. We will inform you here as soon as we have fixed the issue.

We really appreciate your patience in the meantime.

Don’t hesitate to get in touch in case you need our assistance with anything else.

Thank you, but i see several problems:

For example this:

1. Bulk editing titles and descriptions of pages do not work at all.
Error 404 – el/wp-json/rankmath/v1/updateMetaBulk/
NO REST ROUTE.

2. We can’t save titles and descriptions of pages on secondary languages using snippet editor. After saving we see old titles and descriptions from yoast seo.

Disabling all plugins, except WPML plugins, and switching theme doesn’t solve this:

1. Bulk editing titles and descriptions of pages do not work at all.
Error 404 – el/wp-json/rankmath/v1/updateMetaBulk/
NO REST ROUTE.
2. We can’t save titles and descriptions of pages on secondary languages using snippet editor. After saving we see old titles and descriptions from yoast seo.

So, if i understand correctly, there is no compatibility with WPML, isn’t it?

Tried Yoast seo, works fine with titles and description on secondary languages. Rank Math don’t work. Why?

Hello @johnferz,

If the metadata is not getting saved for the secondary languages, there must be something on your site/server blocking our updateMeta route.

Please follow this guide to fix the issue: https://rankmath.com/kb/meta-data-not-saving/#firewall

Please also make sure to include the updateMetaBulk route when whitelisting to fix the issue with bulk editing. If you are using WordFence then you can use the following guide: https://rankmath.com/kb/whitelist-rank-math-in-wordfence/

Let us know how that goes. Looking forward to helping you.

Saving meta titles amd description solved.

Database error is not solved.

Hello @johnferz,

Our development team is already working on resolving the issue. We will inform you once it is resolved.

We really appreciate your patience in the meantime.

Please don’t hesitate to get in touch in case you need our assistance with anything else.

Thank you.