Posts

Just used Find duplicate individuals and came across problem. Surname: D’ESTE — perhaps the apostrophe as the other surnames I used were okay.

ERROR:
atal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ESTE%’ AND n_givn LIKE ‘%%’ AND n_type NOT LIKE ‘_MARNM’AND n_file = 2 AND n_fu’ at line 2′ in /home/user/royalty.woodengems.com/library/WT/DBStatement.php:91 Stack trace: #0 [internal function]: PDOStatement->execute() #1
/home/user/royalty.woodengems.com/library/WT/DBStatement.php(91): call_user_func_array(Array, Array) #2 /home/user/royalty.woodengems.com/library/WT/DBStatement.php(103): WT_DBStatement->__call(‘execute’, Array) #3 /home/user/royalty.woodengems.com/library/WT/DBStatement.php(103): WT_DBStatement->execute() #4 /home/user/royalty.woodengems.com/admin_trees_duplicates.php(211): WT_DBStatement->__call(‘fetchAll’, Array) #5 /home/user/royalty.woodengems.com/admin_trees_duplicates.php(211): WT_DBStatement->fetchAll(2) #6 {main} thrown in /home/user/royalty.woodengems.com/library/WT/DBStatement.php on line 91

----- [updated: 31Dec2022] MacOS: 10.15.7  (Catalina) Safari   14.1.2;  Firefox 108.0.1 (64-bit);  108.0.1462.54 (Official build) (x86_64)

Alter-Drukarsh connections | The Garelick: 3.3.11b - PHP 8.0 FastCGI - mySQL 8.

I have fixed this. It will be included in the next release (in a few days).

Nigel
My personal kiwitrees site is www.our-families.info