• This topic has 4 replies, 2 voices, and was last updated 4 years ago by kiwikiwi.
  • This topic has prefixes assigned
Viewing 5 posts - 1 through 5 (of 5 total)
Author
Posts
  • #9143

    I was trying an advanced search:

    First Name: Harriet
    Born: 1865
    Died: after 1939
    Place: Kent

    it crashed out with:

    Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 5 in /home/bootesgowland/public_html/kiwitrees/library/WT/DBStatement.php:87 Stack trace: #0 /home/bootesgowland/public_html/kiwitrees/library/WT/DBStatement.php(87): PDOStatement->execute(Array) #1 /home/bootesgowland/public_html/kiwitrees/library/WT/Controller/Search.php(1106): WT_DBStatement->__call(‘execute’, Array) #2 /home/bootesgowland/public_html/kiwitrees/library/WT/Controller/Search.php(213): WT_Controller_Search->AdvancedSearch() #3 /home/bootesgowland/public_html/kiwitrees/search.php(28): WT_Controller_Search->__construct() #4 {main} thrown in /home/bootesgowland/public_html/kiwitrees/library/WT/DBStatement.php on line 87

    Fatal error: Uncaught Error: Call to a member function getClientIp() on null in /home/bootesgowland/public_html/kiwitrees/includes/session.php:366 Stack trace: #0 [internal function]: {closure}(‘9ev6pqle19saj5u…’, ‘KIWITREES|a:10:…’) #1 {main} thrown in /home/bootesgowland/public_html/kiwitrees/includes/session.php on line 366

    Penguins Are  Boss

    https://bootesgowland.kiwitrees.net

    Happy to be hosted by kiwitrees.net

  • #9144

    Yes, I see what you mean. It doesn’t like 2 dates with only one place. In the most complex database query in the system 🙁

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

    In my testing, the attached file seems to fix the issue. But can you test it for me? There are many different combinations for an advanced search, so I might still have missed something. I’ll leave the bug _in progress” until (if) you confirm its OK.

    The file replaces kiwitrees/library/WT/Controller/Search.php

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

    Same result. I would put this very low priority unless anyone else is bothered by it.

    Such a search is unlikely to be done again – I used a different way to find the person I was looking for.
    With the replacement file I also tried the same search adding place of birth as England. It did not crash. Did not find any individuals and did not say there were no matches.

    Penguins Are  Boss

    https://bootesgowland.kiwitrees.net

    Happy to be hosted by kiwitrees.net

  • #9230

    It did not crash. Did not find any individuals and did not say there were no matches.

    Check your logs (in kiwitrees admin). If there’s no result there should be something there. It might help.

    Nigel
    My personal kiwitrees site is www.our-families.info
Viewing 5 posts - 1 through 5 (of 5 total)
  • The topic ‘Advanced Search’ is closed to new replies.