nhowarth

Removing Yoast SEO & re-installing it did the trick ??

I don’t know how my database got in this mess. There are still 37 tables with Collation ‘latin1_swedish_ci’ – plus a further 19 tables with Collation ‘utf8_bin’.

Now everything seems to be running normally, I’ll leave it for a few days and work my way through the other latin1s.

Thanks again
Nigel

I’ve made some progress and I think I’m on the right track. I’ve changed the COLLATion in the following tables to utf8:

wp_commentmeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_terms
wp_termmeta
wp_term_relationships
wp_term_taxonomy

and can now login – and the site is looking fine. I can edit and publish posts BUT when I create and try to save a draft of a new post it causes an error in the Yoast SEO plugin.

I’ll progress this over the next few days/weeks when I get the time.

Thanks for your help bcworkz

Regards
Nigel

That was partly successful. I could read my posts and they all looked OK but I couldn’t log into the WP dashboard (it took my to my home page.) And the home page layout was screwed up.

I may have cracked it. I used ‘utf8’ rather than ‘utf8mb4_unicode_ci’.

Created a new database and imported the export from the live database. The tables were shown with COLLATION utf8_general_ci.

I’ll try this on my live database & keep you posted.

Unfortunately bcworkz it failed. When I tried to import the tables, phpMyAdmin reported:

#1115 – Unknown character set ‘utf8mb4_unicode_ci’

Thanks bcworkz – let’s hope it works.

Regards

Nigel

Thanks for getting back to me – I’ve checked the database and the collation is ‘utf8mb4_unicode_ci’.

But the tables in the actual database, which are all MyISAM, have a two collations: ‘utf8_general_ci’ (with a charset ‘utf8’) and ‘latin1_swedish_ci’ (with a charset ‘latin1’.) Could this be the problem?

Regards
Nigel

• This reply was modified 5 years, 3 months ago by nhowarth.

Many thanks Lester

All is now OK

Regards,

Many thanks Frank

The problem was linked to a mobile theme plugin. I’ve disabled the plugin and switched to using Jetpack’s mobile theme.

I found the one that’s causing the problem, but I have no problems with it since last updating it over a month ago?

The error only appears when I go to Appearance ->Customize and select Additional CSS.

I’ve disabled all plugins with the exception of Jetpack and the problem goes away. I’ll find out which one’s causing the problem.

Thanks for your help.

Thanks, the latest release 2.5.2 solves my problem.

• This reply was modified 5 years, 6 months ago by nhowarth.

In my case version 2.4.7 doesn’t solve the problem – but as soon as I deactivate Yoast SEO, versions 2.4.7 AND the latest version 2.5.1 work fine.

Same here again using the classic editor.