Internal Server Error issue

Nextcloud version: 18.0.4
Operating system and version:
Apache or nginx version: /
PHP version: 7.1
Other info: OVH host, Filezilla, used setup-nextcloud.php on my windows/firefox.

The issue you are facing:
Installed Nextcloud yesterday on my private website using Filezilla. Created an account. Uploaded pictures & videos (7GO), created a shareable link and shared the link to my friends. Suddenly this message appeared for everybody:

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

Feedback:

  • One of the friend tried to connect instead of downloading the files, the problem seemed to appear just at this moment.
  • Also I thought about memory issues but couldn’t find relevant information on OVH online dashboard. Althought my website is working fine.

IT level: medium. I can write html/css, eventually read and understand the logic of dynamic languages such as php but I have never ran a terminal for troubleshooting like I could read on other posts. So that you know :wink: You can ask me advanced things but with a minimum of explanation, thank you! :slight_smile:

The output of your Nextcloud log in Admin > Logging:

{"reqId":"Xrg3bJwMh6ZLt3ip6DzxQwAAAEU","level":3,"time":"2020-05-10T17:18:39+00:00","remoteAddr":"84.59.98.224","user":"--","app":"no app in context","method":"GET","url":"/index.php/s/Aw2YZmAsow7maqo/download?path=%2F&downloadStartSecret=ua93pm9jgqk","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)' with params [\"files\\/6219dcda416fc54c721b57bd2e8c1d53\", 1, 1589134719]:\n\nSQLSTATE[HY000]: General error: 10 disk I/O error","Code":0,"Trace":[{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractSQLiteDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)' with params [\"files\\/6219dcda416fc54c721b57bd2e8c1d53\", 1, 1589134719]:\n\nSQLSTATE[HY000]: General error: 10 disk I/O error",{"errorInfo":["HY000",10,"disk I/O error"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOSqlite\\Driver"},{"errorInfo":["HY000",10,"disk I/O error"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)' with params [\"files\\/6219dcda416fc54c721b57bd2e8c1d53\", 1, 1589134719]:\n\nSQLSTATE[HY000]: General error: 10 disk I/O error"]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1063,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOSqlite\\Driver"},{"errorInfo":["HY000",10,"disk I/O error"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)",{"1":"files/6219dcda416fc54c721b57bd2e8c1d53","2":1,"3":1589134719}]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":220,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)",["files/6219dcda416fc54c721b57bd2e8c1d53",1,1589134719],[2,2,2]]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3)",{"dcValue1":"files/6219dcda416fc54c721b57bd2e8c1d53","dcValue2":1,"dcValue3":1589134719},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"/home/ced/drive/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Adapter.php","line":142,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":265,"function":"insertIgnoreConflict","class":"OC\\DB\\Adapter","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":141,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":187,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Common.php","line":747,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Wrapper/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":1947,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":2059,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1,false]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":399,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",[*filenames deleted from log*]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["////AK/All edited","////AK/Media minute","////AK/Videos"]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":149,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["//AK"]]},{"file":"/home/ced/drive/apps/files_sharing/lib/Controller/ShareController.php","line":636,"function":"get","class":"OC_Files","type":"::","args":["/","AK",{"head":false}]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"downloadShare","class":"OCA\\Files_Sharing\\Controller\\ShareController","type":"->","args":["Aw2YZmAsow7maqo",null,"/","ua93pm9jgqk"]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Files_Sharing\\Controller\\ShareController","downloadShare",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/private/Route/Router.php","line":299,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/s/Aw2YZmAsow7maqo/download"]},{"file":"/home/ced/drive/index.php","line":38,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php","Line":70,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[HY000]: General error: 10 disk I/O error","Code":"HY000","Trace":[{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":220,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)",["files/6219dcda416fc54c721b57bd2e8c1d53",1,1589134719],[2,2,2]]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3)",{"dcValue1":"files/6219dcda416fc54c721b57bd2e8c1d53","dcValue2":1,"dcValue3":1589134719},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"/home/ced/drive/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Adapter.php","line":142,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":265,"function":"insertIgnoreConflict","class":"OC\\DB\\Adapter","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":141,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":187,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Common.php","line":747,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Wrapper/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":1947,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":2059,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1,false]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":399,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",[*filenames deleted from log*]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["////AK/All edited","////AK/Media minute","////AK/Videos"]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":149,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["//AK"]]},{"file":"/home/ced/drive/apps/files_sharing/lib/Controller/ShareController.php","line":636,"function":"get","class":"OC_Files","type":"::","args":["/","AK",{"head":false}]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"downloadShare","class":"OCA\\Files_Sharing\\Controller\\ShareController","type":"->","args":["Aw2YZmAsow7maqo",null,"/","ua93pm9jgqk"]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Files_Sharing\\Controller\\ShareController","downloadShare",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/private/Route/Router.php","line":299,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/s/Aw2YZmAsow7maqo/download"]},{"file":"/home/ced/drive/index.php","line":38,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":119,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 10 disk I/O error","Code":"HY000","Trace":[{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":117,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":220,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?)",["files/6219dcda416fc54c721b57bd2e8c1d53",1,1589134719],[2,2,2]]},{"file":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3)",{"dcValue1":"files/6219dcda416fc54c721b57bd2e8c1d53","dcValue2":1,"dcValue3":1589134719},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"/home/ced/drive/lib/private/DB/QueryBuilder/QueryBuilder.php","line":215,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Adapter.php","line":142,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/home/ced/drive/lib/private/DB/Connection.php","line":265,"function":"insertIgnoreConflict","class":"OC\\DB\\Adapter","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":141,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files/6219dcda416fc54c721b57bd2e8c1d53","lock":1,"ttl":1589134719}]},{"file":"/home/ced/drive/lib/private/Lock/DBLockingProvider.php","line":187,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Common.php","line":747,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files/6219dcda416fc54c721b57bd2e8c1d53",1]},{"file":"/home/ced/drive/lib/private/Files/Storage/Wrapper/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":1947,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files/AK/All edited/IMG_7764.jpg",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"/home/ced/drive/lib/private/Files/View.php","line":2059,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1,false]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":399,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["////////AK/All edited/IMG_7764.jpg",1]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",[*filenames deleted from log*]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":406,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["////AK/All edited","////AK/Media minute","////AK/Videos"]]},{"file":"/home/ced/drive/lib/private/legacy/files.php","line":149,"function":"lockFiles","class":"OC_Files","type":"::","args":[{"__class__":"OC\\Files\\View"},"/",["//AK"]]},{"file":"/home/ced/drive/apps/files_sharing/lib/Controller/ShareController.php","line":636,"function":"get","class":"OC_Files","type":"::","args":["/","AK",{"head":false}]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"downloadShare","class":"OCA\\Files_Sharing\\Controller\\ShareController","type":"->","args":["Aw2YZmAsow7maqo",null,"/","ua93pm9jgqk"]},{"file":"/home/ced/drive/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/App.php","line":125,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Files_Sharing\\Controller\\ShareController"},"downloadShare"]},{"file":"/home/ced/drive/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Files_Sharing\\Controller\\ShareController","downloadShare",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/private/Route/Router.php","line":299,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"token":"Aw2YZmAsow7maqo","_route":"files_sharing.sharecontroller.downloadShare"}]},{"file":"/home/ced/drive/lib/base.php","line":1008,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/s/Aw2YZmAsow7maqo/download"]},{"file":"/home/ced/drive/index.php","line":38,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/ced/drive/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":117}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (iPhone; CPU iPhone OS 13_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Mobile/15E148 Safari/604.1","version":"18.0.4.2"}

