Timezone difference in Tasks & Deck?

I’m really enjoying Nextcloud; thanks to the developers and supporters!

Support intro
NextCloudPi version v1.50.1
NextCloudPi image NextCloudPi_08-16-22
OS Debian GNU/Linux 11. 5.10.92-v8+ (aarch64)
automount yes
USB devices sda
datadir /media/NextCloudDrive/ncdata/data
data in SD no
data filesystem btrfs
data disk usage 2.6G/3.7T
rootfs usage 2.6G/29G
swapfile /var/swap
dbdir /media/NextCloudDrive/ncdatabase
Nextcloud check ok
Nextcloud version 24.0.3.2
HTTPD service up
PHP service up
MariaDB service up
Redis service up
HPB service up
Postfix service up
Internet check ok
public IPv4 redacted
public IPv6 not found
Port check 80 closed
Port check 443 closed
IP redacted
gateway redacted
Interface eth0
certificates none
NAT loopback no
Uptime 1:24

Nextcloud version (eg, 20.0.5): 24.0.3.2
Operating system and version (eg, Ubuntu 20.04): Debian GNU/Linux 11. 5.10.92-v8+ (aarch64)
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.54 (Debian)
PHP version (eg, 7.4): pi@nextcloudpi:~ $ php --version PHP 7.4.30 (cli) (built: Jul 7 2022 15:51:43) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.30, Copyright (c), by Zend Technologies

The issue you are facing:

Times in the Tasks modules are incorrect.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Create card in Deck, set date and time to e.g. 2022-10-03 11:30
  2. Open Tasks, time is 4 hours later (i.e. GMT, rather than EDT), e.g. 2022-10-03 15:30

tail of /var/log/apache2/error.log (current time 13:17):

[Sun Oct 02 12:53:59.734754 2022] [authz_host:error] [pid 963:tid 547893137792] [client redacted:50774] AH01753: access check of 'localhost' to /img/favicon.png failed, reason: unable to get the remote host name
[Sun Oct 02 12:54:31.718250 2022] [authz_host:error] [pid 963:tid 547893137792] [client redacted:50774] AH01753: access check of 'localhost' to /img/favicon.png failed, reason: unable to get the remote host name
[Sun Oct 02 13:04:05.415269 2022] [authz_host:error] [pid 963:tid 547951886720] [client redacted:50774] AH01753: access check of 'localhost' to /img/favicon.png failed, reason: unable to get the remote host name
[Sun Oct 02 13:07:46.366780 2022] [authz_host:error] [pid 964:tid 547851174272] [client redacted:39802] AH01753: access check of 'localhost' to /img/favicon.png failed, reason: unable to get the remote host name

tail of /var/log/apache2/nc-error.log (current time 13:16):

[Sun Oct 02 11:26:14.724711 2022] [proxy_fcgi:error] [pid 963:tid 547524432256] [client 10.0.0.13:51058] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery()\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /var/www/nextcloud/lib/private/AppConfig.php(176): OC\\AppConfig->loadConfigValues()\n#7 /var/www/nextcloud/lib/p...'
[Sun Oct 02 11:26:14.726025 2022] [proxy_fcgi:error] [pid 964:tid 547516039552] [client redacted:51060] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery()\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /var/www/nextcloud/lib/private/AppConfig.php(176): OC\\AppConfig->loadConfigValues()\n#7 /var/www/nextcloud/lib/p...'
[Sun Oct 02 11:26:19.732440 2022] [proxy_fcgi:error] [pid 964:tid 547499254144] [client redacted:51070] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery()\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /var/www/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /var/www/nextcloud/lib/private/AppConfig.php(176): OC\\AppConfig->loadConfigValues()\n#7 /var/www/nextcloud/lib/p...'

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

https://gist.github.com/JohnAtl/0d18416b0845937b864621b0e3859a56

Shown here are Tasks on the left, and the Calendar on the right (which is correct, as is the Deck).

Screenshot_20221002_124712
Screenshot_20221002_124652

Did a new server install on Kubuntu 22.04, and seeing the same thing.