Individual List

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z | (unknown) | ALL

Show Surname lists

ERROR:-1 DB Error: unknown error
SQL:
SELECT i_id, i_gedcom, i_name, i_letter,i_surname, i_isdead FROM pgv_individuals WHERE (i_letter LIKE 'I%' OR i_letter = 'Í' OR i_letter = 'Ì' OR i_letter = 'Ï' OR i_letter = 'Î' OR i_letter = 'Ĩ' OR i_letter = 'Ī' OR i_letter = 'Ĭ' OR i_letter = 'İ' OR i_letter = 'Į' OR i_letter = 'Ǐ') AND i_file=1 ORDER BY i_name [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']


ERROR:-1 DB Error: unknown error
SQL:
SELECT i_id, i_name, i_file, i_isdead, i_gedcom, i_letter, i_surname, n_letter, n_name, n_surname, n_letter, n_type FROM pgv_individuals, pgv_names WHERE i_id=n_gid AND i_file=n_file AND (n_letter LIKE 'I%' OR n_letter = 'Í' OR n_letter = 'Ì' OR n_letter = 'Ï' OR n_letter = 'Î' OR n_letter = 'Ĩ' OR n_letter = 'Ī' OR n_letter = 'Ĭ' OR n_letter = 'İ' OR n_letter = 'Į' OR n_letter = 'Ǐ')AND n_type!='C' AND i_file=1 ORDER BY i_name [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']