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 tng_albumplinks.alinkID, tng_albumplinks.entityID as personID, people.living as living, people.private as private, people.branch as branch, tng_albumplinks.eventID,
		tng_albumplinks.linktype, people.title, people.birthdate, people.birthdatetr, people.altbirthdate, people.altbirthdatetr, people.deathdate, people.deathdatetr, husbpeople.title as htitle, wifepeople.title as wtitle,
		tng_families.branch as fbranch, tng_families.living as fliving, tng_families.private as fprivate, people.lastname as lastname, people.lnprefix as lnprefix, people.firstname as firstname, people.prefix as prefix, people.suffix as suffix, people.nameorder, tng_albumplinks.gedcom,
		familyID, people.personID as personID2, wifepeople.personID as wife, wifepeople.firstname as wfirstname, wifepeople.lnprefix as wlnprefix, wifepeople.lastname as wlastname,
		wifepeople.prefix as wprefix, wifepeople.suffix as wsuffix, husbpeople.personID as husband, husbpeople.firstname as hfirstname, husbpeople.lnprefix as hlnprefix, husbpeople.lastname as hlastname,
		husbpeople.prefix as hprefix, husbpeople.suffix as hsuffix, tng_sources.title as stitle, tng_sources.sourceID, tng_repositories.repoID, reponame
		FROM tng_albumplinks
		LEFT JOIN tng_people AS people ON tng_albumplinks.entityID = people.personID AND tng_albumplinks.gedcom = people.gedcom
		LEFT JOIN tng_families ON tng_albumplinks.entityID = tng_families.familyID AND tng_albumplinks.gedcom = tng_families.gedcom
		LEFT JOIN tng_people AS husbpeople ON tng_families.husband = husbpeople.personID AND tng_families.gedcom = husbpeople.gedcom
		LEFT JOIN tng_people AS wifepeople ON tng_families.wife = wifepeople.personID AND tng_families.gedcom = wifepeople.gedcom
		LEFT JOIN tng_sources ON tng_albumplinks.entityID = tng_sources.sourceID AND tng_albumplinks.gedcom = tng_sources.gedcom
		LEFT JOIN tng_repositories ON (tng_albumplinks.entityID = tng_repositories.repoID AND tng_albumplinks.gedcom = tng_repositories.gedcom)
		WHERE albumID = "1" ORDER BY people.lastname, people.lnprefix, people.firstname, hlastname, hlnprefix, hfirstname  LIMIT 51<br /><br />Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='