Search Forums
Forums
Kiwitrees on Twitter
    Tags

    language, error, surname, multiple marriages, descendants, ASSO, new feature, add, HTML block, link, updates, logout, php 5.6, source, watermark, save settings, dates, family, translate, place, 500, cousins, .po, type, album, Administration, random_media, sanity, 1939 Register, sanity checker, blocks, not married, locked out, editor, MAC, marriages, xenea, blank screem, performance, Georgian, login failure, translation, version, events of close relatives, calendar.php issue, hover, click, permissions, pop-ups, administration pages, contacts, clipboard, validation, edit menu, google, session, living, gettext, menus, reports

    Tagged: ,

    Topic:   Find duplicate individuals  

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

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

      534 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.0 (rev)"
      PHP 5.6.29 Fast CGI

      "The Royals 3.3.0.."
      PHP 7.0 Fast CGI
      mySQL server: 5.1.56
      MacOS: 10.11.6  (El Capitan)
      Browsers (mac): Safari  Version 10.1.1 (11603.2.5);  Firefox 53.0.2
      [updated: 22 May 2017]

      #5617
      kiwi
      kiwi
      Keymaster

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