Viewing 3 posts - 1 through 3 (of 3 total)
Author
Posts
  • #9425

    Nigel:

    Haven’t had time to really work with version 3.3.1. Finally made time and found 2 possible issues; not sure if they are Kiwitrees or my local install. Will make 2 postings.

    The first issue is with Reports/Research Tasks. After opening the report and selecting “Show”, I get the attached error.

    Roy

    Roy

    Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

  • #9430

    This looks like one of the updates to MySQL that we missed previously. Can you try this and confirm if it works.

    In the file kiwitrees\includes\functions\functions_db.php at about line 1200 you should have these two lines:

    $ind_sql = "SELECT DISTINCT d_gid, i_gedcom, 'INDI', d_type, d_day, d_month, d_year, d_fact, d_type FROM <code>##dates</code>, <code>##individuals</code> {$where} AND d_gid = i_id AND d_file=i_file ORDER BY d_julianday1";
    $fam_sql = "SELECT DISTINCT d_gid, f_gedcom, 'FAM',  d_type, d_day, d_month, d_year, d_fact, d_type FROM <code>##dates</code>, <code>##families</code>    {$where} AND d_gid = f_id AND d_file=f_file ORDER BY d_julianday1";

    In both of them remove the end part

    ORDER BY d_julianday1

    , being carefull to leave the closing quote marks in place.

    That should fix the issue, and not cause any problem with the sort order of the report, which should still default to date order in the displayed table.

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

    Nigel:

    That fixed it.

    Thanks.

    Roy

    Roy

    Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

    1 user thanked author for this post.
Viewing 3 posts - 1 through 3 (of 3 total)
  • The topic ‘Reports/Reseach Task’ is closed to new replies.