Nextcloud version: 18.04
Operating system and version: Debian 4.19.98-1+deb10u1 (2020-04-27) x86_64 GNU/Linux
Nginx version: 1.17.10-1~buster
PHP version: PHP 7.4.5 (cli) (built: Apr 19 2020 08:43:53) ( NTS )
The issue you are facing:
Lots and lots (hundreds) of warnings and errors in nextcloud log.
Is this the first time you’ve seen this error? Yes
Steps to replicate it:
- Install Latest Debian (in VM)
- Install Nextcloud
- Start Nextcloud/Nginx and setup plugins
The output of your Nextcloud log in Admin > Logging: Hundreds of below errors:
Error PHP count(): Parameter must be an array or an object that implements Countable at /var/www/nextcloud/3rdparty/sabre/dav/lib/DAVACL/Plugin.php#1403
Error PHP The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence at /var/www/nextcloud/3rdparty/sabre/vobject/lib/Recur/RRuleIterator.php#423
Error PHP Trying to access array offset on value of type null at /var/www/nextcloud/3rdparty/leafo/scssphp/src/Compiler.php#5230
Error index OCP\Files\NotFoundException: /appdata_ocz4qm4o2deg/documentserver_community/doc_399450580/Editor.bin
Error mail OCA\Mail\Exception\ServiceException: Sync failed for 1:Junk: An exception occurred while executing 'INSERT INTO `oc_mail_messages` (`uid`, `message_id`, `mailbox_id`, `subject`, `sent_at`, `flag_answered`, `flag_deleted`, `flag_draft`, `flag_flagged`, `flag_seen`, `flag_forwarded`, `flag_junk`, `flag_notjunk`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [20857, "<LYRIS-9211913-1116752-2011.11.30-16.00.06--donald#flissinger.com@dbaseserver.mistermail.nl>", 8, "\x4a\x75\x62\x69\x6c\x65\x75\x6d\x76\x6f\x6f\x72\x64\x65\x65\x6c\x3a\x20\x45\x65\x6e\x20\x6a\x61\x61\x72\x20\x6c\x61\x6e\x67\x20\x45\x6c\x65\x6b\x74\x6f\x72\x20\x76\x6f\x6f\x72\x20\x6d\x61\x61\x72\x20\x80\x20\x35\x30\x2c\x30\x30", 1322665538, false, false, false, false, true, false, false, false]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\x80 50,0...' for column `nextcloud`.`oc_mail_messages`.`subject` at row 1
The output of your config.php file in /var/www/nextcloud/config/config.php:
<?php
$CONFIG = array (
'instanceid' => 'ocz4qm4o2deg',
'passwordsalt' => 'masked',
'secret' => 'masked',
'trusted_domains' =>
array (
0 => 'cloud.flissinger.com',
1 => 'nas.flissinger.com',
2 => 'donald.flissinger.com',
3 => 'mediaserver.flissinger.local',
4 => 'fileserver.flissinger.local',
),
'datadirectory' => '/var/nc_data',
'dbtype' => 'mysql',
'version' => '18.0.4.2',
'overwrite.cli.url' => 'https://cloud.flissinger.com',
'dbname' => 'nextcloud',
'dbhost' => 'localhost:/var/run/mysqld/mysqld.sock',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'nextcloud',
'dbpassword' => 'masked',
'installed' => true,
'activity_expire_days' => 14,
'auth.bruteforce.protection.enabled' => true,
'blacklisted_files' =>
array (
0 => '.htaccess',
1 => 'Thumbs.db',
2 => 'thumbs.db',
),
'cron_log' => true,
'enable_previews' => true,
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\PNG',
1 => 'OC\\Preview\\JPEG',
2 => 'OC\\Preview\\GIF',
3 => 'OC\\Preview\\BMP',
4 => 'OC\\Preview\\XBitmap',
5 => 'OC\\Preview\\Movie',
6 => 'OC\\Preview\\PDF',
7 => 'OC\\Preview\\MP3',
8 => 'OC\\Preview\\TXT',
9 => 'OC\\Preview\\MarkDown',
),
'filesystem_check_changes' => 0,
'filelocking.enabled' => 'true',
'htaccess.RewriteBase' => '/',
'integrity.check.disabled' => false,
'knowledgebaseenabled' => false,
'logfile' => '/var/nc_data/nextcloud.log',
'loglevel' => 2,
'logtimezone' => 'Europe/Berlin',
'log_rotate_size' => 104857600,
'maintenance' => false,
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'overwriteprotocol' => 'https',
'preview_max_x' => 1024,
'preview_max_y' => 768,
'preview_max_scale_factor' => 1,
'redis' =>
array (
'host' => '/var/run/redis/redis-server.sock',
'port' => 0,
'timeout' => 0.0,
),
'quota_include_external_storage' => false,
'share_folder' => '/Shares',
'skeletondirectory' => '',
'theme' => '',
'trashbin_retention_obligation' => 'auto, 7',
'updater.release.channel' => 'stable',
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'donald',
'mail_domain' => 'mydomainhere',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'mymailserverwashere',
'mail_smtpport' => '465',
'mail_smtpname' => 'myemailwashere',
'mail_smtppassword' => 'mypasswordwashere',
);
The output of your Apache/nginx/system log in /var/log/nginx/error.log:
2020/05/06 01:22:46 [warn] 71167#71167: *15530 an upstream response is buffered to a temporary file /var/cache/nginx/fastcgi_temp/1/00/0000000001 while reading upstream, client: 10.0.0.18, server: cloud.flissinger.com, request: "SEARCH /remote.php/dav HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "cloud.flissinger.com"
2020/05/06 12:46:30 [error] 1095#1095: *5777 FastCGI sent in stderr: "PHP message: PHP Deprecated: The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence in /var/www/nextcloud/3rdparty/sabre/vobject/lib/Recur/RRuleIterator.php on line 357PHP message: PHP Deprecated: The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence in /var/www/nextcloud/3rdparty/sabre/vobject/lib/Recur/RRuleIterator.php on line 423" while reading response header from upstream, client: 109.38.137.62, server: cloud.flissinger.com, request: "REPORT /remote.php/dav/calendars/donald/contact_birthdays/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "cloud.flissinger.com"
2020/05/06 16:00:02 [warn] 1103#1103: *46764 an upstream response is buffered to a temporary file /var/cache/nginx/fastcgi_temp/1/00/0000000001 while reading upstream, client: 10.0.0.15, server: cloud.flissinger.com, request: "GET /settings/admin/log/download HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "cloud.flissinger.com"
Where to start?
