I have received a report of an issue that causes the display of statistics (Charts > Statistics) to fail (‘Individuals’ tab only) if using MySQL for a database. This is only in the 3.3.9 version of kiwitrees. The fault causes all outputs on the first tab, from the first pie chart, to fail.
In your server logs (not the kiwitrees admin logs) you will see errors like this (plus more related lines):
[Thu…### Apr 08 11:33:24 2021] [error] [client xxx.xxx.xxx.xxx]
FastCGI: server “/usr/local/apache/cgi-bin/php7-fcgi72”
stderr: PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]:
Syntax error or access violation: 1139 Got error ‘repetition-operator operand invalid’
from regexp in /home/zz/zz/zzzzzzzzzz/zzzzzz/library/KT/DBStatement.php:87
The cause is using a piece of MariaDB-specific code that does not work on MySQL servers.
Attached is a zip folder containing the fixed file, which replaces kiwitrees\library\KT\Stats.php