Errors when using "Search" (on home page, advanced search ok)

[pms967]

Whenever anyone use the “Search for” function in the DocDB home page, the following error messages appear on my logs:

AH01215: DBD::mysql::st execute failed: Illegal argument to a regular expression. at /var/www/docdb/cgi.pro/Search.pm line 287.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

AH01215: DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /var/www/docdb/cgi.pro/Search.pm line 288.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

AH01215: DBD::mysql::st fetch failed: fetch() without execute() at /var/www/docdb/cgi.pro/Search.pm line 292.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

AH01215: DBD::mysql::st execute failed: Illegal argument to a regular expression. at /var/www/docdb/cgi.pro/Search.pm line 380.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

AH01215: DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first, or again) at /var/www/docdb/cgi.pro/Search.pm line 381.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

AH01215: DBD::mysql::st fetch failed: fetch() without execute() at /var/www/docdb/cgi.pro/Search.pm line 385.: /var/www/docdb/cgi/Search, referer: /ddbcgi/DocumentDatabase

--
Moreover, some search terms produces no results (although they are present in several documents).

Can anyone help me debug this problem? Thanks.

DocDB is ~= 8.8.8 (with a few fix), running on Apache. Base system is Ubuntu 22.04 LTS (Apache, Perl, MySQL, etc all defaults from system deb packages).

[pms967]

Update: the problem remains exactly the same after upgrading to DocDB 8.8.9

(again with some fixes to deal with the newer versions of Perl (5.34) and related libraries... but evidently some more fixes are needed).

[pms967]

Fixed (on my copy), see Issue #114