vapili2098
Forum Replies Created
-
Ok, so I updated to Yoast 14.2, disabled and reactivated the plugin and now it worked, finally!
Just one question: is it normal that all my database tables are utf8mb4_unicode_ci, except:
– wp_yoast_indexable
– wp_yoast_indexable_hierarchy
– wp_yoast_migrations
– wp_yoast_primary_term
which are utf8mb4_unicode_520_ci?Why do these 4 tables need a different collation?
WTF? How is the problem solved if you didn’t do anything?
A) Executing the query returns this:
Grants for myuser@localhost GRANT USAGE ON *.* TO 'myuser'@'localhost' GRANT ALL PRIVILEGES ON 'myuser\_wordpress'.* TO 'myuser'@'localhost'B) I confirm.
C) I updated to Yoast SEO 14.1 and resetted Indexables, but nothing has changed, I still get the same error.
D) I have all those tables in my database, and they contain data.
- This reply was modified 5 years, 12 months ago by vapili2098.
- This reply was modified 5 years, 12 months ago by vapili2098.
- This reply was modified 5 years, 12 months ago by vapili2098.
- This reply was modified 5 years, 12 months ago by vapili2098.
- This reply was modified 5 years, 12 months ago by vapili2098.
1) I have all the rights. In fact all those tables you mentioned exist in my database, and they are also populated with data.
2) The server where I?m hosted uses MySQL 5.7.30 and I’m using PHP 7.3.6 and WP 5.4.
3) No, server uses CloudLinux.
4) This is wp-config.php file:
/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);/** The Database Collate type. Don’t change this if in doubt. */
define(‘DB_COLLATE’, ”);This is database collation most tables: utf8mb4_unicode_ci
This is database collation for new tables added by Indexables: utf8mb4_unicode_520_ci- This reply was modified 5 years, 12 months ago by vapili2098.
Ok, so this is what I’ve just tryed again:
– Reset indexables tables & migrations
– Delete wordpress-seo folder in plugins
– Manually upload wordpress-seo latest vession
– Try to enable IndexablesI still get the same error.
UPDATE: I followed the procedure you suggested, but it didn’t work, I still get the error.
- This reply was modified 6 years ago by vapili2098.
I’m going to try what you suggest, but first I’d like to know: is there any risk of losing some settings by doing this operation?