Rikshi Kotian

Okay so I’m new to the coding world and I’m still finding my way around it. I have my own VPS and I’ve tried all the possible methods mentioned and some even has worked for few people. I’m still not able to get Yoast SEO working.

Here are my observations of what’s happening and if can help someone figure out how I can fix it.

1. I uninstalled Yoast SEO
2. I deleted existing Tables via phpMyAdmin for yoast. (It doesn’t get removed when you uninstall it from wp-admin.)
3. I deactivate the Yoast Test Helper plugin as well.
4. I refresh phpMyAdmin and see that I don’t have the yoast entires.
5. I install Yoast SEO plugin.
6. I refresh phpMyAdmin and I don’t see any yoast entires yet.
7. I activate Yoast SEO plugin and I after I refresh phpMyAdmin I can see yoast entries.
8. I re activate the Yoast Test Helper plugin and run the “Reset Indexable tables & Migrations”.

I’m still getting the same error. What am I missing here?

I have also tried editing wp-config.php with
———————————————-
** 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’, ‘utf8mb4_unicode_ci‘);
———————————————-

I have also tried changing collation for “wp_yoast_indexable” to ‘utf8mb4_unicode_ci’ in phpMyAdmin.

———————————————-
———————————————-
EDIT:
I found my fix. Since I have root access to my VPS I accessed my phpMyAdmin (root). And executed following steps.

Open phpMyAdmin (root) -> at Server: localhost
-> User Accounts Tab
-> Edit Privileges of ‘Whatever_Username’
-> Check all available options and save
-> Run the Reset Indexable tables & Migrations” in Yoast Test Helper Plugin and refresh the page
-> Run the Yoast SEO Setup and you should be good to go.
-> reset the Privileges for ‘Whatever_Username’ in phpMyAdmin to original and you should be good to go.

Hope this helps.

• This reply was modified 4 years, 6 months ago by Rikshi Kotian. Reason: Found a fix!

I run a VPS for my websites. Tried all the mentioned methods to fix this particular issue. The only method that sort of works for me was to rollback to v13.5 for now. Will wait for a working update until then.

@twinpictures Sorry for the delayed reply.

I have actually had to reinstall my website completely and am planning to simply use HTML code to Expand & Collapse as it seems it doesn’t interfere with my Theme.

Again, apologies for the delayed reply.

@garc964 do update if your issue is resolved, else I’ll close this thread.

Cheers!