kesselb
commented
5 years ago Thank you for reporting this issue :+1:
Duplicate of #15613
Closed elsudano closed 5 years ago
kesselb
commented
5 years ago Thank you for reporting this issue :+1:
Duplicate of #15613
Steps to reproduce
Expected behaviour
When a clean installation is performed and the PostgreSQL database engine is used, the installation fails, just as if an update is made.
Also try install Nextcloud version 16.0.1.1
Actual behaviour
When the installation is finished it gives an error 500 and does not show the welcome screen
Server configuration
Operating system: CentOS Linux release 7.6.1810 (Core)
Web server: nginx version: nginx/1.12.2
Database: postgres (PostgreSQL) 9.2.24
PHP version: PHP 7.2.17 (cli) (built: May 13 2019 18:03:04) ( NTS )
Nextcloud version: 16.0.0.9
Updated from an older Nextcloud/ownCloud or fresh install: both
Where did you install Nextcloud from: /nextcloud
Nextcloud configuration:
Config report
``` '*************', 'passwordsalt' => '*********************', 'secret' => '*************************************', 'trusted_domains' => array ( 0 => 'my.domain.com', ), 'datadirectory' => '/nextcloud/data', 'dbtype' => 'pgsql', 'version' => '16.0.0.9', 'overwrite.cli.url' => 'https://my.domain.com', 'dbname' => 'nextcloud', 'dbhost' => 'localhost', 'dbport' => '', 'dbtableprefix' => 'oc_', 'dbuser' => 'oc_admin', 'dbpassword' => '*********************************', 'installed' => true, ); ```Are you using external storage, if yes which one: no
Are you using encryption: no
Are you using an external user-backend, if yes which one: no
Client configuration
Browser: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0
Operating system: Fedora release 30 (Thirty)
Logs
Web server error log
Web server error log
``` 2019/06/15 18:14:52 [error] 8120#0: *1 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 79.153.233.132, server: my.domain.com, request: "GET /apps/files/index.php HTTP/2.0", upstream: "fastcgi://127.0.0.1:9000", host: "my.domain.com" ```Nextcloud log (data/nextcloud.log)
Nextcloud log
``` [usuario@servidor data]$ cat nextcloud.log | tail -1 {"reqId":"5KMCmev2OaMuz4QRghLz","level":3,"time":"2019-06-15T16:23:21+00:00","remoteAddr":"79.153.233.132","user":"admin","app":"core","method":"GET","url":"\/apps\/files\/","message":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/afc6a41efa8bba95cb910fe3276c62e9\", -1, 1560619401]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^","Code":0,"Trace":[{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":184,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/afc6a41efa8bba95cb910fe3276c62e9\", -1, 1560619401]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^",{"errorInfo":["42601",7,"ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":158,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42601",7,"ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/afc6a41efa8bba95cb910fe3276c62e9\", -1, 1560619401]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^"]},{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1088,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42601",7,"ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",{"1":"files\/afc6a41efa8bba95cb910fe3276c62e9","2":-1,"3":1560619401}]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/afc6a41efa8bba95cb910fe3276c62e9",-1,1560619401],[2,2,2]]},{"file":"\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/afc6a41efa8bba95cb910fe3276c62e9","dcValue2":-1,"dcValue3":1560619401},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":200,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",-1]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",2]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/Cache\/Scanner.php","line":331,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1332,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["appdata_ocwm6zwb7g82",false]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1376,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocwm6zwb7g82","\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/Root.php","line":198,"function":"getFileInfo","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"function":"get","class":"OC\\Files\\Node\\Root","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":64,"function":"call_user_func_array","args":[[{"__class__":"OC\\Files\\Node\\Root"},"get"],["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":141,"function":"__call","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["get",["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":86,"function":"get","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":108,"function":"getAppDataRootFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":155,"function":"getAppDataFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Template\/JSCombiner.php","line":97,"function":"newFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":["core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":114,"function":"process","class":"OC\\Template\\JSCombiner","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json","core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":70,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json"]},{"file":"\/nextcloud\/lib\/private\/Template\/ResourceLocator.php","line":78,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->","args":["js\/merged-template-prepend"]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":332,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":160,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["error",""]},{"file":"\/nextcloud\/lib\/private\/Template\/Base.php","line":131,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":332,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"\/nextcloud\/index.php","line":69,"function":"printExceptionErrorPage","class":"OC_Template","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\SyntaxErrorException"},500]}],"File":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractPostgreSQLDriver.php","Line":74,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^","Code":"42601","Trace":[{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1079,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/afc6a41efa8bba95cb910fe3276c62e9",-1,1560619401],[2,2,2]]},{"file":"\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/afc6a41efa8bba95cb910fe3276c62e9","dcValue2":-1,"dcValue3":1560619401},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":200,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",-1]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",2]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/Cache\/Scanner.php","line":331,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1332,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["appdata_ocwm6zwb7g82",false]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1376,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocwm6zwb7g82","\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/Root.php","line":198,"function":"getFileInfo","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"function":"get","class":"OC\\Files\\Node\\Root","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":64,"function":"call_user_func_array","args":[[{"__class__":"OC\\Files\\Node\\Root"},"get"],["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":141,"function":"__call","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["get",["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":86,"function":"get","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":108,"function":"getAppDataRootFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":155,"function":"getAppDataFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Template\/JSCombiner.php","line":97,"function":"newFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":["core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":114,"function":"process","class":"OC\\Template\\JSCombiner","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json","core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":70,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json"]},{"file":"\/nextcloud\/lib\/private\/Template\/ResourceLocator.php","line":78,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->","args":["js\/merged-template-prepend"]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":332,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":160,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["error",""]},{"file":"\/nextcloud\/lib\/private\/Template\/Base.php","line":131,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":332,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"\/nextcloud\/index.php","line":69,"function":"printExceptionErrorPage","class":"OC_Template","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\SyntaxErrorException"},500]}],"File":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":143,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n ^","Code":"42601","Trace":[{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":141,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1079,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/afc6a41efa8bba95cb910fe3276c62e9",-1,1560619401],[2,2,2]]},{"file":"\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/afc6a41efa8bba95cb910fe3276c62e9","dcValue2":-1,"dcValue3":1560619401},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/afc6a41efa8bba95cb910fe3276c62e9","lock":-1,"ttl":1560619401}]},{"file":"\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":200,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",-1]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/afc6a41efa8bba95cb910fe3276c62e9",2]},{"file":"\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/Cache\/Scanner.php","line":331,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["scanner::appdata_ocwm6zwb7g82",2,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1332,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->","args":["appdata_ocwm6zwb7g82",false]},{"file":"\/nextcloud\/lib\/private\/Files\/View.php","line":1376,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->","args":[{"cache":{"__class__":"OC\\Files\\Cache\\Cache"},"scanner":{"__class__":"OC\\Files\\Cache\\Scanner"},"watcher":null,"propagator":null,"updater":null,"__class__":"OCA\\Files_Trashbin\\Storage"},"appdata_ocwm6zwb7g82","\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/Root.php","line":198,"function":"getFileInfo","class":"OC\\Files\\View","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"function":"get","class":"OC\\Files\\Node\\Root","type":"->","args":["\/appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":64,"function":"call_user_func_array","args":[[{"__class__":"OC\\Files\\Node\\Root"},"get"],["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/Node\/LazyRoot.php","line":141,"function":"__call","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["get",["appdata_ocwm6zwb7g82"]]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":86,"function":"get","class":"OC\\Files\\Node\\LazyRoot","type":"->","args":["appdata_ocwm6zwb7g82"]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":108,"function":"getAppDataRootFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Files\/AppData\/AppData.php","line":155,"function":"getAppDataFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/Template\/JSCombiner.php","line":97,"function":"newFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":["core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":114,"function":"process","class":"OC\\Template\\JSCombiner","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json","core"]},{"file":"\/nextcloud\/lib\/private\/Template\/JSResourceLocator.php","line":70,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->","args":["\/nextcloud","core\/js\/merged-template-prepend.json"]},{"file":"\/nextcloud\/lib\/private\/Template\/ResourceLocator.php","line":78,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->","args":["js\/merged-template-prepend"]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":332,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/TemplateLayout.php","line":160,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::","args":[["core\/js\/dist\/main","js\/merged-template-prepend","search\/js\/search","core\/l10n\/en","js\/backgroundjobs","core\/js\/dist\/share_backend","files_pdfviewer\/l10n\/en","files_pdfviewer\/js\/previewplugin","files_rightclick\/l10n\/en","files_rightclick\/js\/script","files_videoplayer\/l10n\/en","files_videoplayer\/js\/main","gallery\/l10n\/en","search\/l10n\/en","search\/js\/searchprovider","js\/files\/fileinfo","js\/files\/client","files\/l10n\/en","files\/js\/merged-index","files_sharing\/l10n\/en","files_sharing\/js\/dist\/files_sharing","files_sharing\/js\/dist\/collaboration","files_trashbin\/l10n\/en","files_trashbin\/js\/files_trashbin","activity\/l10n\/en","activity\/js\/activity-sidebar","comments\/l10n\/en","comments\/js\/comments","files_versions\/l10n\/en","files_versions\/js\/files_versions","files_sharing\/js\/dist\/additionalScripts","firstrunwizard\/l10n\/en","firstrunwizard\/js\/activate","js\/dist\/systemtags","systemtags\/l10n\/en","systemtags\/js\/systemtags","federatedfilesharing\/l10n\/en","federatedfilesharing\/js\/external","files_rightclick\/js\/files","files_texteditor\/l10n\/en","files_texteditor\/js\/..\/build\/editor","gallery\/js\/scripts-for-file-app","recommendations\/l10n\/en","recommendations\/js\/main","viewer\/l10n\/en","viewer\/js\/viewer","firstrunwizard\/js\/about"]]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":183,"function":"__construct","class":"OC\\TemplateLayout","type":"->","args":["error",""]},{"file":"\/nextcloud\/lib\/private\/Template\/Base.php","line":131,"function":"fetchPage","class":"OC_Template","type":"->","args":[]},{"file":"\/nextcloud\/lib\/private\/legacy\/template.php","line":332,"function":"printPage","class":"OC\\Template\\Base","type":"->","args":[]},{"file":"\/nextcloud\/index.php","line":69,"function":"printExceptionErrorPage","class":"OC_Template","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\SyntaxErrorException"},500]}],"File":"\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":141}},"CustomMessage":"--"},"userAgent":"Mozilla\/5.0 (X11; Fedora; Linux x86_64; rv:67.0) Gecko\/20100101 Firefox\/67.0","version":"16.0.0.9"} [usuario@servidor data]$ ```Browser log
Browser log
``` { "log": { "version": "1.2", "creator": { "name": "Firefox", "version": "67.0.2" }, "browser": { "name": "Firefox", "version": "67.0.2" }, "pages": [ { "startedDateTime": "2019-06-15T19:17:29.957+02:00", "id": "page_3", "pageTimings": { "onContentLoad": 39626, "onLoad": 39820 } } ], "entries": [ { "pageref": "page_3", "startedDateTime": "2019-06-15T19:17:29.957+02:00", "request": { "bodySize": 256, "method": "POST", "url": "https://my.domain.com/index.php", "httpVersion": "HTTP/2.0", "headers": [ { "name": "Host", "value": "my.domain.com" }, { "name": "User-Agent", "value": "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" }, { "name": "Accept", "value": "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" }, { "name": "Accept-Language", "value": "es-ES,es;q=0.8,en-US;q=0.5,en;q=0.3" }, { "name": "Accept-Encoding", "value": "gzip, deflate, br" }, { "name": "Content-Type", "value": "application/x-www-form-urlencoded" }, { "name": "Content-Length", "value": "256" }, { "name": "DNT", "value": "1" }, { "name": "Connection", "value": "keep-alive" }, { "name": "Cookie", "value": "ocrs01s3m9gt=2043171c910dcea026beeaccd4463931; oc_sessionPassphrase=ezmT3dQnLRhh1l4BlyzdiVwYPO2Dx4C6%2FFoT%2FCGZzNWTVsUDLje0gumqkhLCMm%2F%2BfA%2BQntz9VgJmHx6IQHdts9MdY0FB0hg0Wv2EEQO%2B3iq5Bu4AnbODTYgokbA%2FO7uO; __Host-nc_sameSiteCookielax=true; __Host-nc_sameSiteCookiestrict=true; oc7068j5o5vs=dad8878025863cef2c51cf46fa925638" }, { "name": "Upgrade-Insecure-Requests", "value": "1" }, { "name": "Pragma", "value": "no-cache" }, { "name": "Cache-Control", "value": "no-cache" }, { "name": "TE", "value": "Trailers" } ], "cookies": [ { "name": "ocrs01s3m9gt", "value": "2043171c910dcea026beeaccd4463931" }, { "name": "oc_sessionPassphrase", "value": "ezmT3dQnLRhh1l4BlyzdiVwYPO2Dx4C6/FoT/CGZzNWTVsUDLje0gumqkhLCMm/+fA+Qntz9VgJmHx6IQHdts9MdY0FB0hg0Wv2EEQO+3iq5Bu4AnbODTYgokbA/O7uO" }, { "name": "__Host-nc_sameSiteCookielax", "value": "true" }, { "name": "__Host-nc_sameSiteCookiestrict", "value": "true" }, { "name": "oc7068j5o5vs", "value": "dad8878025863cef2c51cf46fa925638" } ], "queryString": [], "headersSize": 815, "postData": { "mimeType": "application/x-www-form-urlencoded", "params": [ { "name": "install", "value": "true" }, { "name": "adminlogin", "value": "admin" }, { "name": "adminpass", "value": "" }, { "name": "adminpass-clone", "value": "" }, { "name": "directory", "value": "/nextcloud/data" }, { "name": "dbtype", "value": "pgsql" }, { "name": "dbuser", "value": "oc_admin" }, { "name": "dbpass", "value": "" }, { "name": "dbpass-clone", "value": "" }, { "name": "dbname", "value": "nextcloud" }, { "name": "dbhost", "value": "localhost" } ], "text": "install=true&adminlogin=admin&adminpass=&adminpass-clone=&directory=%2Fnextcloud%2Fdata&dbtype=pgsql&dbuser=oc_admin&dbpass=&dbpass-clone=&dbname=nextcloud&dbhost=localhost" } }, "response": { "status": 302, "statusText": "Found", "httpVersion": "HTTP/2.0", "headers": [ { "name": "server", "value": "nginx/1.12.2" }, { "name": "date", "value": "Sat, 15 Jun 2019 17:18:09 GMT" }, { "name": "content-type", "value": "text/html; charset=UTF-8" }, { "name": "location", "value": "https://my.domain.com/apps/files/" }, { "name": "expires", "value": "Thu, 19 Nov 1981 08:52:00 GMT" }, { "name": "cache-control", "value": "no-store, no-cache, must-revalidate" }, { "name": "pragma", "value": "no-cache" }, { "name": "content-security-policy", "value": "default-src 'self'; script-src 'self' 'nonce-aFI5ZC90RGVpcmh6TlZ4NWtkdHdMdm1zNldWZ24vQzNrWDgxbFZWOGtDdz06L1d3NGxvU211SmNoZldzSTJlc3lINzZjbWljazdZWDl3eE4yMUhvM3d4UT0='; style-src 'self' 'unsafe-inline'; frame-src *; img-src * data: blob:; font-src 'self' data:; media-src *; connect-src *; object-src 'none'; base-uri 'self';" }, { "name": "x-frame-options", "value": "SAMEORIGIN" }, { "name": "set-cookie", "value": "oc7068j5o5vs=823f4ad5a902c7460d25bd1b702b3a03; path=/; secure; HttpOnly" }, { "name": "x-content-type-options", "value": "nosniff" }, { "name": "x-xss-protection", "value": "1; mode=block" }, { "name": "x-robots-tag", "value": "none" }, { "name": "x-download-options", "value": "noopen" }, { "name": "x-permitted-cross-domain-policies", "value": "none" }, { "name": "referrer-policy", "value": "no-referrer" }, { "name": "strict-transport-security", "value": "max-age=63072000; includeSubdomains; preload" }, { "name": "X-Firefox-Spdy", "value": "h2" } ], "cookies": [ { "name": "oc7068j5o5vs", "value": "823f4ad5a902c7460d25bd1b702b3a03" } ], "content": { "mimeType": "text/html; charset=utf-8", "size": 1542, "comment": "Los cuerpos de la respuesta no están incluidos." }, "redirectURL": "https://my.domain.com/apps/files/", "headersSize": 1019, "bodySize": 2561 }, "cache": {}, "timings": { "blocked": 0, "dns": 0, "connect": 0, "ssl": 0, "send": 0, "wait": 39327, "receive": 0 }, "time": 39327, "_securityState": "secure", "serverIPAddress": "193.70.41.38", "connection": "443" }, { "pageref": "page_3", "startedDateTime": "2019-06-15T19:18:09.317+02:00", "request": { "bodySize": 0, "method": "GET", "url": "https://my.domain.com/apps/files/", "httpVersion": "HTTP/2.0", "headers": [ { "name": "Host", "value": "my.domain.com" }, { "name": "User-Agent", "value": "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" }, { "name": "Accept", "value": "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" }, { "name": "Accept-Language", "value": "es-ES,es;q=0.8,en-US;q=0.5,en;q=0.3" }, { "name": "Accept-Encoding", "value": "gzip, deflate, br" }, { "name": "DNT", "value": "1" }, { "name": "Connection", "value": "keep-alive" }, { "name": "Cookie", "value": "ocrs01s3m9gt=2043171c910dcea026beeaccd4463931; oc_sessionPassphrase=ezmT3dQnLRhh1l4BlyzdiVwYPO2Dx4C6%2FFoT%2FCGZzNWTVsUDLje0gumqkhLCMm%2F%2BfA%2BQntz9VgJmHx6IQHdts9MdY0FB0hg0Wv2EEQO%2B3iq5Bu4AnbODTYgokbA%2FO7uO; __Host-nc_sameSiteCookielax=true; __Host-nc_sameSiteCookiestrict=true; oc7068j5o5vs=823f4ad5a902c7460d25bd1b702b3a03" }, { "name": "Upgrade-Insecure-Requests", "value": "1" }, { "name": "Pragma", "value": "no-cache" }, { "name": "Cache-Control", "value": "no-cache" }, { "name": "TE", "value": "Trailers" } ], "cookies": [ { "name": "ocrs01s3m9gt", "value": "2043171c910dcea026beeaccd4463931" }, { "name": "oc_sessionPassphrase", "value": "ezmT3dQnLRhh1l4BlyzdiVwYPO2Dx4C6/FoT/CGZzNWTVsUDLje0gumqkhLCMm/+fA+Qntz9VgJmHx6IQHdts9MdY0FB0hg0Wv2EEQO+3iq5Bu4AnbODTYgokbA/O7uO" }, { "name": "__Host-nc_sameSiteCookielax", "value": "true" }, { "name": "__Host-nc_sameSiteCookiestrict", "value": "true" }, { "name": "oc7068j5o5vs", "value": "823f4ad5a902c7460d25bd1b702b3a03" } ], "queryString": [], "headersSize": 746 }, "response": { "status": 500, "statusText": "Internal Server Error", "httpVersion": "HTTP/2.0", "headers": [ { "name": "server", "value": "nginx/1.12.2" }, { "name": "date", "value": "Sat, 15 Jun 2019 17:18:09 GMT" }, { "name": "content-type", "value": "text/html; charset=utf-8" }, { "name": "content-length", "value": "1542" }, { "name": "etag", "value": "\"5d0517eb-606\"" }, { "name": "X-Firefox-Spdy", "value": "h2" } ], "cookies": [], "content": { "mimeType": "text/html; charset=utf-8", "size": 1542, "text": "\n\n\n\n\n\n\nError :(
\nI'm sorry. Seems we have a problem in our server.
\n400 Bad Request