1152 shaares
4 private links
4 private links
14 results
tagged
nextcloud
Nextcloud update failed
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_authtoken CHANGE `password_invalid` password_invalid TINYINT(1) DEFAULT '0'': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes Update failed
do
SET GLOBAL innodb_large_prefix = ON;
SET GLOBAL innodb_file_format = Barracuda;
SET GLOBAL innodb_file_per_table = ON;
Erreur :
- Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
Faire :
- https://docs.nextcloud.com/server/17/admin_manual/configuration_database/mysql_4byte_support.html
- https://help.nextcloud.com/t/solved-syntax-error-or-access-violation-1071-specified-key-was-too-long-max-key-length-is-767-bytes/34740
Ne pas oublier d'enlever le mode maintenance
sudo -u www-data php occ maintenance:mode --off
Récupérer config et .htaccess et utiliser adminer pour récupérer la base de données
cd /var/www
wget https://download.nextcloud.com/server/releases/nextcloud-16.0.4.tar.bz2
tar -xvf nextcloud-*.tar.bz2
sudo service apache2 stop
mv html html-old
mv nextcloud html
mysqldump -u nextcloud_web -p --databases nextcloud > nextcloud.sql
cp html-old/config/config.php html/config/
copier apps manquantes
sudo chown -R www-data:www-data html
sudo chmod -R g+w html
sudo find html/ -type d -exec chmod 750 {} \;
sudo find html/ -type f -exec chmod 640 {} \;
sudo service apache2 start
cd html
sudo -u www-data php occ upgrade
Mettre à jour .htaccess
Add an exception to the "Check for expected files" operation
https://github.com/nextcloud/updater/blob/master/index.php#L293-L328
Nextcloud
Après avoir importé manuellement des fichiers dans Nextcloud (par exemple par ssh ou ftp), il faut forcer Nextcloud à rescanner les fichiers.
Script php à placer dans le répertoire de Nextcloud