Re: [Phpgedview-talk] ERROR:-1 DB Error: unknown error
Brought to you by:
canajun2eh,
yalnifj
From: Mario G. <mar...@ti...> - 2009-04-22 15:47:33
|
Il 22/04/2009 11.24, Eric D'Mellow ha avuto l'onore e l'ardire di scrivere: > Hello Everybody, Hello Eric and everybody, This is my first post here. I'm an italian young man and I write english a little... I'm sorry for mistakes on my english!! > > 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'] > I fix the trouble wrote by Eric some days ago, when I try to reinstall my PhpGedView site. I set true the variable $DB_UTF8_COLLATION on config.php. I fix setting $DB_UTF8_COLLATION=false I hope this will resolve yuor truoble. Best regards, Mario -- MARIO GOLFETTO mariogolf[DOT]web[AT]tiscali[DOT]it |