What type of hardware are you using: VPS bought online
What YunoHost version are you running: 12.0.11 (stable)
What app is this about: Nextcloud and Collectives app
Describe your issue
I have NC9 on YNH installed with the Collectives App (2.16.1) downloaded and installed.
In the ‘Security & setup warnings’ section of Nextcloud settings I get this error:
Collectives app is enabled, but PDO SQLite driver is missing. Please install it to enable full text search of the page content.
I asked ChatGPT what to do about this, and it advises me to Install SQLite and PDO SQLite extensions from the CLI. But I am wary to install new packages outside from YNH.
What do you think I should best do?
For reasons of completeness, here is the solution from Chat:
To resolve the error you're encountering with Nextcloud, you'll need to install the PDO SQLite driver on your server. Here are the steps to do that, depending on your operating system:
For Ubuntu/Debian:
Update your package list:
sudo apt update
Install the SQLite and PDO SQLite extensions:
sudo apt install php-sqlite3
Restart your web server:
If you're using Apache:
sudo systemctl restart apache2
If you're using Nginx:
sudo systemctl restart nginx
For CentOS/RHEL:
Enable EPEL repository (if not already enabled):
sudo yum install epel-release
Install the SQLite and PDO SQLite extensions:
sudo yum install php-sqlite3
Restart your web server:
If you're using Apache:
sudo systemctl restart httpd
If you're using Nginx:
sudo systemctl restart nginx
Verify Installation:
After installing the PDO SQLite driver, you can verify that it's enabled by creating a PHP info file:
Create a PHP info file:
echo "<?php phpinfo();" > /path/to/your/nextcloud/info.php
Access the file via your web browser: Navigate to http://your-server-address/info.php and search for "PDO" and "sqlite" to ensure they are listed and enabled.
Remove the PHP info file after verification:
rm /path/to/your/nextcloud/info.php
This should resolve the error and enable full text search functionality in the Collectives app on Nextcloud. If you encounter any issues, please let me know!
Share relevant logs or error messages
Collectives app is enabled, but PDO SQLite driver is missing. Please install it to enable full text search of the page content.
