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

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




Print
Back to normal view