[Bug]: Joplin sync Call to undefined method OC\DB\QueryBuilder\QueryBuilder::execute() (Exception Error) (500)

[stoneubi]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

After upgrading from nextcloud 32.0.2 to nextcloud 33.0.1 installed joplin client cannot sync to the nextcloud server any more.

The following error will be displayed:
Error: PUT xy.md: Call to undefined method OC\DB\QueryBuilder\QueryBuilder::execute() (Exception Error) (500): <d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns"> <s:exception>Error</s:exception> <s:message>Call to undefined method OC\DB\QueryBuilder\QueryBuilder::execute()</s:message> </d:error>

Steps to reproduce

1. Upgrade your nextcloud instance to the latest version 33.0.1
2. start joplin - change anything and try to sync

Expected behavior

joplin client should be able to sync to the nextcloud folder as before the upgrade to the latest nextcloud version.

Nextcloud Server version

33

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.3

Web server

Nginx

Database engine version

MySQL

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

No response

[susnux]

Thank you for the report.
But please fill out the full bug report template, critical information is missing:

• what apps are installed
• full error message from Nextcloud log file

This error happens because QueryBuilder::execute was removed in Nextcloud 33, so this sounds like you have some app installed that is not compatible with Nextcloud 33.

[stoneubi]

Sorry, here are more details about my setup. I rolled back to version 32.0.2 there I cannot provide a full error message log.

php occ config:list system
{
"system": {
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": {
"0": "share.famsteiner.at",
"2": "share.mitleichtigkeit.at",
"1": "10.0.0.250",
"11": "144.208.202.37",
"14": "s250",
"3": "s250"
},
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "mysql",
"version": "32.0.6.1",
"overwrite.cli.url": "https://s250/",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"instanceid": "REMOVED SENSITIVE VALUE",
"memcache.local": "\OC\Memcache\Redis",
"memcache.locking": "\OC\Memcache\Redis",
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"port": 0,
"timeout": 0,
"password": "REMOVED SENSITIVE VALUE"
},
"tempdirectory": "/var/www/nextcloud/data/tmp",
"mail_smtpmode": "smtp",
"mail_smtpauthtype": "LOGIN",
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_domain": "REMOVED SENSITIVE VALUE",
"preview_max_x": 2048,
"preview_max_y": 2048,
"jpeg_quality": 60,
"overwriteprotocol": "https",
"loglevel": "2",
"log_type": "file",
"defaultapp": "files",
"simpleSignUpLink.shown": false,
"mail_sendmailmode": "smtp",
"mail_smtpsecure": "ssl",
"mail_smtpauth": 1,
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "465",
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"maintenance": false,
"logtimezone": "Europe/Vienna",
"logfile": "/root/nextcloud.log",
"syslog_tag": "Nextcloud",
"trusted_proxies": "REMOVED SENSITIVE VALUE",
"data-fingerprint": "60cb2f7d39dac727ff5b75e6c88006fb",
"theme": "",
"default_language": "DE",
"default_locale": "de_AT",
"default_phone_region": "AT",
"memories.exiftool": "/var/www/nextcloud/apps/memories/bin-ext/exiftool-amd64-glibc",
"memories.vod.path": "/var/www/nextcloud/apps/memories/bin-ext/go-vod-amd64",
"app_install_overwrite": {
"1": "previewgenerator",
"2": "unsplash",
"3": "files_rightclick",
"4": "nextcloudpi",
"5": "occweb",
"6": "forms",
"7": "mediadc"
},
"memories.db.triggers.fcu": true,
"maintenance_window_start": 1,
"memories.vod.disable": false,
"memories.vod.ffmpeg": "/usr/bin/ffmpeg",
"memories.vod.ffprobe": "/usr/bin/ffprobe"
}
}
An unhandled exception has been thrown:
RedisException: Permission denied in /var/www/nextcloud/lib/private/RedisFactory.php:104
Stack trace:
#0 /var/www/nextcloud/lib/private/RedisFactory.php(104): Redis->pconnect()
#1 /var/www/nextcloud/lib/private/RedisFactory.php(148): OC\RedisFactory->create()
#2 /var/www/nextcloud/lib/private/Memcache/Redis.php(54): OC\RedisFactory->getInstance()
#3 /var/www/nextcloud/lib/private/Memcache/Redis.php(60): OC\Memcache\Redis->getCache()
#4 /var/www/nextcloud/lib/private/AppConfig.php(1333): OC\Memcache\Redis->get()
#5 /var/www/nextcloud/lib/private/AppConfig.php(284): OC\AppConfig->loadConfig()
#6 /var/www/nextcloud/lib/private/AppConfig.php(1832): OC\AppConfig->searchValues()
#7 /var/www/nextcloud/lib/private/Memcache/Factory.php(121): OC\AppConfig->getAppInstalledVersions()
#8 /var/www/nextcloud/lib/private/Memcache/Factory.php(160): OC\Memcache\Factory->getGlobalPrefix()
#9 /var/www/nextcloud/lib/private/Server.php(936): OC\Memcache\Factory->createLocking()
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(169): OC\Server->OC{closure}()
#11 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#12 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(136): Pimple\Container->offsetGet()
#13 /var/www/nextcloud/lib/private/ServerContainer.php(154): OC\AppFramework\Utility\SimpleContainer->query()
#14 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(45): OC\ServerContainer->query()
#15 /var/www/nextcloud/lib/private/Files/View.php(76): OC\AppFramework\Utility\SimpleContainer->get()
#16 /var/www/nextcloud/lib/private/Server.php(423): OC\Files\View->__construct()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(169): OC\Server->OC{closure}()
#18 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}()
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(136): Pimple\Container->offsetGet()
#20 /var/www/nextcloud/lib/private/ServerContainer.php(154): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(45): OC\ServerContainer->query()
#22 /var/www/nextcloud/lib/private/Server.php(1272): OC\AppFramework\Utility\SimpleContainer->get()
#23 /var/www/nextcloud/lib/base.php(635): OC\Server->boot()
#24 /var/www/nextcloud/lib/base.php(1222): OC::init()
#25 /var/www/nextcloud/console.php(31): require_once('...')
#26 /var/www/nextcloud/occ(33): require_once('...')

