Thumbnail Display Issues on Larger Files

Server
1

Hello All,

I need some help and driving myself mad for 48 hours. This is a brand new install experiencing these issues. I have a linux background, so I tried to pull all the info I could for assistance, and I am hope someone can help me before I slam my keyboard through the window :slight_smile:

### Actual behaviour

  • Some Owncloud thumbnails do not load. It seems all small photos display, however anything larger doesn’t display.
  • Upon deeper inspection, in the browser it shows a 404 on the thumbnail / preview with a sabre/dav error when hitting the preview url directly.
  • When accessing file directly, without the appended &preview=1 the files load without issue.
  • Permissions on oc_file cache appear OK and match that of files that work as well as file permissions on docroot and data directory.

### Server configuration
Ubuntu 22.04
Apache 2.4.52
MariaDB 10.6.16
PHP 7.4.33
ownCloud 10.14.0 (stable)
Fresh install from source
Owncloud Integrity check: No errors have been found.



**# cat config.php**
<?php
$CONFIG = array (
  'instanceid' => 'REDACTED',
  'passwordsalt' => 'REDACTED',
  'secret' => 'REDACTED',
  'trusted_domains' =>
  array (
    0 => 'REDACTED',
    1 => 'REDACTED',
  ),
  'datadirectory' => '/var/www/xx/data',
  'logfile' => '/var/www/xx/owncloud.log',
  'loglevel' => '2',
  'overwrite.cli.url' => 'REDACTED',
  'dbtype' => 'mysql',
  'version' => '10.14.0.3',
  'dbname' => 'REDACTED',
  'dbconnectionstring' => '',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'REDACTED',
  'dbpassword' => 'REDACTED',
  'allow_user_to_change_mail_address' => '',
  'filelocking.enabled' => false,
  'memcache.locking' => '\OC\Memcache\Redis',
  'memcache.local' => '\OC\Memcache\Redis',
  'redis' => [
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,       // Set to 0 when using a Unix socket
    'password' => '',  // Optional, if not defined no password will be used.
    'dbindex' => 0,    // Optional, if undefined SELECT will not run and will
                       // use Redis Server's default DB Index.
  ],
  'logtimezone' => 'EST',
  'enable_previews' => true,
  'debug' => true,
  'apps_paths' =>
  array (
    0 =>
    array (
      'path' => '/var/www/xx/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 =>
    array (
      'path' => '/var/www/xx/apps-external',
      'url' => '/apps-external',
      'writable' => true,
    ),
  ),
  'installed' => true,
  'maintenance' => false,
);

**Apps Enabled:**
  - configreport:
    - Version: 0.2.2
  - dav:
    - Version: 0.7.0
  - diagnostics:
    - Version: 0.2.0
  - federatedfilesharing:
    - Version: 0.5.0
  - files:
    - Version: 1.6.0
  - files_texteditor:
    - Version: 2.6.1
  - files_trashbin:
    - Version: 0.9.1
  - files_versions:
    - Version: 1.3.0
  - firstrunwizard:
    - Version: 1.3.0
  - gallery:
    - Version: 16.1.2
  - market:
    - Version: 0.8.0
  - notifications:
    - Version: 0.6.0
  - updatenotification:
    - Version: 0.2.1

**### Client configuration**
All browsers, Windows 10

**Logs / Info:**

**Owncloud / Debug log level 0**



**Attached Image information:**

file errors in browser (404 in developer tools)

https://REDACTED.com/remote.php/dav/files/REDACTED/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1


file loads (without &preview=1 appended)

https://REDACTED.com/remote.php/dav/files/REDACTED/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0

**SQL Queries on oc_filecache of example non working file vs working file** 

non-working thumbnail/file preview:

> select * from oc_filecache where name like '%IMG_20230519_164953_01.jpg%';
+--------+---------+---------------------------------------------------------------------------------------+----------------------------------+--------+----------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+-----------------------------------------------------------------------------------------------------+
| fileid | storage | path                                                                                  | path_hash                        | parent | name                                   | mimetype | mimepart | size    | mtime      | storage_mtime | encrypted | unencrypted_size | etag                             | permissions | checksum                                                                                            |
+--------+---------+---------------------------------------------------------------------------------------+----------------------------------+--------+----------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+-----------------------------------------------------------------------------------------------------+
| 160090 |       2 | files/Photos/2023 MAY 2024 April/DCIM/IMG_20230519_164953_01.jpg                      | 3885db2853fedd4e98ce0dfd94e40ce6 | 159806 | IMG_20230519_164953_01.jpg             |        6 |        5 | 3725614 | 1700542588 |    1700542588 |         0 |                0 | 6fdffea093eef3778e7596104af4a9e5 |          27 | SHA1:3400996934b873ce854cd06c95bcce3e994df3d6 MD5:fe236c8feaf9c223de21bf9e108804ec ADLER32:aae6c79a |
| 167226 |       2 | files_versions/Photos/2023 MAY 2024 April/DCIM/IMG_20230519_164953_01.jpg.v1700542588 | 8778ef4005ebfc6f64276be23a9df2b7 | 167225 | IMG_20230519_164953_01.jpg.v1700542588 |       17 |        3 | 3725614 | 1713747646 |    1713747646 |         0 |                0 | 18b907038c39efa551d7432d87cf41ab |          27 |                                                                                                     |
+--------+---------+---------------------------------------------------------------------------------------+----------------------------------+--------+----------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+-----------------------------------------------------------------------------------------------------+
2 rows in set (0.143 sec)



Working file/thumbnail:

> select * from oc_filecache where name like '%IMG_20230514_212859~2.jpg%';
+--------+---------+-----------------------------------------------------------------+----------------------------------+--------+---------------------------+----------+----------+--------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
| fileid | storage | path                                                            | path_hash                        | parent | name                      | mimetype | mimepart | size   | mtime      | storage_mtime | encrypted | unencrypted_size | etag                             | permissions | checksum |
+--------+---------+-----------------------------------------------------------------+----------------------------------+--------+---------------------------+----------+----------+--------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
| 160088 |       2 | files/Photos/2023 MAY 2024 April/DCIM/IMG_20230514_212859~2.jpg | ea348a5afc67f30f76df8dc988aa4eb9 | 159806 | IMG_20230514_212859~2.jpg |        6 |        5 | 657217 | 1700542587 |    1700542587 |         0 |                0 | 87aacf5ac1b30e36a79f9b7663e62f69 |          27 |          |
+--------+---------+-----------------------------------------------------------------+----------------------------------+--------+---------------------------+----------+----------+--------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
1 row in set (0.142 sec)


**APACHE LOGS:**

# cat /var/log/apache2/*.log | grep IMG_20230519_164953_01.jpg
X.X.X.X - - [22/Apr/2024:17:40:22 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:04:25 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:04:42 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:25:37 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:25:49 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1577 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:26:03 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1577 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:26:26 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:39:39 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1030 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:41:11 -0500] "GET /REDACTED/remote.php/dav/files/jonjay/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1 HTTP/1.1" 404 1565 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
X.X.X.X - - [22/Apr/2024:18:41:22 -0500] "GET /REDACTED/remote.php/webdav/Photos/2023%20MAY%202024%20April/DCIM/IMG_20230519_164953_01.jpg HTTP/1.1" 200 3737141 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Edg/124.0.0.0"
2

cat owncloud.log | grep IMG_20230519_164953_01.jpg

{"reqId":"ZiW23qtmTo7Jjm7ugFZWpQAAAAA","level":0,"time":"2024-04-21T20:01:18-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"OC\\User\\Session::validateToken","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"token 694cf783379ef7988fe0e9fd7e3b50aa194d963faaa70568542d0b4478079a4a0bbdc9c613984d96a90a96aaaae066796c852d220fa33a878e68bfc4d4adc9fd with token id 8 found, validating"}
{"reqId":"ZiW23qtmTo7Jjm7ugFZWpQAAAAA","level":0,"time":"2024-04-21T20:01:18-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"ZiW23qtmTo7Jjm7ugFZWpQAAAAA","level":0,"time":"2024-04-21T20:01:18-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"OC_Image->fixOrientation() Orientation: 6"}
{"reqId":"ZiW23qtmTo7Jjm7ugFZWpQAAAAA","level":0,"time":"2024-04-21T20:01:19-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"webdav","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Exception: HTTP\/1.1 404 Not Found: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\NotFound\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet()\\n#1 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#2 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#3 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Server.php(348): Sabre\\\\DAV\\\\Server->start()\\n#4 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/REDACTED\\\/remote.php(165): require_once('\\\/var\\\/www\\\/jonclo...')\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php\",\"Line\":117}"}
{"reqId":"ZiW51aoxgeQW_v57KBF_rAAAAAo","level":0,"time":"2024-04-21T20:13:57-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"OC\\User\\Session::validateToken","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"token 694cf783379ef7988fe0e9fd7e3b50aa194d963faaa70568542d0b4478079a4a0bbdc9c613984d96a90a96aaaae066796c852d220fa33a878e68bfc4d4adc9fd with token id 8 found, validating"}
{"reqId":"ZiW51aoxgeQW_v57KBF_rAAAAAo","level":0,"time":"2024-04-21T20:13:57-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"ZiW51aoxgeQW_v57KBF_rAAAAAo","level":0,"time":"2024-04-21T20:13:58-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"OC_Image->fixOrientation() Orientation: 6"}
{"reqId":"ZiW51aoxgeQW_v57KBF_rAAAAAo","level":0,"time":"2024-04-21T20:13:58-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"webdav","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Exception: HTTP\/1.1 404 Not Found: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\NotFound\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet()\\n#1 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#2 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#3 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Server.php(348): Sabre\\\\DAV\\\\Server->start()\\n#4 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/REDACTED\\\/remote.php(165): require_once('\\\/var\\\/www\\\/jonclo...')\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php\",\"Line\":117}"}
{"reqId":"ZiW54VWpVtNg44DuqSsBpAAAAAY","level":0,"time":"2024-04-21T20:14:09-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"OC\\User\\Session::validateToken","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"token 694cf783379ef7988fe0e9fd7e3b50aa194d963faaa70568542d0b4478079a4a0bbdc9c613984d96a90a96aaaae066796c852d220fa33a878e68bfc4d4adc9fd with token id 8 found, validating"}
{"reqId":"ZiW54VWpVtNg44DuqSsBpAAAAAY","level":0,"time":"2024-04-21T20:14:09-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"ZiW54VWpVtNg44DuqSsBpAAAAAY","level":0,"time":"2024-04-21T20:14:09-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"OC_Image->fixOrientation() Orientation: 6"}
{"reqId":"ZiW54VWpVtNg44DuqSsBpAAAAAY","level":0,"time":"2024-04-21T20:14:09-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"webdav","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Exception: HTTP\/1.1 404 Not Found: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\NotFound\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet()\\n#1 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#2 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#3 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Server.php(348): Sabre\\\\DAV\\\\Server->start()\\n#4 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/REDACTED\\\/remote.php(165): require_once('\\\/var\\\/www\\\/jonclo...')\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php\",\"Line\":117}"}
{"reqId":"UeTJkaIHgPcDisblzhDk","level":0,"time":"2024-04-21T20:15:01-05:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Started background job of class : OC\\Command\\CommandJob with arguments : O:33:\"OCA\\Files_Versions\\Command\\Expire\":2:{s:43:\"\u0000OCA\\Files_Versions\\Command\\Expire\u0000fileName\";s:59:\"\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\";s:39:\"\u0000OCA\\Files_Versions\\Command\\Expire\u0000user\";s:6:\"REDACTED\";}"}
{"reqId":"UeTJkaIHgPcDisblzhDk","level":0,"time":"2024-04-21T20:15:01-05:00","remoteAddr":"","user":"--","app":"cron","method":"--","url":"--","message":"Finished background job, the job took : 0 seconds, this job is an instance of class : OC\\Command\\CommandJob with arguments : O:33:\"OCA\\Files_Versions\\Command\\Expire\":2:{s:43:\"\u0000OCA\\Files_Versions\\Command\\Expire\u0000fileName\";s:59:\"\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\";s:39:\"\u0000OCA\\Files_Versions\\Command\\Expire\u0000user\";s:6:\"REDACTED\";}"}
{"reqId":"ZiW6WOxqMevwbKXAYd3F2AAAAAs","level":0,"time":"2024-04-21T20:16:08-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/index.php\/apps\/gallery\/preview\/160090?width=2000&height=2000&c=6fdffea093eef3778e7596104af4a9e5&requesttoken=Czc8MnJ7HSQdYWp8JTl%2FKgBIASZEEk0ZOwdUPzROeUQ%3D%3ACqXV76mot9%2FOdU%2BKg8BI3kyRSK5qfa36ZVKS%2FdlkLpU%3D","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"ZiW6cqz-F7VFcvIBuvzl7wAAAAA","level":0,"time":"2024-04-21T20:16:34-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"OC\\User\\Session::validateToken","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"token 694cf783379ef7988fe0e9fd7e3b50aa194d963faaa70568542d0b4478079a4a0bbdc9c613984d96a90a96aaaae066796c852d220fa33a878e68bfc4d4adc9fd with token id 8 found, validating"}
{"reqId":"ZiW6cqz-F7VFcvIBuvzl7wAAAAA","level":0,"time":"2024-04-21T20:16:34-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"ZiW6cqz-F7VFcvIBuvzl7wAAAAA","level":0,"time":"2024-04-21T20:16:34-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"OC_Image->fixOrientation() Orientation: 6"}
{"reqId":"ZiW6cqz-F7VFcvIBuvzl7wAAAAA","level":0,"time":"2024-04-21T20:16:34-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"webdav","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=32&y=32&forceIcon=0&preview=1","message":"Exception: HTTP\/1.1 404 Not Found: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\NotFound\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet()\\n#1 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#2 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#3 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Server.php(348): Sabre\\\\DAV\\\\Server->start()\\n#4 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/REDACTED\\\/remote.php(165): require_once('\\\/var\\\/www\\\/jonclo...')\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php\",\"Line\":117}"}
{"reqId":"Zib9zHKud1sC4NodRZX3RwAAAAU","level":0,"time":"2024-04-22T19:16:12-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core\/sql","method":"PROPFIND","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM","message":"SQL query log","queries":[{"query":"SELECT * FROM `oc_appconfig`","parameters":[],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT * FROM `oc_accounts` WHERE `lower_user_id` = :dcValue1","parameters":{"dcValue1":"REDACTED"},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `appid`, `configkey`, `configvalue` FROM `oc_preferences` WHERE `userid` = ?","parameters":["REDACTED"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `uid`, `login_name`, `password`, `name`, `type`, `token`, `last_activity`, `last_check` FROM `oc_authtoken` WHERE `token` = :token","parameters":{"token":"ca0ebbb6f2befee6522b58d6fa6fc2f2a7f5e314d7bd93488f8aa7ea6abc9601464c7879f90181b29e996c460140e3fd35443e97253b154b30d8bcb71970c877"},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[1,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage_id`, `root_id`, `user_id`, `mount_point` FROM `oc_mounts` WHERE `user_id` = ? ORDER BY `storage_id` ASC","parameters":{"1":"REDACTED"},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[1,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"45b963397aa40d4a0063e0d85e4fe7a1"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[3],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"9f071e3afe939e9abd3de232b40e739b"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[159806],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"9f071e3afe939e9abd3de232b40e739b"],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum` FROM `oc_filecache` WHERE `parent` = :dcValue1 ORDER BY `name` ASC","parameters":{"dcValue1":159806},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160061],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160062],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160067],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160084],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160085],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160086],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160087],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160088],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160089],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160090],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160091],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160092],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160093],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160094],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160095],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160096],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160097],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160098],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160099],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160100],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160101],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160102],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160103],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160104],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160105],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160106],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160107],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160108],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160109],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160110],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160111],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160112],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160113],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160114],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160115],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160116],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160117],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160118],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160119],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160120],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160121],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `uid`, `type`, `category` FROM `oc_vcategory` WHERE `uid` IN (?) AND `type` = ? ORDER BY `category`","parameters":{"1":"REDACTED","2":"files"},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `category`, `categoryid`, `objid` FROM `oc_vcategory_to_object` r, `oc_vcategory` WHERE `categoryid` = `id` AND `uid` = ? AND r.`type` = ? AND `objid` IN (?)","parameters":["REDACTED","files",[159806,160061,160062,160067,160084,160085,160086,160087,160088,160089,160090,160091,160092,160093,160094,160095,160096,160097,160098,160099,160100,160101,160102,160103,160104,160105,160106,160107,160108,160109,160110,160111,160112,160113,160114,160115,160116,160117,160118,160119,160120,160121]],"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/Camera","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/Framelapse","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG-20240101-WA0007.jpeg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230514_212002.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024
3

More owncloud logs

((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230903_174122_01.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230915_143241.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230923_103140.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230923_223455.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20231012_130941.png","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20231013_210134_01.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20231023_192652_01.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20231025_210831_01.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372},{"query":"SELECT `id`, `owner`, `timeout`, `created_at`, `token`, `token`, `scope`, `depth`, `file_id`, `path`, `owner_account_id` FROM `oc_persistent_locks` l INNER JOIN `oc_filecache` f ON l.`file_id` = f.`fileid` WHERE (`storage` = ?) AND (`created_at` > (? - `timeout`)) AND ((f.`path` = ?) OR ((`depth` <> ?) AND (`path` IN (?))))","parameters":{"1":2,"2":1713831372,"3":"files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20231030_182549.jpg","4":0,"5":["files","files\/Photos","files\/Photos\/2023 MAY 2024 April","files\/Photos\/2023 MAY 2024 April\/DCIM"]},"duration":0,"start":1713831372,"end":1713831372}]}
{"reqId":"Zib9zcQHb5VoGypCieGKKwAAAAI","level":0,"time":"2024-04-22T19:16:13-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1","message":"Generating preview for \"\/REDACTED\/files\/Photos\/2023 MAY 2024 April\/DCIM\/IMG_20230519_164953_01.jpg\" with \"OC\\Preview\\JPEG\""}
{"reqId":"Zib9zcQHb5VoGypCieGKKwAAAAI","level":0,"time":"2024-04-22T19:16:13-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1","message":"OC_Image->fixOrientation() Orientation: 6"}
{"reqId":"Zib9zcQHb5VoGypCieGKKwAAAAI","level":0,"time":"2024-04-22T19:16:13-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"webdav","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1","message":"Exception: HTTP\/1.1 404 Not Found: {\"Exception\":\"Sabre\\\\DAV\\\\Exception\\\\NotFound\",\"Message\":\"\",\"Code\":0,\"Trace\":\"#0 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/event\\\/lib\\\/WildcardEmitterTrait.php(89): OCA\\\\DAV\\\\Files\\\\PreviewPlugin->httpGet()\\n#1 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(472): Sabre\\\\DAV\\\\Server->emit()\\n#2 \\\/var\\\/www\\\/REDACTED\\\/lib\\\/composer\\\/sabre\\\/dav\\\/lib\\\/DAV\\\/Server.php(253): Sabre\\\\DAV\\\\Server->invokeMethod()\\n#3 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Server.php(348): Sabre\\\\DAV\\\\Server->start()\\n#4 \\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/appinfo\\\/v2\\\/remote.php(31): OCA\\\\DAV\\\\Server->exec()\\n#5 \\\/var\\\/www\\\/REDACTED\\\/remote.php(165): require_once('\\\/var\\\/www\\\/jonclo...')\\n#6 {main}\",\"File\":\"\\\/var\\\/www\\\/REDACTED\\\/apps\\\/dav\\\/lib\\\/Files\\\/PreviewPlugin.php\",\"Line\":117}"}
{"reqId":"Zib9zcQHb5VoGypCieGKKwAAAAI","level":0,"time":"2024-04-22T19:16:13-05:00","remoteAddr":"X.X.X.X","user":"REDACTED","app":"core\/sql","method":"GET","url":"\/REDACTED\/remote.php\/dav\/files\/REDACTED\/Photos\/2023%20MAY%202024%20April\/DCIM\/IMG_20230519_164953_01.jpg?c=6fdffea093eef3778e7596104af4a9e5&x=36&y=36&forceIcon=0&preview=1","message":"SQL query log","queries":[{"query":"SELECT * FROM `oc_appconfig`","parameters":[],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT * FROM `oc_accounts` WHERE `lower_user_id` = :dcValue1","parameters":{"dcValue1":"REDACTED"},"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `appid`, `configkey`, `configvalue` FROM `oc_preferences` WHERE `userid` = ?","parameters":["REDACTED"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `id`, `uid`, `login_name`, `password`, `name`, `type`, `token`, `last_activity`, `last_check` FROM `oc_authtoken` WHERE `token` = :token","parameters":{"token":"ca0ebbb6f2befee6522b58d6fa6fc2f2a7f5e314d7bd93488f8aa7ea6abc9601464c7879f90181b29e996c460140e3fd35443e97253b154b30d8bcb71970c877"},"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[1,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `storage_id`, `root_id`, `user_id`, `mount_point` FROM `oc_mounts` WHERE `user_id` = ? ORDER BY `storage_id` ASC","parameters":{"1":"REDACTED"},"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[1,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid` FROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"d41d8cd98f00b204e9800998ecf8427e"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"45b963397aa40d4a0063e0d85e4fe7a1"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[3],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `storage`, `path` FROM `oc_filecache` WHERE `fileid` = ?","parameters":[160090],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"4ab9f569f25499b6be1bc9b86a2a890a"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373},{"query":"SELECT `fileid`, `storage`, `path`, `parent`, `name`, `mimetype`, `mimepart`, `size`, `mtime`,\n\t\t\t\t\t   `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`\n\t\t\t\tFROM `oc_filecache` WHERE `storage` = ? AND `path_hash` = ?","parameters":[2,"3885db2853fedd4e98ce0dfd94e40ce6"],"duration":0,"start":1713831373,"end":1713831373}]}
4

owncloud5

5

owncloud2
owncloud21454×715 11.6 KB

6

owncloud3
owncloud31453×162 33 KB

7

owncloud6
owncloud61825×340 49 KB

8

owncloud1
owncloud11538×785 84 KB

9

owncloud7
owncloud7713×406 94.2 KB

10

I also downloaded the files locally to review the image properties, and I notice it looks like the images from my phone are having issues? Is that correlated? Side my side comparision of nonworking vs working.

owncloudimageinfo
owncloudimageinfo1442×725 42.3 KB

11

UGH! Thank you @LinkP

‘preview_max_dimensions’ => ‘6016x6016’,

1 Like
12

When you post logs to a Discourse forum, it is incredibly helpful to preface them with three backticks on a line and follow up with another line of the same.

```
Your
Logs
Here
```

will be displayed as

Your
Logs 
Here

That said, there have been two recent topics here discussing how to adjust the image dimensions that are eligible for preview generation. IIRC, adjusting the sizes in a config fixes it. You should be able to find those topics with a forum :mag:.

1 Like
13

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.