Hello,
I did an upgrade to version 30 (without errors),
The probleme
I had a few problems. I couldn’t get my logo or favicon to work, even though they were right where they should be.
Nor could I download a file.
You can see the errors below.
I thought there must be an access rights error. I redid what was indicated in the documentation
find nextcloud/ -type d -exec chmod 750 {} ;
find nextcloud/ -type f -exec chmod 640 {} ;
Second probleme solve
Results of my chmod
when I call my server, all I get is a link to nextcloud. I don’t have a log about this.
Luckily I have backups, but what’s going on?
Do you have any ideas?
Thanks in advance
EM
Translated with DeepL.com (free version)
The Basics
- Nextcloud Server version (e.g., 30.0.5):
- Operating system, version (e.g., Debian GNU/Linux 9.13 (stretch)):
- Web server and version (e.g, Apache/2.4.43 (Unix)):
- Reverse proxy and version (e.g. nginx 1.27.2): non installé
- Data base sqlite_:
- PHP version ( PHP Version 8.2.24):
- Is this the first time you’ve seen this error? (No):
- Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
- like here
- Are you using CloudfIare, mod_security, or similar? - ( ??? )
Log entries
log apache
No entry
log php
No entry
error on screen
Causé par SyntaxErrorException An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near “ON”: syntax error
Détail of log error message
{ DbalException An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near "ON": syntax error
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/DB/ConnectionAdapter.phpLigne 93
OC\DB\Exceptions\DbalException::wrap()
[details="information system"]
Produites par un point dans la page duport
[/details]
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Lock/DBLockingProvider.phpLigne 68
OC\DB\ConnectionAdapter->insertIgnoreConflict()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Lock/DBLockingProvider.phpLigne 127
OC\Lock\DBLockingProvider->initLockField()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/Storage/Common.phpLigne 698
OC\Lock\DBLockingProvider->acquireLock()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/Cache/Scanner.phpLigne 323
OC\Files\Storage\Common->acquireLock()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/Cache/LocalRootScanner.phpLigne 22
OC\Files\Cache\Scanner->scan()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/View.phpLigne 1312
OC\Files\Cache\LocalRootScanner->scan()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/View.phpLigne 1348
OC\Files\View->getCacheEntry()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/Node/Root.phpLigne 183
OC\Files\View->getFileInfo()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/Node/LazyFolder.phpLigne 141
OC\Files\Node\Root->get()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Files/AppData/AppData.phpLigne 114
OC\Files\Node\LazyFolder->get()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/theming/lib/ImageManager.phpLigne 382
OC\Files\AppData\AppData->getFolder()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/theming/lib/ImageManager.phpLigne 86
OCA\Theming\ImageManager->getRootFolder()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/apps/theming/lib/Controller/ThemingController.phpLigne 341
OCA\Theming\ImageManager->getImage()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Http/Dispatcher.phpLigne 208
OCA\Theming\Controller\ThemingController->getImage()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/Http/Dispatcher.phpLigne 114
OC\AppFramework\Http\Dispatcher->executeController()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/AppFramework/App.phpLigne 161
OC\AppFramework\Http\Dispatcher->dispatch()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/private/Route/Router.phpLigne 302
OC\AppFramework\App::main()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/lib/base.phpLigne 1003
OC\Route\Router->match()
/srv/data/web/vhosts/cloud.ahds.name/htdocs/index.phpLigne 24
OC::handleRequest()
My Nextcloud
The output of 'php occ config:list system'
php occ config:list system
The current PHP memory limit is below the recommended value of 512MB.
{
“system”: {
“instanceid”: “REMOVED SENSITIVE VALUE”,
“passwordsalt”: “REMOVED SENSITIVE VALUE”,
“secret”: “REMOVED SENSITIVE VALUE”,
“trusted_domains”: [
“cloud.ahds.name”,
“hassoun.be”,
“www.hassoun.be”
],
“datadirectory”: “REMOVED SENSITIVE VALUE”,
“dbtype”: “sqlite3”,
“version”: “30.0.5.1”,
“installed”: true,
“overwrite.cli.url”: “https://cloud.ahds.name”,
“overwriteprotocol”: “https”,
“mail_from_address”: “REMOVED SENSITIVE VALUE”,
“mail_smtpmode”: “smtp”,
“mail_sendmailmode”: “smtp”,
“mail_domain”: “REMOVED SENSITIVE VALUE”,
“mail_smtphost”: “REMOVED SENSITIVE VALUE”,
“mail_smtpport”: “465”,
“mail_smtpsecure”: “ssl”,
“mail_smtpauth”: 1,
“mail_smtpname”: “REMOVED SENSITIVE VALUE”,
“mail_smtppassword”: “REMOVED SENSITIVE VALUE”,
“default_phone_region”: “.be”,
“app_install_overwrite”: [
“mindmap_app”,
“backup”,
“mail_roundcube”
],
“maintenance”: false,
“theme”: “”,
“maintenance_window_start”: 1,
“loglevel”: 2,
“logfile”: “/srv/data/web/vhosts/cloud.ahds.name/externes-data/nextcloud.log”,
“logfile_audit”: “/srv/data/web/vhosts/cloud.ahds.name/externes-data/audit_nextcloud.log”
}
The output of `php occ app:list`
php occ app:list
The current PHP memory limit is below the recommended value of 512MB.
Enabled:
- admin_audit: 1.20.0
- app_api: 4.0.5
- bruteforcesettings: 3.0.0
- calendar: 5.0.9
- cloud_federation_api: 1.13.0
- contacts: 6.1.3
- dashboard: 7.10.0
- dav: 1.31.1
- federatedfilesharing: 1.20.0
- files: 2.2.0
- files_pdfviewer: 3.0.0
- files_reminders: 1.3.0
- files_sharing: 1.22.0
- files_trashbin: 1.20.1
- files_versions: 1.23.0
- logreader: 3.0.0
- lookup_server_connector: 1.18.0
- mail: 4.1.2
- nextcloud_announcements: 2.0.0
- notes: 4.11.0
- notifications: 3.0.0
- oauth2: 1.18.1
- password_policy: 2.0.0
- polls: 7.2.9
- privacy: 2.0.0
- provisioning_api: 1.20.0
- recommendations: 3.0.0
- related_resources: 1.5.0
- settings: 1.13.0
- sharebymail: 1.20.0
- support: 2.0.0
- survey_client: 2.0.0
- tasks: 0.16.1
- text: 4.1.0
- theming: 2.5.0
- twofactor_backupcodes: 1.19.0
- updatenotification: 1.20.0
- viewer: 3.0.0
- webhook_listeners: 1.1.0-dev
- workflowengine: 2.12.0
Disabled:
- activity: 3.0.0 (installed 2.19.0)
- circles: 30.0.0 (installed 27.0.1)
- comments: 1.20.1 (installed 1.20.1)
- contactsinteraction: 1.11.0 (installed 1.8.0)
- encryption: 2.18.0
- federation: 1.20.0 (installed 1.17.0)
- files_downloadlimit: 3.0.0 (installed 3.0.0)
- files_external: 1.22.0 (installed 1.19.0)
- firstrunwizard: 3.0.0 (installed 2.16.0)
- photos: 3.0.2 (installed 2.3.0)
- serverinfo: 2.0.0 (installed 1.17.0)
- suspicious_login: 8.0.0
- systemtags: 1.20.0 (installed 1.17.0)
- twofactor_nextcloud_notification: 4.0.0
- twofactor_totp: 12.0.0-dev
- user_ldap: 1.21.0 (installed 1.17.0)
- user_status: 1.10.0 (installed 1.10.0)
- weather_status: 1.10.0 (installed 1.7.0)