Apps:
Enabled:

• activity: 5.0.0
• bookmarks: 16.1.3
• bruteforcesettings: 5.0.0
• calendar: 6.2.1
• cloud_federation_api: 1.16.0
• comments: 1.22.0
• contacts: 8.3.6
• contactsinteraction: 1.13.1
• dav: 1.34.2
• deck: 1.16.3
• event_update_notification: 2.8.0
• federatedfilesharing: 1.22.0
• federation: 1.22.0
• files: 2.4.0
• files_downloadlimit: 5.0.0-dev.0
• files_pdfviewer: 5.0.0
• files_reminders: 1.5.0
• files_sharing: 1.24.1
• files_trashbin: 1.22.0
• files_versions: 1.25.0
• firstrunwizard: 5.0.0
• forms: 5.2.5
• gpoddersync: 3.16.0
• logreader: 5.0.0
• lookup_server_connector: 1.20.0
• mail: 5.7.5
• memories: 7.8.2
• news: 28.1.0
• nextcloud_announcements: 4.0.0
• nextcloudpi: 0.0.2
• nextpod: 0.7.10
• notifications: 5.0.0
• notify_push: 1.3.1
• oauth2: 1.20.0
• occweb: 0.2.3
• password_policy: 4.0.0
• passwords: 2026.3.20
• photos: 5.0.0
• previewgenerator: 99.99.99
• privacy: 4.0.0
• profile: 1.1.0
• provisioning_api: 1.22.0
• related_resources: 3.0.0
• richdocuments: 9.0.5
• richdocumentscode: 25.4.904
• serverinfo: 4.0.0
• settings: 1.15.1
• sharebymail: 1.22.0
• spreed: 22.0.10
• support: 4.0.0
• survey_client: 4.0.0
• suspicious_login: 10.0.0
• systemtags: 1.22.0
• text: 6.0.1
• theming: 2.7.0
• twofactor_backupcodes: 1.21.0
• twofactor_nextcloud_notification: 6.0.0
• twofactor_totp: 14.0.0
• updatenotification: 1.22.0
• user_status: 1.12.0
• viewer: 5.0.0
• webhook_listeners: 1.3.0
• workflowengine: 2.14.0
  Disabled:
• admin_audit: 1.22.0
• app_api: 32.0.0 (installed 5.0.2)
• circles: 32.0.0 (installed 26.0.0)
• dashboard: 7.12.0 (installed 7.0.0)
• encryption: 2.20.0
• files_external: 1.24.1
• recommendations: 5.0.0 (installed 2.1.0)
• user_ldap: 1.23.0
• weather_status: 1.12.0 (installed 1.9.0)

[stoneubi]

Thank you for the report. But please fill out the full bug report template, critical information is missing:

* what apps are installed

* full error message from Nextcloud log file

This error happens because QueryBuilder::execute was removed in Nextcloud 33, so this sounds like you have some app installed that is not compatible with Nextcloud 33.

This is not related to an app inside Nextcloud. The sync is manged by Joplin itself. So if QueryBuilder has been removed in nextcloud 33, this might be the reason for the error. I will report this bug to the joplin team: https://github.com/laurent22/joplin

Thx,
Stoneubi

[laurent22]

We don't actually use this function, maybe you have some app or plugin that's calling this when we make WebDAV calls?

[susnux]

Sorry, here are more details about my setup. I rolled back to version 32.0.2 there I cannot provide a full error message log.

The error listed here is not the same and not related.

I personally think the issue here was caused by the memories app because it still uses the execute() method that was removed.
See also pulsejet/memories#1625