Family 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 'U%' 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 = 'Ů' 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 'U%' 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 = 'Ů' 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 '=']