Search
Forums
Topic Information
ForumBug reporting
Authorpab
Last activity2 years, 2 months ago
StatusOpen
Replies4
Voices2
Participantspab, kiwi
Actions
Tags

Export/Import, 1939 Register, button, multiple marriages, mystyle, advent, shared note, 3.0.0, timeout, error, Require visitor authentication, add, danish, data errors, GEDCOM, 2.0, resources, gettext, marriage, immigration, language, blank screem, watermark, ID notes, abbreviate, session, bug sql error, stories, dates, administration pages, 3.3.1, sitemap, .mo, age, I18N, Add a wife, flags, advanced, notes, Google Maps, special character, FAQ, re-order, menus, dropbox. token, family, follow, access level, 3.0.0 widgets, custom, latest, server, privacy, reports, living, upload, configure, fixing errors, webtrees 1.4.4.1, lists

Kiwitrees on Twitter

    Topic:   Advanced Search   [In progress]

    Viewing 5 posts - 1 through 5 (of 5 total)
    • Author
      Posts
    • #9143
      pabpab
      Participant

      176 posts

      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
      kiwikiwi
      Keymaster

      1849 posts

      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
      kiwikiwi
      Keymaster

      1849 posts

      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
      Attachments:
      #9229
      pabpab
      Participant

      176 posts

      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
      kiwikiwi
      Keymaster

      1849 posts

      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)
    • You must be logged in to reply to this topic.