Jump to content
TNG Community
KevyNC

SOSA mod -- Table Created but Collation error [Update]

Recommended Posts

KevyNC

Hi.  I have never used this MOD before discovered when I was doing a fresh install of 13.1.2.

I have total of 20 mods. The SOSA has been created but NO first got no rows are in the table.  Not if I missed an option.

Now after using Designate  -- the table appears to be created correctly but I get collation error.

SELECT sosa, tree, tng_sosa.personID, implex, lnprefix, lastname, firstname, living, private from tng_sosa LEFT JOIN tng_people ON tng_people.personID = tng_sosa.personID AND tng_people.gedcom = tng_sosa.tree WHERE tng_people.gedcom = '7' ORDER BY tree, CAST(sosa as unsigned) :

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

 

ps. @Michel KIRSCH  not sure if you can help

Share this post


Link to post
Share on other sites
KevyNC

I think I am missing where to set SOSA #1 / home person?

I manually added a row to the SOSA table - but only worked for SOSA #1. 

still missing something or something is preventing from rows  being added to the table.

also get this error when I manually add the row 

SELECT sosa, tree, tng_sosa.personID, implex, lnprefix, lastname, firstname, living, private from tng_sosa LEFT JOIN tng_people ON tng_people.personID = tng_sosa.personID AND tng_people.gedcom = tng_sosa.tree WHERE tng_people.gedcom = '7' ORDER BY tree, CAST(sosa as unsigned) :

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

Kevin

Share this post


Link to post
Share on other sites
Rob Severijns

Kevin,

When at the individuals page you can set the person as Sosa 1

See picture below.

2022-11-24 (1).png

If that menu option doesn't exist something might have gone wrong during install.

There are a few warnings on the wiki page regarding the sequense of installing this mod.

You may also want to check te Sosa parameters in Setup .. Configuration.

Rob

Share this post


Link to post
Share on other sites
KevyNC

Thanks Rob. Might need to change the database collation or the mod's getting this:

Not sure how to fix the collation error

 

"SELECT sosa, tree, tng_sosa.personID, implex, lnprefix, lastname, firstname, living, private from tng_sosa LEFT JOIN tng_people ON tng_people.personID = tng_sosa.personID AND tng_people.gedcom = tng_sosa.tree WHERE tng_people.gedcom = '7' ORDER BY tree, CAST(sosa as unsigned) :

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

Share this post


Link to post
Share on other sites
Michel KIRSCH

you have to work in your phpMyAdmin program.

Select your database, then "operations" tab

at the end of the page, in 'interclassement",

- choose the utf8_general_ci collation in the list,

- check the box "apply to all tables"

- then execute

interclassement.JPG

Share this post


Link to post
Share on other sites
Michel KIRSCH

Kevyn,

I sent you a personnal message with a solution, thanks to Brent

Michel

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

×