Posts

Note: All the issues in this thread relate to MySQL versions 5.7.5 and above with kiwitrees up to 3.3.0. If you don’t use that combination these replacement files are of no benefit.

Nigel:

Not sure if this is a bug or a local problem.

Research Tasks for both Home and Reports throws the attached error. Research Tasks for Widgets simply gives a blank Individual page.

New local install, PHP 7.0.10 / Apache 2.4.23 / MySQL 5.7.14

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy wrote:

Not sure if this is a bug or a local problem.

A bit of both 🙂 The MYSQL function mentioned in the bug report (“sql_mode=only-full-group-by”) became “on by default” from MySQL 5.7.5, which kiwitrees is not fully compatible with. But I am squashing the few minor bugs preventing that compatibility as I find them.

Please replace the file kiwitrees/includes/functions/functions_db.php with the one in the attached zip folder and let me know if it cures this issue.

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

Nigel:

That fixed it in all the Research Task related modules.

Thanks for the quick fix.

Great job!

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Thanks for confirming.

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

Nigel:

Did a quick walk through of 3.3.0 and found 5 Lists modules (shared notes, sources, repositories, families & individual) with what appears to be a common MySQL error. Since the errors are all similar, I only attached one. If you need the others I will email them to you.

One other List module “Calendar Utilities” also doesn’t work but doesn’t throw the error. Shows a line across the page where the content should be.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Thanks Roy. The attached replacement for kiwitrees/includes/functions/functions_print_lists.php should fix three lists: shared notes, sources, repositories. Please confirm.

Please send me the error details for families and individuals.

Regarding the Calendar Utilities, I suspect you haven’t set the selection of utilities you want to display (Administration > Tools > Calendar utilities). I have modified the menu already (for next release) so that it also will not exist until that setting is confirmed.

(Note: if you have never set these before, then on first viewing the admin page they will all show “yes” meaning ‘selected’. But you need to save that page before those are valid settings.)

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

Nigel:

Confirmed; the new file fixed the Lists; shared notes, sources, & repositories.

Attached are the errors for families & individuals.

My bust on the List – Calendar Utilities. It is not something I normally use.

Will continue exploring features I do not routinely use.

Roy

Thanks

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Nigel:

It looks like whatever is wrong with the Lists; families & individuals carries over to the Sidebar; families & individuals.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy wrote:

It looks like whatever is wrong with the Lists; families & individuals carries over to the Sidebar; families & individuals.

Yes, they all use the same database query. Hopefully the attached should fix all four of those (Indi list, fam list, sidebar-families, sidebar-indis).

It replace: kiwitrees/library/WT/Query/Name.php

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

Nigel:

Sorry, but the new file didn’t do the trick. Did clear all the caches before trying it.

Emailed you the resulting two new Sidebar errors. While similar, they seem to be more detailed than the errors from Reports. If you need the Reports error too, just let me know.

Thanks.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8