What's the problem with files id?

I get this message in my logs:

Sabre\DAV\Exception\ServiceUnavailable: Failed to write file contents: File with id “69025” has not been found

Do you have any idee about it ?

About my configuration :
Raspberrypi 4
Raspian OS Lite
New installation of Nextcloud 20.0.2
php 7.3
mysql Ver 15.1 Distrib 10.3.29-MariaDB

Hi @relaxmax, each file on your nextcloud server has an id linked to his path so in your case, a file is missing for nextcloud.

try these lines :
sudo -u www-data php /var/www/html/nextcloud/occ files:repair-tree
sudo -u www-data php /var/www/html/nextcloud/occ files:scan -all

Hi, thanks for your anwser.

i did these two lines but the error comes back.

sudo -u www-data php /var/www/html/nextcloud/occ files:scan -all
returns ok

sudo -u www-data php /var/www/html/nextcloud/occ files:repair-tree
returns : Found 0 file entries with an invalid path

i tried too :
sudo -u www-data php /var/www/nextcloud/occ files:cleanup
returns :
0 orphaned file cache entries deleted
0 orphaned mount entries deleted

Should i edit the database directly ?

should i do a :
occ maintenance:mimetype:update-db ?? who’s update database mimetypes and update filecache ??

@relaxmax you can try your occ command but i don’t kown why the error still here.
If you edit your database, make sure to make a backup before editing please.

thanks for your consideration.

do you know where the file’s id are stored into the database ? i have no idee how the nextcloud database is built.

@relaxmax I think it is in oc_filecache table but not sure…

1 Like

i will try to edit the table.

i give news if it solves the problem

1 Like

Ok it did the trick !
First i saved my database.
Than i loggeg in my database and then enter the line code below :

SELECT * FROM `oc_filecache` WHERE fileid=69025;
DELETE FROM `oc_filecache` WHERE fileid=69025;

It’s ok now
Thanks to Mageunic

1 Like