Search Forums
Forums
Kiwitrees on Twitter
    Tags

    performance, PHP, family facts, Search and replace, bug reporting, margin, support, backup, media, re-order, individual resource, Require visitor authentication, Default record, My Page, menu, save settings, php 7, logout, tools, spouse, privacy, blank screem, shared note, administration pages, ID notes, charts, tree, menus, Administration, order, 3.3.0, data errors, image, dropbox. token, advanced, widget, missing data, mobile, server, fixing errors, clippings cart, wish, spam, 3.0.0. setup, inactive, footer, cousin tab, multiple marriages, Batch Updates, json, random_media, blocks, webtrees 1.4.4.1, login failure, fancy image bar, pop-ups, release, gettext, folder, special character

    Tagged: ,

    Topic:   Find duplicate individuals  

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

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

      462 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

      1636 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.