phpgedview 4.3.1, Mysql 8, php 7.4 Raspberry Pi4 64bit/8Gb, Ubuntu 20.04 arm64.

[Hand-Crafted Software]

Hi

I have moved my current software from a hosted cloud to a raspberry pi. I did not realise there was a SVN and so hacked around (not a PHP programmer) until I got 4.3.0 working. Then installed 4.3.1 but there were still some problems with the queries and also with PDF.

I did not keep details of all the errors however I ended up :
1. replacing the tcpdf directory with a new download from https://tcpdf.org/. The error related to a chr() value not been set correctly. After installing the new tcpdf directory, this error disappeared.
2. resolving the issue of MYSQL reporting "Error Code: 3065. Expression #1 of ORDER BY clause is not in SELECT list". I changed all the select statements which had and "ORDER BY" clause in includes\functions\functions_db.php to include the order by variable.

It looks like 4.3.1 had fixed most other problems I had found, so thanks.

Not sure if this is helpful. I'm not a php programmer so I am not sure if there are better ways of fixing the problems I encountered or if these are known issues. I've done some testing and all looks quite good and its pretty quick. Happy to provide details of the changes and/or instructions for installing phpgedview on a Pi if they are of any benefit.

Cheers !
Greg

[Gerry Kroll]

I'm glad that you were able to resolve most of your problems by installing the latest-and-greatest 4.3.1 downloaded as an SVN snapshot.

It would be helpful (actually, necessary) to keep track of all unresolved problems, and how to recreate them. Without this information, it's impossible to fix the errors.

I won't replace the existing TCPDF package until I have more information. "It works for me."

[Arnold Schiller]

Ok my experience with 7.3 - I replaced tcpdf, in the whole SOAP folder I removed the =& with sed -i s/ =&/ =/g *.php - then I set the version query which is limited to version 5 to 7 and replaced all time("U") with date("U").