Getting SQL Error

ℹ️ Support 💬 Talk (spreed)
1

An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ttl’ at row 1

app":“PHP”,“method”:“GET”,“url”:“/ocs/v2.php/apps/notifications/api/v2/notifications”,“message”:“fopen(httpseek://): Failed to open stream: "OC\Files\Stream\SeekableHttpStream::stream_open" call failed at /var/www/html/nextcloud/lib/private/Files/Stream/SeekableHttpStream.php#67”,“userAgent”:“Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Firefox/102.0”,“version”:“26.0.2.1”,“data”:{“app”:“PHP”}}
{“reqId”:“ZHiq60kxiVn3Rj5POVlfbAAAAMg”,“level”:3,“time”:“2023-06-01T14:27:55+00:00”,“remoteAddr”:“103.39.135.218”,“user”:“admin”,“app”:“no app in context”,“method”:“GET”,“url”:“/ocs/v2.php/apps/notifications/api/v2/notifications”,“message”:“Failed to get absolute bundle path. Fallback to default ca-bundle.crt”,“userAgent”:“Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Firefox/102.0”,“version”:“26.0.2.1”,“exception”:{“Exception”:“RuntimeException”,“Message”:“Unable to get certificate bundle "/files_external/rootcerts.crt".”,“Code”:0,“Trace”:[{“file”:“/var/www/html/nextcloud/lib/private/Http/Client/Client.php”,“line”:129,“function”:“getAbsoluteBundlePath”,“class”:“OC\Security\CertificateManager”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/Http/Client/Client.php”,“line”:76,“function”:“getCertBundle”,“class”:“OC\Http\Client\Client”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/Http/Client/Client.php”,“line”:226,“function”:“buildRequestOptions”,“class”:“OC\Http\Client\Client”,“type”:“->”},{“file”:“/var/www/html/nextcloud/apps/richdocuments/lib/Service/CapabilitiesService.php”,“line”:135,“function”:“get”,“class”:“OC\Http\Client\Client”,“type”:“->”},{“file”:“/var/www/html/nextcloud/apps/richdocuments/lib/Service/CapabilitiesService.php”,“line”:73,“function”:“refetch”,“class”:“OCA\Richdocuments\Service\CapabilitiesService”,“type”:“->”},{“file”:“/var/www/html/nextcloud/apps/richdocuments/lib/AppInfo/Application.php”,“line”:80,“function”:“getCapabilities”,“class”:“OCA\Richdocuments\Service\CapabilitiesService”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/AppFramework/Bootstrap/FunctionInjector.php”,“line”:66,“function”:“OCA\Richdocuments\AppInfo\{closure}”,“class”:“OCA\Richdocuments\AppInfo\Application”,“type”:“->”,“args”:[“*** sensitive parameters replaced ***”]},{“file”:“/var/www/html/nextcloud/lib/private/AppFramework/Bootstrap/BootContext.php”,“line”:50,“function”:“injectFn”,“class”:“OC\AppFramework\Bootstrap\FunctionInjector”,“type”:“->”},{“file”:“/var/www/html/nextcloud/apps/richdocuments/lib/AppInfo/Application.php”,“line”:135,“function”:“injectFn”,“class”:“OC\AppFramework\Bootstrap\BootContext”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php”,“line”:200,“function”:“boot”,“class”:“OCA\Richdocuments\AppInfo\Application”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/legacy/OC_App.php”,“line”:213,“function”:“bootApp”,“class”:“OC\AppFramework\Bootstrap\Coordinator”,“type”:“->”},{“file”:“/var/www/html/nextcloud/lib/private/legacy/OC_App.php”,“line”:141,“function”:“loadApp”,“class”:“OC_App”,“type”:“::”},{“file”:“/var/www/html/nextcloud/ocs/v1.php”,“line”:58,“function”:“loadApps”,“class”:“OC_App”,“type”:“::”},{“file”:“/var/www/html/nextcloud/ocs/v2.php”,“line”:23,“args”:[“/var/www/html/nextcloud/ocs/v1.php”],“function”:“require_once”}],“File”:“/var/www/html/nextcloud/lib/private/Security/CertificateManager.php”,“Line”:258,“message”:“Failed to get absolute bundle path. Fallback to default ca-bundle.crt”,“exception”:{},“CustomMessage”:“Failed to get absolute bundle path. Fallback to default ca-bundle.crt”}}

2

Looks like you’re trying to use an External Mount with a self-signed certificate. Easiest way would be to either get a real signed certificate or, if SSL isn’t required, not use one.

https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/external_storage_configuration_gui.html?highlight=certificates#using-self-signed-certificates

To be clear, that error message seems a bit misleading. I determined this from the rest of the stack trace. And, full disclosure, there are multiple errors in your posted logs. It’s possible there is more than one issue going on.

Also your log entries look like to be somewhat incomplete. Might just be a character or two from a cut and paste - unclear.

Also, please use the preformatted text option in your post in the future for the log entry bits so make sure others can cleanly view it and help you. :slight_smile: