Posts

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

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

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.

kiwi