Search Forums
Forums
Kiwitrees on Twitter
    Tags

    sanity, feedback, missing data, mystyle, calendar, Advanced search, block, chart, 3.0.0. setup, internal messaging, MYSQL, styles, nickname, pending, shared note, session, permissions, 3.0.0, inactive, 3.3.1, performance, Extra menus, help, pages, HTML block, request, title, wish, cookie, timeout, spam, fancy tree view, lists individuals families, beta, datatables, ASSO, census, dates, ID notes, upgrade, individual resource, 3.0.0 widgets, 3.2.1, edit interface, new feature, search, colors theme, emigration, Default record, login failure, Administration, blank screem, contact links, 3.2.2, fact, contact, descendants, hover, fatal error, Fancy imagebar

    Tagged: ,

    Topic:   Find duplicate individuals  

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

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

      550 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

      -----
      Kiwitrees:
      "A-D connections 3.3.1"
      PHP 7.0 Fast CGI

      "The Royals 3.3.1"
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 11.0;  Firefox 56.0
      [updated: 07 Oct 2017]

      #5617
      kiwi
      kiwi
      Keymaster

      1547 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)

    You must be logged in to reply to this topic.