• This topic has prefixes assigned
Viewing 10 posts - 1 through 10 (of 39 total)
Author
Posts
  • #8408
    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

  • #8417

    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
  • #8426

    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

  • #8427

    Thanks for confirming.

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

    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

  • #8441

    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
  • #8452

    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

  • #8456

    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

  • #8460

    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
  • #8466

    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

Viewing 10 posts - 1 through 10 (of 39 total)
  • The topic ‘MySQL 5.7+ issues’ is closed to new replies.