Files/Photos/User settings modules, internal server error

Nextcloud version (eg, 20.0.5): 25.0.2
Operating system and version (eg, Ubuntu 20.04): Linux Gentoo
Apache or nginx version (eg, Apache 2.4.25): 2.4.54
PHP version (eg, 7.4): 7.4.33

Using my browser, I did some file cleanup on my NC account. First deletions went ok, then I began to get errors (failed to suppress file). Nonetheless, the files seemed do be removed, at least from the browser interface.

And then I got HTTP 500 errors, without anything obvious in the logs (except the request line, with exit status 500).

Now, I still can use the agenda and contact applications, but no more Files nor Photos, or even User Settings/Parameters.

Seems only one user (me) affected, so no NC bug but rather… something got bad in the database ?

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

Steps to replicate it:

  1. Connect on my account
  2. Go to files, photos or user settings
  3. Get the « Internal server error » page.

The output of your Nextcloud log in Admin > Logging:

Log is empty (last messages from 2017).

The output of your Apache/nginx/system log in /var/log/____: (an extract)

192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /apps/files/img/delete-color.svg HTTP/1.1” 200 306
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&x=250&y=250&c=9463be832f0bf43c603626d63ad5e988&fileId=490489 HTTP/1.1” 200 16836
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=f497bba47d514423d40946245e7c0f29&x=250&y=250&fileId=489569 HTTP/1.1” 200 16679
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=bff003d6c4683522deed1942f5da780e&x=250&y=250&fileId=494681 HTTP/1.1” 500 4336
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=04f7325606f1e111f91dfda2241437f3&x=250&y=250&fileId=489559 HTTP/1.1” 200 19064
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=d60930e5de990f7bf3601c56304c7781&x=250&y=250&fileId=494012 HTTP/1.1” 200 15749
192.168.1.13 - - [11/Jan/2023:21:44:14 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=a6398cc8966b8a5bfd306932241dfede&x=250&y=250&fileId=495092 HTTP/1.1” 500 4336
192.168.1.13 - - [11/Jan/2023:21:44:15 +0100] [443] “GET /index.php/core/preview?forceIcon=0&a=0&c=af32d9ff4350e98d486f6430b5f4960d&x=250&y=250&fileId=490536 HTTP/1.1” 200 13531