An error has occurred in the TNG software. What to do:<p>If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step.</p><p>If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step.</p><p>If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message.</p><br /><br />Query: SELECT u.username AS User_Name, u.description AS User_Description, p.personID AS PersonID, u.personID AS UserPersonID, DATE(u.lastlogin) AS User_Last_Login, b.gedcom AS Tree, CONCAT('',b.branch,'') AS Branch_ID, b.description AS Branch_Name, b.personID AS StartPersonID, CASE WHEN p.sex = 'F' THEN CONCAT('',w.wife,'') ELSE CONCAT('',h.husband,'') END AS familyID, CASE WHEN Count(bl.branch) > 0 THEN CONCAT('Yes',' - ',Count(bl.branch),' records') ELSE 'No' END AS inbranchLinks FROM tng_branches AS b LEFT JOIN tng_users AS u ON b.branch = u.branch AND b.gedcom = u.gedcom LEFT JOIN tng_people AS p ON b.personID = p.personID AND b.gedcom = p.gedcom LEFT JOIN tng_families AS h ON p.personID = h.husband AND p.gedcom = h.gedcom LEFT JOIN tng_families AS w ON p.personID = w.wife AND p.gedcom = w.gedcom LEFT JOIN tng_branchlinks AS bl ON b.branch = bl.branch AND b.gedcom = bl.gedcom WHERE u.lastlogin >= '2009-05-17 00:00:00' GROUP BY u.username, u.description, u.lastlogin, b.gedcom, u.personID, b.branch, b.description, b.personID, p.personID, w.wife, h.husband ORDER BY b.description LIMIT 1000<br /><br />Illegal mix of collations (utf8mb4_general_nopad_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='