Nextcloud installation seems OK, but CSS is missing

javipas

I've installed Nextcloud on my VPS after creating a new site with

wo site create nextcloud.mydomain.com --mysql --php74

The installation went OK and it seemed like everything was going great. The problem is, after the login shows OK, the stylesheets of the site are missing. Permissions are OK (everything is owned by www-data:www-data) and the error and access logs show nothing.

I guess this could be an issue with my nginx file, but is the one WordOps has created automatically so I don't understand what's happening. The network inspector within Firefox shows the 404 for the css files, but those files are indeed in the Nextcloud folder.

It seems they are been looked for in the wrong place: in the image attached the file is missing when accessing to this path:

/index.php/css/core/614f-a1e8-server.css

But the file is in other place:

./data/appdata_ocj02jazhugb/css/core/614f-a1e8-server.css

Is there a way to solve this?

VirtuBox

Hello javipas,
here my current nextcloud configuration with WordOps :

PhatLam

VirtuBox Hi, after changing vhost and nextcloud.conf like your settings, all the installation work fine for me (Nextcloud 20.0.1.1). But when I try to go to settings page, I got Internal Server Error and log like this

{"reqId":"8yqYndTzDBt29BoARHPE","level":3,"time":"2020-11-02T13:15:15+00:00","remoteAddr":"171.250.245.141","user":"stevenlam","app":"index","method":"GET","url":"/settings/user","message":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException","Message":"An exception occurred while executing 'SELECTdataFROMoc_accountsWHEREuid= ?' with params [\"stevenlam\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list'","Code":0,"Trace":[{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":914,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Accounts/AccountManager.php","line":141,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Settings/Personal/PersonalInfo.php","line":106,"function":"getUser","class":"OC\\Accounts\\AccountManager","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":141,"function":"getForm","class":"OCA\\Settings\\Settings\\Personal\\PersonalInfo","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":77,"function":"formatSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":152,"function":"getSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":68,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"index","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Route/Router.php","line":308,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/base.php","line":1009,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":60,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list'","Code":"42S22","Trace":[{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Accounts/AccountManager.php","line":141,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Settings/Personal/PersonalInfo.php","line":106,"function":"getUser","class":"OC\\Accounts\\AccountManager","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":141,"function":"getForm","class":"OCA\\Settings\\Settings\\Personal\\PersonalInfo","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":77,"function":"formatSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":152,"function":"getSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":68,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"index","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Route/Router.php","line":308,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/base.php","line":1009,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data' in 'field list'","Code":"42S22","Trace":[{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Accounts/AccountManager.php","line":141,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Settings/Personal/PersonalInfo.php","line":106,"function":"getUser","class":"OC\\Accounts\\AccountManager","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":141,"function":"getForm","class":"OCA\\Settings\\Settings\\Personal\\PersonalInfo","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":77,"function":"formatSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/CommonSettingsTrait.php","line":152,"function":"getSettings","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/apps/settings/lib/Controller/PersonalSettingsController.php","line":68,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"index","class":"OCA\\Settings\\Controller\\PersonalSettingsController","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/private/Route/Router.php","line":308,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/cloud.phatdev.net/htdocs/lib/base.php","line":1009,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/cloud.phatdev.net/htdocs/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/cloud.phatdev.net/htdocs/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.1 Safari/605.1.15","version":"20.0.1.1"}

javipas

VirtuBox That works! Thank you 🙂

VirtuBox

PhatLam it seems to be related to the database but I don't know what is the problem. Have you added some plugins or something else ?

PhatLam

VirtuBox I found a mistake, when install nextcloud, I choose the option to install some plugin like calendar, talk, ... so it broke

VirtuBox

PhatLam I will take a look to see if there is an additional configuration to add for those plugins.