Jump to content
TNG Community
Jürgen Müller

Error when running database upgrade to 12

Recommended Posts

Jürgen Müller

Hello

I updated from 11.0.x to 12.0.2. running the database upgrade from the readme file results in the following error:

SELECT tng_dna_groups.dna_group, tng_dna_groups.description, tng_dna_tests.dna_group FROM tng_dna_groups, tng_dna_tests WHERE tng_dna_groups.dna_group = tng_dna_tests.dna_group

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Additionally, most of the other table upgrades or creates don't work either (see screenshot attached).

Thanks a lot for any hint.

Cheers,

Juergen

Bildschirmfoto 2018-12-05 um 17.07.54.png

Share this post


Link to post
Share on other sites
Ken Roy

Jürgen,

It sounds like your default collation sequence for the database does not match the collation sequence of your other tables.  Go to phpMyAdmin and make sure your tables are all utf8_uniode_ci or all utf8_general_ci  You should be able to update the collation sequences in phpMyAdmin 

Share this post


Link to post
Share on other sites
Jürgen Müller

Hi, Ken

Thanks a lot, that's it. A bit strange, some of the tables had the right collation others not.

Anyway, everything is ok now.

Cheers,

Juergen

 

 

Share this post


Link to post
Share on other sites
Ken Roy

Hi Jürgen,

Glad to help.  I am not sure where you can change the default collation sequence for that database that is used when new tables are created, but that might also need to be update to whatever collation sequence you changed the tables to

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×