#2285 [4032] Advanced search

v4.1.5
open
nobody
None
5
2008-11-17
2008-10-09
Mark Hattam
No

Just tried this ...

1. The "Add More Fields" adds a new table row, which if clicked on shows a very tall thin pop-up type menu, with apparently nothing in it. If there is anything in it, it's too narrow to see even the first letter.

2. I searched for a year (1954) using "Marriage Date", and the SQL query took nearly three minutes on an otherwise idle machine (2.4 GHz Core2Duo).

# Time: 081009 1:32:04
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 170 Lock_time: 0 Rows_sent: 10 Rows_examined: 2710548
SELECT i_id, i_gedcom, i_name, i_isdead, i_file FROM pgv_individuals, pgv_families as FAMS WHERE i_file=1 AND i_file=FAMS.f_file AND (FAMS.f_husb=i_id OR FAMS.f_wife=i_id) AND ROW(FAMS.f_id, FAMS.f_file) IN (SELECT DISTINCT f_id, f_file FROM pgv_families, pgv_dates WHERE f_file=1 AND f_file=d_file AND f_id=d_gid AND (d_fact='MARR' AND d_julianday1>=2434744 AND d_julianday2<=2435108) );

And got back 5 individuals (with a further 5 hidden) ... I might have thought I'd get back a "Family" table rather than an "individual" table as I searched for a "marriage date".

3. If I search for a known couple (with their full names), I get back a table of their children.
But if I search for that same couple and put in their marriage date (even just the year), I get nothing back. Similarly if I put in their marriage place, I get no results.

Mark

Discussion

  • kiwi_pgv
    kiwi_pgv
    2008-10-09

    Mark - see my previous bug for item 1. It appears to be an IE browser issue. Works OK for me in FF3, but not IE7. John is working on it.

     
  • Mark Hattam
    Mark Hattam
    2008-10-09

    Yes, item 1. works OK in Safari, Chrome and FireFox3 ... but not IE7.

     
  • Greg Roach
    Greg Roach
    2008-11-17

    • milestone: --> v4.1.5