#1 Le 12/07/2024, à 12:46
- chris_wafer
Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Bonjour,
Je viens d'installer NEXTCLOUD sur un ordinateur. J'y arrive à me connecter sur mon pc où il y a eu l'installation avec l'adresse : http://localhost/nextcloud
J'aimerais maintenant pouvoir y accéder depuis d'autres PCs sur mon réseau local. Or, cela me marque "Accès à partir d'un domain non approuvé".
Pourtant, j'ai bien rajouter l'adresse ip locale des différents ordinateurs dans le config.php :
'trusted_domains' =>
[
'localhost',
'192.168.1.55',
'192.168.1.84'
],
Quelqu'un peut m'aider car je n'arrive pas à trouver?
Merci beaucoup.
Hors ligne
#2 Le 12/07/2024, à 13:12
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Bonjour,
Pour les adresses ipv4, ajoute aussi celle de ta box. Si tu y vas en ipv6, il faut aussi ajouter celles de tes appareils.
Hors ligne
#3 Le 12/07/2024, à 13:24
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Bonjour,
Pour les adresses ipv4, ajoute aussi celle de ta box. Si tu y vas en ipv6, il faut aussi ajouter celles de tes appareils.
C'est fait :
'trusted_domains' =>
[
'localhost',
'192.168.1.55',
'192.168.1.84',
'82.216.155.232',
'2a02:842d:1800:3f01::1/64'
],
Je viens de redémarrer :
sudo systemctl restart apache2
Ça ne change rien...
Hors ligne
#4 Le 12/07/2024, à 13:27
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Regarde aussi la syntaxe de ce fichier config.php. Chez moi les lignes sont numérotées comme sur cette doc :
https://help.nextcloud.com/t/howto-add- … -domain/26
et entre parenthèses et non des crochets.
et il manque une virgule après .84
Dernière modification par O_20_100_O (Le 12/07/2024, à 13:50)
Hors ligne
#5 Le 12/07/2024, à 14:33
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Je viens de faire :
'trusted_domains' =>
array (
0 => 'localhost',
1 => '192.168.1.55',
2 => '192.168.1.84',
3 => '82.216.155.232',
4 => '2a02:842d:1800:3f01::1/64',
),
ça ne change rien...
Hors ligne
#6 Le 12/07/2024, à 15:03
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Veux-tu nous montrer le message complet ? et nous préciser le contexte.
As-tu un nom de domaine ?
Effectivement, le config.sample.php du 25/06/24 présente le tableau entre crochets et sans virgule à la dernière ligne.
* - the exact hostname of your host or virtual host, e.g. demo.example.org.
* - the exact hostname with permitted port, e.g. demo.example.org:443.
* This disallows all other ports on this host
* - use * as a wildcard, e.g. ubos-raspberry-pi*.local will allow
* ubos-raspberry-pi.local and ubos-raspberry-pi-2.local
* - the IP address with or without permitted port, e.g. [2001:db8::1]:8080
* Using TLS certificates where commonName=<IP address> is deprecated
*/
'trusted_domains' =>
[
'demo.example.org',
'otherdomain.example.org',
'10.111.112.113',
'[2001:db8::1]'
],
Les IPv6 sont à mettre entre crochets.
et 1/64 ?
Dernière modification par O_20_100_O (Le 12/07/2024, à 15:32)
Hors ligne
#7 Le 12/07/2024, à 17:47
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Je n'ai pas de nom de domaine.
J'ai installé sur un ordinateur sous Ubuntu en suivant le tuto suivant : nextcloud-serveur
Je suis chez SFR en aDSL.
Voici le message complet :
Quel commande puis taper pour aider à trouver le problème?
Hors ligne
#8 Le 12/07/2024, à 17:56
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Que contient le fichier /etc/hostname de ton serveur ?
Et quel est le hostname dans le virtualhost de /etc/apache2/sites-enabled
Et enfin que retourne
ip a
sur le poste client ?
Dernière modification par O_20_100_O (Le 12/07/2024, à 18:01)
Hors ligne
#9 Le 12/07/2024, à 22:08
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Alors :
cat /etc/hostname
ORDI-ASUS-PORT
ls /etc/apache2/sites-enabled
000-default.conf nextcloud.conf
cat /etc/apache2/sites-enabled/000-default.conf
<VirtualHost *:80>
# The ServerName directive sets the request scheme, hostname and port that
# the server uses to identify itself. This is used when creating
# redirection URLs. In the context of virtual hosts, the ServerName
# specifies what hostname must appear in the request's Host: header to
# match this virtual host. For the default virtual host (this file) this
# value is not decisive as it is used as a last resort host regardless.
# However, you must set it for any further virtual host explicitly.
#ServerName www.example.com
ServerAdmin webmaster@localhost
DocumentRoot /var/www/html
# Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
# error, crit, alert, emerg.
# It is also possible to configure the loglevel for particular
# modules, e.g.
#LogLevel info ssl:warn
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
# For most configuration files from conf-available/, which are
# enabled or disabled at a global level, it is possible to
# include a line for only one particular virtual host. For example the
# following line enables the CGI configuration for this host only
# after it has been globally disabled with "a2disconf".
#Include conf-available/serve-cgi-bin.conf
</VirtualHost>
# vim: syntax=apache ts=4 sw=4 sts=4 sr noet
cat /etc/apache2/sites-enabled/nextcloud.conf
Alias /nextcloud "/var/www/nextcloud/"
<Directory /var/www/nextcloud/>
Require all granted
AllowOverride All
Options FollowSymLinks MultiViews
<IfModule mod_dav.c>
Dav off
</IfModule>
</Directory>
Une idée?
Hors ligne
#10 Le 12/07/2024, à 22:10
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Sur le poste client :
ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: enp0s25: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc fq_codel state DOWN group default qlen 1000
link/ether 54:ee:75:34:e6:34 brd ff:ff:ff:ff:ff:ff
3: wlp2s0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether 38:b1:db:c3:54:25 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.84/24 brd 192.168.1.255 scope global dynamic noprefixroute wlp2s0
valid_lft 82849sec preferred_lft 82849sec
inet6 2a02:842d:1800:3f01:8e5:3b79:d19d:197/128 scope global dynamic noprefixroute
valid_lft 82849sec preferred_lft 82849sec
inet6 2a02:842d:1800:3f01:bc9e:1cf8:b53f:1dc6/64 scope global temporary dynamic
valid_lft 601249sec preferred_lft 82442sec
inet6 2a02:842d:1800:3f01:de32:24d3:698e:2126/64 scope global dynamic mngtmpaddr noprefixroute
valid_lft 604413sec preferred_lft 604413sec
inet6 fe80::4f86:9a5c:fb67:fdb8/64 scope link noprefixroute
valid_lft forever preferred_lft forever
Hors ligne
#11 Le 12/07/2024, à 22:10
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Un idée??? Merci beaucoup pour l'aide.
Hors ligne
#12 Le 13/07/2024, à 08:06
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Pour la box, c'est l'ip locale que je propose d'ajouter. Quelque chose comme 192.168.1.1 ou 192.168.1.254 ou .....
Pour savoir avec quelle ip tu tentes de te connecter, regarde sur le serveur, juste après une tentative, les dernières lignes de :
/var/log/apache2/access.log
et dans
/ton site/data/nextcloud.log
Après, il faudra voir tes virtualhosts.
Dernière modification par O_20_100_O (Le 13/07/2024, à 08:38)
Hors ligne
#13 Le 13/07/2024, à 12:15
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Voici dans le access.log :
192.168.1.84 - - [13/Jul/2024:13:12:07 +0200] "GET /nextcloud/ HTTP/1.1" 400 21096 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36"
192.168.1.84 - - [13/Jul/2024:13:12:08 +0200] "GET /apps/theming/img/background/kamil-porembinski-clouds.jpg HTTP/1.1" 404 491 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36"
voici dans le nextcloud.log :
{"reqId":"4DdFYGYJaL5axyMJU0Pp","level":2,"time":"2024-07-12T03:22:54+00:00","remoteAddr":"127.0.0.1","user":"--","app":"no app in context","method":"POST","url":"/","message":"Host nextcloud.localhost was not connected to because it violates local access rules","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"29.0.3.4","data":[]}
{"reqId":"4DdFYGYJaL5axyMJU0Pp","level":2,"time":"2024-07-12T03:22:54+00:00","remoteAddr":"127.0.0.1","user":"--","app":"no app in context","method":"POST","url":"/","message":"Host nextcloud.localhost was not connected to because it violates local access rules","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"29.0.3.4","data":[]}
{"reqId":"4DdFYGYJaL5axyMJU0Pp","level":3,"time":"2024-07-12T03:24:56+00:00","remoteAddr":"127.0.0.1","user":"admin","app":"no app in context","method":"POST","url":"/","message":"Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"29.0.3.4","exception":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1106,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":351,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":321,"function":"fileRenaming","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":468,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Template/TemplateManager.php","line":297,"function":"move","class":"OC\\Files\\Node\\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":222,"function":"initializeTemplateDirectory","class":"OC\\Files\\Template\\TemplateManager","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":580,"function":"copySkeleton","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":416,"function":"prepareUserLogin","class":"OC\\User\\Session","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":644,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":367,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Setup.php","line":431,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/core/Controller/SetupController.php","line":68,"function":"install","class":"OC\\Setup","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/base.php","line":998,"function":"run","class":"OC\\Core\\Controller\\SetupController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":86,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":351,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":321,"function":"fileRenaming","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":468,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Template/TemplateManager.php","line":297,"function":"move","class":"OC\\Files\\Node\\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":222,"function":"initializeTemplateDirectory","class":"OC\\Files\\Template\\TemplateManager","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":580,"function":"copySkeleton","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":416,"function":"prepareUserLogin","class":"OC\\User\\Session","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":644,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":367,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Setup.php","line":431,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/core/Controller/SetupController.php","line":68,"function":"install","class":"OC\\Setup","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/base.php","line":998,"function":"run","class":"OC\\Core\\Controller\\SetupController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":"42000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":351,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":321,"function":"fileRenaming","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/Node/Node.php","line":468,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/Template/TemplateManager.php","line":297,"function":"move","class":"OC\\Files\\Node\\Node","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":222,"function":"initializeTemplateDirectory","class":"OC\\Files\\Template\\TemplateManager","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":580,"function":"copySkeleton","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":416,"function":"prepareUserLogin","class":"OC\\User\\Session","type":"->"},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":644,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/User/Session.php","line":367,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Setup.php","line":431,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/core/Controller/SetupController.php","line":68,"function":"install","class":"OC\\Setup","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/base.php","line":998,"function":"run","class":"OC\\Core\\Controller\\SetupController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"CustomMessage":"Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException"}}
{"reqId":"DuEFtxFGkVQkkZFh8t2N","level":3,"time":"2024-07-12T03:29:58+00:00","remoteAddr":"127.0.0.1","user":"admin","app":"settings","method":"POST","url":"/index.php/settings/apps/enable","message":"could not enable apps","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"29.0.3.4","exception":{"Exception":"GuzzleHttp\\Exception\\ConnectException","Message":"cURL error 28: Operation timed out after 120000 milliseconds with 190018071 out of 275576425 bytes received (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://objects.githubusercontent.com/github-production-release-asset-2e65be/267047460/c8d3f933-2678-4673-8103-7729a988dd71?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=releaseassetproduction%2F20240712%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20240712T032758Z&X-Amz-Expires=300&X-Amz-Signature=b7676531793e91303ff9b8d62d57559131bfcb90c25d4f01df6506e9dbfe856f&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=267047460&response-content-disposition=attachment%3B%20filename%3Drichdocumentscode.tar.gz&response-content-type=application%2Foctet-stream","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":158,"function":"createRejection","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":110,"function":"finishError","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlHandler.php","line":47,"function":"finish","class":"GuzzleHttp\\Handler\\CurlFactory","type":"::"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":142,"function":"__invoke","class":"GuzzleHttp\\Handler\\CurlHandler","type":"->"},{"file":"/var/www/nextcloud/lib/private/Http/Client/DnsPinMiddleware.php","line":163,"function":"GuzzleHttp\\{closure}","class":"GuzzleHttp\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php","line":35,"function":"OC\\Http\\Client\\{closure}","class":"OC\\Http\\Client\\DnsPinMiddleware","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":31,"function":"__invoke","class":"GuzzleHttp\\PrepareBodyMiddleware","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php","line":71,"function":"GuzzleHttp\\{closure}","class":"GuzzleHttp\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php","line":107,"function":"__invoke","class":"GuzzleHttp\\RedirectMiddleware","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php","line":73,"function":"checkRedirect","class":"GuzzleHttp\\RedirectMiddleware","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/FulfilledPromise.php","line":41,"function":"GuzzleHttp\\{closure}","class":"GuzzleHttp\\RedirectMiddleware","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/TaskQueue.php","line":48,"function":"GuzzleHttp\\Promise\\{closure}","class":"GuzzleHttp\\Promise\\FulfilledPromise","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php","line":248,"function":"run","class":"GuzzleHttp\\Promise\\TaskQueue","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php","line":224,"function":"invokeWaitFn","class":"GuzzleHttp\\Promise\\Promise","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php","line":269,"function":"waitIfPending","class":"GuzzleHttp\\Promise\\Promise","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php","line":226,"function":"invokeWaitList","class":"GuzzleHttp\\Promise\\Promise","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/promises/src/Promise.php","line":62,"function":"waitIfPending","class":"GuzzleHttp\\Promise\\Promise","type":"->"},{"file":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Client.php","line":189,"function":"wait","class":"GuzzleHttp\\Promise\\Promise","type":"->"},{"file":"/var/www/nextcloud/lib/private/Http/Client/Client.php","line":230,"function":"request","class":"GuzzleHttp\\Client","type":"->"},{"file":"/var/www/nextcloud/lib/private/Installer.php","line":279,"function":"get","class":"OC\\Http\\Client\\Client","type":"->"},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AppSettingsController.php","line":518,"function":"downloadApp","class":"OC\\Installer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"enableApps","class":"OCA\\Settings\\Controller\\AppSettingsController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","Line":210,"message":"could not enable apps","exception":{},"CustomMessage":"could not enable apps"}}
{"reqId":"2XuqfJapJ1WYFDSzkZGZ","level":3,"time":"2024-07-12T04:11:11+00:00","remoteAddr":"127.0.0.1","user":"admin","app":"no app in context","method":"MOVE","url":"/remote.php/dav/files/admin/Images_Chris/TEST_NEXT","message":"Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0","version":"29.0.3.4","exception":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1106,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":415,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":326,"function":"fileMoving","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":454,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":178,"function":"moveInto","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":612,"function":"move","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMove","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/Server.php","line":379,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/remote.php","line":172,"args":["/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":86,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":415,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":326,"function":"fileMoving","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":454,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":178,"function":"moveInto","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":612,"function":"move","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMove","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/Server.php","line":379,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/remote.php","line":172,"args":["/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1","Code":"42000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1099,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":328,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1046,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":942,"function":"getRows","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":120,"function":"asItems","class":"OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Db/ShareWrapperRequest.php","line":294,"function":"getItemsFromRequest","class":"OCA\\Circles\\Db\\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/Service/ShareWrapperService.php","line":204,"function":"getSharesByFileIds","class":"OCA\\Circles\\Db\\ShareWrapperRequest","type":"->"},{"file":"/var/www/nextcloud/apps/circles/lib/ShareByCircleProvider.php","line":664,"function":"getSharesByFileIds","class":"OCA\\Circles\\Service\\ShareWrapperService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1691,"function":"getAccessList","class":"OCA\\Circles\\ShareByCircleProvider","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/ShareHelper.php","line":51,"function":"getAccessList","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":598,"function":"getPathsForAccessList","class":"OC\\Share20\\ShareHelper","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":415,"function":"getUserPathsFromPath","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooks.php","line":326,"function":"fileMoving","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/apps/activity/lib/FilesHooksStatic.php","line":75,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooks","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"fileMovePost","class":"OCA\\Activity\\FilesHooksStatic","type":"::"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":852,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php","line":454,"function":"rename","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php","line":178,"function":"moveInto","class":"OCA\\DAV\\Connector\\Sabre\\Directory","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":612,"function":"move","class":"Sabre\\DAV\\Tree","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpMove","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/lib/Server.php","line":379,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/nextcloud/remote.php","line":172,"args":["/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"CustomMessage":"Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException"}}
Une idée?
Hors ligne
#14 Le 13/07/2024, à 17:30
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Pas d'idée? ;-( ;-(
Hors ligne
#15 Le 13/07/2024, à 18:01
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
J'y arrive à me connecter sur mon pc où il y a eu l'installation avec l'adresse : http://localhost/nextcloud
J'aimerais maintenant pouvoir y accéder depuis d'autres PCs sur mon réseau local.
Quelle url rentres-tu dans le navigateur ?
Où sont les fichiers de ton nextcloud ? /var/www/nextcloud ou /var/www/html ou autre chose ?
Tout fonctionne quand tu y accèdes à partir du serveur ?
Hors ligne
#16 Le 13/07/2024, à 18:25
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
1/ Sur les autres PCs, je tape http://192.168.1.38/nextcloud
2/ Alors "/var/www/nextcloud" et "/var/www/nextcloud-data"
3/ Sur le serveur, quand je fais "http://localhost/nextcloud" tout fonctionne nickel.
Une idée? Je désespère... ;-(
Hors ligne
#17 Le 13/07/2024, à 18:27
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Attention si sur le serveur, je tape "http://localhost/nextcloud" ça marche mais si je tape "http://192.168.1.38/nextcloud", j'ai l'erreur!
Pourtant "192.168.1.38" est l'adresse du serveur... Dans ce cas, c'est comme localhost...
Hors ligne
#18 Le 13/07/2024, à 19:09
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Où sont les fichiers de ton nextcloud ? /var/www/nextcloud ou /var/www/html ou autre chose ?
Hors ligne
#19 Le 13/07/2024, à 19:21
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Où sont les fichiers de ton nextcloud ? /var/www/nextcloud ou /var/www/html ou autre chose ?
"/var/www/nextcloud" et "/var/www/nextcloud-data"
Hors ligne
#20 Le 13/07/2024, à 19:58
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Alors je ne comprends pas pourquoi /etc/apache2/sites-enabled/000-default.conf contient :
DocumentRoot /var/www/html
Hors ligne
#21 Le 13/07/2024, à 20:22
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Je ne sais pas... Je dois changer quoi?
Ca serait àa le problème?
Hors ligne
#22 Le 14/07/2024, à 07:18
- O_20_100_O
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
Tu pourrais :
- appliquer au fichier nextcloud config.php la syntaxe du fichier exemple config.sample.php et ne garder que les ip utiles à test tests.
- revoir tes sites activés après avoir compris comment ça fonctionne.
https://httpd.apache.org/docs/2.4/fr/vh … mples.html
La documentation Ubuntu que tu déclares avoir suivi n'est pas parfaite mais je vois pas où elle conseille ce que tu as fait dans nextcloud.conf.
Hors ligne
#23 Le 14/07/2024, à 16:38
- chris_wafer
Re : Nexcloud / Configuration / Erreur "Accès à partir d'un domain..."
ça marche, j'ai dû mettre l'adresse ip locale de mon serveur "192.168.1.38" dans "trusted_domains"... localhost ne suffit pas...
C'est bizarre quand même...
Tout fonctionne nickel!!!!
Merci beaucoup pour ton aide!!!!
Hors ligne