I kept only the last line of the log and deleted most of the filepaths to my images, to follow the size limit of my post. If you need more, just tell me :slight_smile:

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

<?php
$CONFIG = array (
  'instanceid' => '',
  'passwordsalt' => '',
  'secret' => '',
  'trusted_domains' => 
  array (
    0 => 'drive.cedricfettouche.com',
  ),
  'datadirectory' => '/home/ced/drive/data',
  'dbtype' => 'sqlite3',
  'version' => '18.0.4.2',
  'overwrite.cli.url' => 'http://drive.cedricfettouche.com',
  'installed' => true,
);

Basically this part in your Log could giva a hint :grinning:

Hello !

Did you try to reboot ?

How your disk are mounted ?
Can you turn over the results of the two tests ?
mount and df -h

No real idea.

Perhaps you can use a tmp-dir. Not tested and perhaps not the error

See:

You can change from sqlite3 to MariaDB. Perhaps there is the error.
I think on a webspace it is not so easy to change from sqlite3 to MariaDB.
Perhaps you can move the data, reinstall, move data back, configure user and occ files:scan .

1 Like

Don’t forget this part please :slight_smile:

Okay I’ll try to find similar posts and understand a bit better what it means.

I’m using a webhost (OVH) so I have no idea how they mounted their disks and like I said I have no idea how to run these two tests, if you can give me some insights (I’m on windows).

