Search
Forums
Kiwitrees on Twitter
    Tags

    lists individuals families, roadmap, abbreviate, FAQ, 3.1, 3.3.0, library, contact links, save settings, road map, 3.1.1, menu, logs, design, sanity checker, cousin tab, BAPM, set link, edit, NCHI, mystyle, translate, emmigration, Php 7.1, updates, living, notes, menus, Support/Bug Reporting, husband, Search and replace, blocks, immigration, GDBR, close, REFN, new feature, colors, message contactform, inactive, tags, errors, follow, lists, simpl_pages, shared note, 3.3.1, title, order, duplicates, HTML variables, marriage, not married, 3.0.0. setup, fact, theme, edit menu, family fact, .po, 3.0.0 widgets

    Tagged: ,

    Topic:   Find duplicate individuals  

    This topic contains 1 reply, has 2 voices, and was last updated by kiwi kiwi 2 years, 9 months ago.

    Viewing 2 posts - 1 through 2 (of 2 total)
    • Author
      Posts
    • #5614
      macalter
      macalter
      Participant

      466 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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #5617
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
    Viewing 2 posts - 1 through 2 (of 2 total)

    The topic ‘Find duplicate individuals’ is closed to new replies.