[Phpgedview-talk] ERROR:-1 DB Error: unknown error

[Eric D'M. <Er...@de...>]

Hello Everybody,

 

I recently decided to reinstall PGV 4.2.1 (I had 4.2.0 working properly)
from the very beginning. I wanted to use UTF-8 collation in order to speed
up the database.

 

Everything in the new installation seems to be working properly except for
when I go to the individual of family listings I receive the following error
message:

 

ERROR:-1 DB Error: unknown error

SQL:SELECT SUBSTR(n_sort COLLATE utf8_unicode_ci, 1, 1) AS alpha FROM
pgv_name, pgv_individuals WHERE n_file=1 AND i_file=n_file AND i_id=n_id
GROUP BY 1 ORDER BY 1 [nativecode=1253 ** COLLATION 'utf8_unicode_ci' is not
valid for CHARACTER SET 'latin1']

Fatal error: Call to undefined method DB_Error::fetchRow() in
/homepages/29/d134879407/htdocs/deMellow_name/phpGedView/includes/functions/
functions_db.php on line 529

 

I believe it has something to do with the character set "latin1"!

 

Does anybody have an Idea on how to solve my problem? Thank you! 

 

I'm using:

 

PGV 4.2.1

PHP Version 5.2.9

MySQL 5.0.67

 

Regards

 

Eric