DBAL Query exception useing where()

ℹ️ Support
1

Nextcloud version (eg, 20.0.5): 26.0.0
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.25
PHP version (eg, 7.4): 8.1.18

The issue you are facing:

[no app in context] Warning: Doctrine\DBAL\Query\QueryException: Using where() on non-empty WHERE part, please verify it is intentional to not call whereAnd() or whereOr() instead. Otherwise consider creating a new query builder object or call resetQueryPart('where') first. at <<closure>>

0. /var/www/nextcloud/apps/passwords/lib/Db/RegistrationMapper.php line 29
   OC\DB\QueryBuilder\QueryBuilder->where()
1. /var/www/nextcloud/apps/passwords/lib/Helper/CleanUp/CleanRegistrationsHelper.php line 45
   OCA\Passwords\Db\RegistrationMapper->findAllOlderThan()
2. /var/www/nextcloud/apps/passwords/lib/Cron/CleanUpEntities.php line 75
   OCA\Passwords\Helper\CleanUp\CleanRegistrationsHelper->run()
3. /var/www/nextcloud/apps/passwords/lib/Cron/AbstractTimedJob.php line 74
   OCA\Passwords\Cron\CleanUpEntities->runJob()
4. /var/www/nextcloud/lib/private/BackgroundJob/Job.php line 54
   OCA\Passwords\Cron\AbstractTimedJob->run()
5. /var/www/nextcloud/lib/private/BackgroundJob/TimedJob.php line 60
   OC\BackgroundJob\Job->execute()
6. /var/www/nextcloud/cron.php line 152
   OC\BackgroundJob\TimedJob->execute()

Is this the first time you’ve seen this error? (Y/N):Y

Steps to replicate it:

  1. Update from nextcloud 25 to 26

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

{
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "***REMOVED SENSITIVE VALUE***"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "26.0.0.11",
    "overwrite.cli.url": "https:\/\/hb.vfftest.com",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "maintenance": false,
    "mail_smtpmode": "smtp",
    "mail_sendmailmode": "smtp",
    "default_phone_region": "***REMOVED SENSITIVE VALUE***",
    "memcache.local": "\\OC\\Memcache\\APCu",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "memcache.distributed": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "port": 6379,
        "dbindex": 0,
        "password": "***REMOVED SENSITIVE VALUE***",
        "timeout": 1.5
    },
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpauth": 1,
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "2525",
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpsecure": "tls",
    "mail_smtpauthtype": "PLAIN",
    "theme": "",
    "debug": "true",
    "loglevel": 2,
    "htaccess.RewriteBase": "\/",
    "updater.release.channel": "stable",
    "updater.secret": "***REMOVED SENSITIVE VALUE***",
    "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory"
}
1 Like