Posts

Bingo!

You got it. All the Sanity stuff works perfectly.

As for switching to MariaDB. Considered it several times since they branched off. Each time, there were issues that have since, apparently, been dealt with. My personal life (old age) may now be the deciding factor but will give it some thought.

Many of these MySQL errors are irrelevant to my work. Will you switch your followers at some point?

Personally, I think you should package client Kiwitrees stacks (Lamp, Wamp, and/or Xamp) and sell it!

Thanks for the great job.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy wrote:

Many of these MySQL errors are irrelevant to my work. Will you switch your followers at some point?

I prefer not to enforce MariaDB over MySQL if I can avoid it. But it will depend how far they diverge. If it gets too much effort to maintain compatibility with both, then perhaps I will have to.

Xampp now only ships with MariaDB though. If WAMPP and LAMP etc decide to do the same, then it might cease being an issue as the majority will move anyway.

Then there are also continual questions about how long Oracle will continue to maintain MySQL (as open source) as well as their own OracleDB. I understand they contracted to keep MySQL maintained until 2014 when they purchased it, but that’s well past now.

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

Nigel:

Your fix for “Top Surnames” did the job.

Thanks
Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy, do you feel we can confidently describe the next version of kiwitrees as “compatible with mysql 5.7+” ?

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

Nigel:

With the exception of the Sidebar Family & Individual lists, I can recommend certification for MySQL 5.7.14. Those 2 Sidebar lists still throw errors, see attached.

Have not tested Backup to Drop Box, the U.K. related reports, append family tree and renumber family tree tools, plus the custom languages stuff.

I have found another non SQL-related bug which I will post shortly.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Nigel:

The Stories module works ok as a Menu item but except for the header stuff gives a mostly blank Individual page when the Tab item is not hidden for all.

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy wrote:

With the exception of the Sidebar Family & Individual lists, I can recommend certification for MySQL 5.7.14. Those 2 Sidebar lists still throw errors, see attached.

Try the attached replacement for kiwitrees/library/WT/Query/Name.php.

Roy wrote:

Have not tested Backup to Drop Box, the U.K. related reports, append family tree and renumber family tree tools, plus the custom languages stuff.

OK, I can test those ones, but I’m 99% confident they don’t use the functions causing this issue.

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

Roy, is there an error message related to this problem? If not, a screen dump to show exactly what “a mostly blank Individual page” looks like.

So far I’m not able to recreate it.

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

Nigel:

Just sat down to my computer when you were posting. Immediately tried the new Name file and it worked perfectly!

I agree about the remaining untested item and think you are safe certifying for MySQL 5.7.14.

Another thing, I do not know why but I am not seeing the “function getClientIp()” error anymore. I could always force it with the Sidebar error and that is not happening either.

Thanks for a great job!

Roy

Roy

Apache 2.4.27  PHP 7.19 MariaDB 10.2.8

Roy wrote:

Another thing, I do not know why but I am not seeing the “function getClientIp()” error anymore. I could always force it with the Sidebar error and that is not happening either.

I think that confirms my suspicion – that error was coming from search engines that had cached an old copy of something. They have now caught up with later code. Thanks for the confirmation though. A great relief.

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