- This topic has 4 replies, 2 voices, and was last updated 5 years, 8 months ago by
.
- This topic has prefixes assigned
-
I was trying an advanced search:
First Name: Harriet
Born: 1865
Died: after 1939
Place: Kentit 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
-
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 -
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 -
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. -
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
- The topic ‘Advanced Search’ is closed to new replies.