I understand you mean to generate a temporary folder using filezilla but with no more information, I don’t know where or what to do. I’ll try to find out.

So you’re saying I could take all my pictures to another folder (to not have to upload them again), delete by hand the folder nextcloud using Filezilla and restart the installation process? What is the step about shifting to MariaDB?

Thanks for your guidances :slight_smile:

Okay so I tried the last -temporary- solution, as in I deleted the folder and reinstalled nextcloud.
I couldn’t find out how to install Mariadb so I did sqlite3 again. That’s why it’s a temporary solution, but it works. If you have few insights on how to move on to Mariadb, feel free to share. Again I don’t have terminal/sudo access, just the OVH dashboard and phpmyadmin for the database.

So then I moved my pictures’ folder back in, like you said, to avoid re-upload. But you mentionned an “occ files:scan” which sounds like a command for nextcloud to show back the files on my interface. How can I do it without using a command line? (or a great tutorial to start managing my website with command lines on windows :stuck_out_tongue: )

Thanks,

PS: of course it crashed again once few people connected to the folder via my shareable link :wink: So probably I need to use MariaDB if you can guide me a little thanks.

On a webspace your provider has installed a MariaDB or MySQLDB. Look in your configuration. You have normally only one db-user. Use this user for configuration.

There you can find your database (localhost) and your user. More do you not need für Nextcloud with MariaDB or MySQL. For database name you can set “nextcloud”.

Just to not forget the focus, I’m looking at the databases because we advised me that it might be causing the issue of the “Internal Server Error”, that’s why I wanted to try to use MySQL/MariaDB instead of SQLite. :slight_smile:

So during the Nextcloud installation, they are asking for this information:

  • User of the database: ced
  • Database pasword: password from phpmyadmin
  • Name of the database: ced
  • Host of the database: localhost

The information I have from my webhost is the following:
MySQL v5.6
Username: ced
Database name: ced
Server’s address: ced.mysql.db

Then I go to phpmyadmin: https://phpmyadmin.cluster011.hosting.ovh.net/
And add my password to connect.
Important note: It seems I can’t create new database with OVH. Just new tables (similar with wordpress and matomo, I just have new tables under the same database) so I used “ced” for the name of the database. Is that an issue?

Now I’ve tried these different informations for the nextcloud registration… with no success:

Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory

I tried to look around and they are saying it’s about granting permission and setting password of database but the solution always comes with command lines…

  • Any idea of to solve this new issue?
  • Should I write “localhost” or write something else?
  • Are they asking for another password? I have only phpmyadmin’s password as far as I know.

Thanks again… slowly slowly :wink:

PS: OVH just told me “php.ini cannot be modified on a shared server” (I don’t even know what it is) and sent me this link http://fpm7.0-check.cluster002.ovh.net/phpinfo.php
Deal with that haha

Yes

I have a system, where i also use my username as dbname:

'dbname' => 'username',

Nextcloud uses prefixes for dbtables. So i think there is no problem.
'dbtableprefix' => 'oc_',

I think there is no connection to the db.
Perhaps you must use “localhost” for the dbname.

You can send me a private message with details if you want.

So I had the right information but somehow it wasn’t clear and a friend helped to install.
If that can help in the future, when you want to find your credentials to connect to your database, this is what I wrote:

User of the database: ced
Database password: password
Name of the database: ced
Host of the database: ced.mysql.db

Solution 1: the easiest, if you have a Wordpress intallation and Filezilla, you can find all this information to connect to MySQL/MariaDB on the wp-config.php at the root of your Wordpress installation.
Solution 2: Your webhost might show you all these information (except the password?).
Solution 3: Yes it is the same credentials than to connect to PHPMyAdmin.