Sqlite3Driver.php offset error after update to php7.4-sqlite3 package -> Organizr home page doesn't load

[guydavis]

Version of dibi/dibi: Both 3.1 and then tried 4.1.2 - same result.

WebServer: Nginx + PHP 7.4.4-1+ubuntu16.04.1+deb.sury.org+1

Operating System: Ubuntu 16.04

Bug Description

Existing Organizr install was working well, until I applied recently updates which included php7.4 updates such as php7.4-sqlite3. After restarting the next day, I am no longer to login into Organizr which was working fine. The login succeeds , but never returns Organizr homepage. It just times out spinning as shown.

/var/log/nginx/error.log shows this error however:

2020/03/25 10:15:43 [error] 1137#1137: *1359 FastCGI sent in stderr: "fset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452PHP message: PHP Notice:  Undefined offset: 0 in /opt/organizr/html/api/vendor/dibi/dibi/src/Dibi/Drivers/Sqlite3Driver.php on line 452" while reading response header from upstream, client: 192.168.1.1, server: my.server.com, request: "POST /api/?v1/login HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "my.server.com", referrer: "https://my.server.com/"

/var/log/apt/history.log last update

Start-Date: 2020-03-02  09:01:44
Commandline: apt-get upgrade
Requested-By: davis (1000)
Upgrade: php7.4-cli:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), containerd.io:amd64 (1.2.10-3, 1.2.12-1), php7.1-xml:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php7.1-mbstring:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php7.1-readline:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), uuid-runtime:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.1-zip:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), libfdisk1:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.1-mysql:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php-xml:amd64 (2:7.4+72+ubuntu16.04.1+deb.sury.org+1, 2:7.4+73+ubuntu16.04.1+deb.sury.org+1), php7.4-fpm:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), php7.3-readline:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), php-zip:amd64 (2:7.4+72+ubuntu16.04.1+deb.sury.org+1, 2:7.4+73+ubuntu16.04.1+deb.sury.org+1), php-common:amd64 (2:72+ubuntu16.04.1+deb.sury.org+1, 2:73+ubuntu16.04.1+deb.sury.org+1), php7.4-json:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), libmount1:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.4-curl:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), libarchive13:amd64 (3.1.2-11ubuntu0.16.04.7, 3.1.2-11ubuntu0.16.04.8), php7.3:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), php7.3-json:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), util-linux:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.1-sqlite3:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php-sqlite3:amd64 (2:7.4+72+ubuntu16.04.1+deb.sury.org+1, 2:7.4+73+ubuntu16.04.1+deb.sury.org+1), php7.4-sqlite3:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), php7.1-opcache:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php7.1-json:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php7.3-common:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), php7.4-opcache:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), mount:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.4-xml:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), libblkid1:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.1-curl:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php7.3-opcache:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), php-curl:amd64 (2:7.4+72+ubuntu16.04.1+deb.sury.org+1, 2:7.4+73+ubuntu16.04.1+deb.sury.org+1), php7.4-zip:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), php7.3-cli:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), dmidecode:amd64 (3.0-2ubuntu0.1, 3.0-2ubuntu0.2), php7.1-cli:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), libuuid1:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.3-fpm:amd64 (7.3.14-1+ubuntu16.04.1+deb.sury.org+1, 7.3.15-3+ubuntu16.04.1+deb.sury.org+1), php7.4-readline:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), php7.1-fpm:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), libsmartcols1:amd64 (2.27.1-6ubuntu3.9, 2.27.1-6ubuntu3.10), php7.1-common:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), php-fpm:amd64 (2:7.4+72+ubuntu16.04.1+deb.sury.org+1, 2:7.4+73+ubuntu16.04.1+deb.sury.org+1), bsdutils:amd64 (1:2.27.1-6ubuntu3.9, 1:2.27.1-6ubuntu3.10), unattended-upgrades:amd64 (1.1ubuntu1.18.04.7~16.04.5, 1.1ubuntu1.18.04.7~16.04.6), php7.4-common:amd64 (7.4.2-1+ubuntu16.04.1+deb.sury.org+2, 7.4.3-4+ubuntu16.04.1+deb.sury.org+1), php7.1-mcrypt:amd64 (7.1.33-4+ubuntu16.04.1+deb.sury.org+1, 7.1.33-12+ubuntu16.04.1+deb.sury.org+1), docker-ce:amd64 (5:19.03.5~3-0~ubuntu-xenial, 5:19.03.6~3-0~ubuntu-xenial), docker-ce-cli:amd64 (5:19.03.5~3-0~ubuntu-xenial, 5:19.03.6~3-0~ubuntu-xenial)
End-Date: 2020-03-02  09:08:01

Also, tried upgrading dibi/dibi to 4.1 version as described in this other defect, but problem remains. Any help is greatly appreciated!

[dg]

It seems that PHP 7.4.4 is broken, try to downgrade to PHP 7.4.3 or update to dibi 4.1.3.

(probably related to https://bugs.php.net/bug.php?id=79294)

[guydavis]

Awesome! I tried with dibi 4.1.2 this afternoon without luck, but your 4.1.3 release does the trick! No more error as recorded above. Thanks so much for the quick fix in this release!