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 'O%' 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 'O%' 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 '=']