Hello Everyone…I have just started adding Family members into Gedview. I am up to 8 Members.
When I click on the "Lists" Icon, I get the following warnings for sub menu Individuals and Family…..
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'' in C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php:838 Stack trace: #0 : PDOStatement->execute() #1 C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php(838): call_user_func_array(Array, Array) #2 : PGV_DBStatement->__call('execute', Array) #3 C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php(905): PGV_DBStatement->execute() #4 C:\xampp\htdocs\phpgedview\includes\functions\functions_db.php(309): PGV_DBStatement->fetchOneColumn() #5 C:\xampp\htdocs\phpgedview\famlist.php(86): get_indilist_salpha(false, true, 1) #6 {main} thrown in C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php on line 838
Does anyone have a solution?
Regards,
KD……….
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Everyone…I have just started adding Family members into Gedview. I am up to 8 Members.
When I click on the "Lists" Icon, I get the following warnings for sub menu Individuals and Family…..
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'' in C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php:838 Stack trace: #0 : PDOStatement->execute() #1 C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php(838): call_user_func_array(Array, Array) #2 : PGV_DBStatement->__call('execute', Array) #3 C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php(905): PGV_DBStatement->execute() #4 C:\xampp\htdocs\phpgedview\includes\functions\functions_db.php(309): PGV_DBStatement->fetchOneColumn() #5 C:\xampp\htdocs\phpgedview\famlist.php(86): get_indilist_salpha(false, true, 1) #6 {main} thrown in C:\xampp\htdocs\phpgedview\includes\classes\class_pgv_db.php on line 838
Does anyone have a solution?
Regards,
KD……….
In your config.php file, what value do you have for the setting $DB\_UTF8\_COLLATION.
In th config.php file it has the following…
$DB_UTF8_COLLATION=true; //- Use the database to sort/collation UTF8 text
The default for this is false. You presumably changed it.
The help text for this item is explicit. You should not change it after initially creating your database tables.
It is a good setting to use, but for backwards compatibility with existing users, it defaults to false.
Since you have only just started, it might be quickest to delete your database and start again.
Hey Fish….Prob solved….Yes! I started anew and left UTF8 default on "no" and all is well
Thankyou for your help!
KD
If you were to start from fresh with a new/empty database, I would really recommend setting this to true/yes.
You'll get better performance and better ability to search mixed-case words containing accented letters.