Reply

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