[Bug]: SQLSTATE 1052 "Column 'file_id' in WHERE is ambiguous" in PreviewMapper::getPreviewForSpecification on MySQL/MariaDB

[kaynemo]

⚠️ 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

Preview generation fails on MySQL/MariaDB with:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'file_id' in WHERE is ambiguous

The error is thrown from OC\Preview\Db\PreviewMapper::getPreviewForSpecification() every time a preview is saved (Generator::savePreview()). In my case it surfaces via the Preview Generator app background job (OCA\PreviewGenerator\BackgroundJob\PreviewJob), but the affected code is in server core, so on-the-fly preview generation is affected as well.

Root cause analysis

PreviewMapper::joinLocation() joins three tables:

• previews (alias p)
• preview_locations (alias l)
• preview_versions (alias v)

Both previews (p) and preview_versions (v) contain a file_id column.

getPreviewForSpecification() builds WHERE conditions from parameter keys without a table alias:

public function getPreviewForSpecification(array $parameters): ?Preview {
    $qb = $this->db->getQueryBuilder();
    $this->joinLocation($qb);

    foreach ($parameters as $key => $value) {
        $qb->andWhere($qb->expr()->eq($key, $qb->createNamedParameter($value)));
    }
    ...
}

When $parameters contains file_id, MySQL/MariaDB rejects the query with error 1052 because the column reference is ambiguous.

The same problem exists in getByFileId():

public function getByFileId(int $fileId): \Generator {
    $selectQb = $this->db->getQueryBuilder();
    $this->joinLocation($selectQb)
        ->where($selectQb->expr()->eq('file_id', $selectQb->createNamedParameter($fileId, IQueryBuilder::PARAM_INT)));
    ...
}

Note that the neighboring method getAvailablePreviewsForFile() does it correctly ('p.file_id'), so this looks like an oversight.

Suggested fix

Prefix the columns with the proper table alias, e.g.:

foreach ($parameters as $key => $value) {
    $alias = ($key === 'version') ? 'v.' : 'p.';
    $qb->andWhere($qb->expr()->eq($alias . $key, $qb->createNamedParameter($value)));
}

and in getByFileId():

->where($selectQb->expr()->eq('p.file_id', $selectQb->createNamedParameter($fileId, IQueryBuilder::PARAM_INT)));

I have applied this patch locally and can confirm the error disappears and previews are generated correctly.

Steps to reproduce

1. Run Nextcloud 34.0.3/34.0.4 on MySQL or MariaDB.
2. Upload any image file (or install the Preview Generator app and wait for the background job / run occ preview:generate-all).
3. Preview generation triggers Generator::savePreview() → PreviewMapper::getPreviewForSpecification() and fails with SQL error 1052; check nextcloud.log.

Expected behavior

Previews are generated and stored without SQL errors.

Nextcloud Server version

34

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.3

Web server

Apache (supported)

Database engine version

MariaDB

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

Updated from a MINOR version (ex. 32.0.1 to 32.0.2)

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

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

Configuration report

{
    "system": {
        "serverid": "1",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "allow_local_remote_servers": true,
        "trusted_domains": [
            "//example.com",
            "//example.com",
            "localhost",
            "//example.com",
            "localhost",
            "//example.com"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "push_server_url": "https:\//example.com/push",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "34.0.3.2",
        "overwrite.cli.url": "https://example.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,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "theme": "",
        "loglevel": 2,
        "overwriteprotocol": "https",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "default_locale": "ru_RU",
        "default_phone_region": "RU",
        "app_install_overwrite": {
            "0": "documentserver_community",
            "2": "files_rightclick",
            "3": "metadata",
            "4": "files_archive"
        },
        "enable_previews": true,
        "preview_libreoffice_path": "\/usr\/bin\/libreoffice",
        "enabledPreviewProviders": [
            "OC\\Preview\\TXT",
            "OC\\Preview\\MarkDown",
            "OC\\Preview\\OpenDocument",
            "OC\\Preview\\PDF",
            "OC\\Preview\\MSOffice2003",
            "OC\\Preview\\MSOfficeDoc",
            "OC\\Preview\\MSOffice2007",
            "OC\\Preview\\Image",
            "OC\\Preview\\Photoshop",
            "OC\\Preview\\TIFF",
            "OC\\Preview\\SVG",
            "OC\\Preview\\Font",
            "OC\\Preview\\MP3",
            "OC\\Preview\\Movie",
            "OC\\Preview\\MKV",
            "OC\\Preview\\MP4",
            "OC\\Preview\\AVI"
        ],
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/nextcloud\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/nextcloud\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "mail_smtpauth": true,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance_window_start": 22,
        "collabora\/code": "https:\//example.com",
        "fileuploadnew.chunk_size": "1G",
        "fileuploadnew.max_filesize": "25G",
        "memory_limit": "26G",
        "timeout": 36000,
        "enable_push": true,
        "has_internet_connection": true,
        "notify_push_base_endpoint": "https://example.com\/push",
        "overwritewebroot": "",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpstreamoptions": {
            "ssl": {
                "allow_self_signed": false,
                "verify_peer": true,
                "verify_peer_name": true
            }
        },
        "logtimezone": "Europe\/Moscow",
        "mail_smtptimeout": 60
    }
}

List of activated Apps

Enabled:
  - activity: 7.0.0
  - admin_audit: 1.24.0
  - admincockpit: 1.3.4
  - analytics: 6.7.1
  - announcementbanner: 2.4.3
  - appstore: 1.0.0
  - bruteforcesettings: 7.0.0
  - calendar: 6.5.3
  - cloud_federation_api: 1.18.0
  - comments: 1.24.0
  - contacts: 8.7.6
  - contactsinteraction: 1.15.0
  - dashboard: 7.14.0
  - dav: 1.40.0
  - deck: 1.18.3
  - external: 9.0.1
  - federatedfilesharing: 1.24.0
  - federation: 1.24.0
  - files: 2.6.0
  - files_accesscontrol: 5.0.0
  - files_automatedtagging: 5.0.0
  - files_downloadlimit: 5.2.0
  - files_external: 1.26.0
  - files_lock: 34.0.1
  - files_pdfviewer: 7.0.0-dev.0
  - files_reminders: 1.7.0
  - files_retention: 5.0.0
  - files_sharing: 1.26.0
  - files_trashbin: 1.24.0
  - files_versions: 1.27.0
  - flow_notifications: 5.0.0
  - forms: 5.3.5
  - guests: 4.9.0
  - localpdf: 1.0.0
  - logcleaner: 1.5.6
  - logreader: 7.0.0
  - lookup_server_connector: 1.22.0
  - nextcloud_announcements: 6.0.0
  - notes: 6.0.1
  - notifications: 7.0.0-dev.1
  - notify_push: 1.4.0
  - oauth2: 1.22.0
  - office: 1.0.0
  - onlyoffice: 10.1.2
  - password_policy: 6.0.0-dev.0
  - previewgenerator: 5.14.0
  - privacy: 6.0.0-dev.1
  - profile: 1.3.0
  - provisioning_api: 1.24.0
  - recommendations: 7.0.0
  - related_resources: 5.0.0-dev.0
  - serverinfo: 6.0.0
  - settings: 1.17.0
  - sharebymail: 1.24.0
  - spreed: 24.0.4
  - support: 6.0.0
  - survey_client: 6.0.0-dev.0
  - systemtags: 1.24.0
  - tables: 2.2.1
  - tasks: 0.18.1
  - text: 8.0.0
  - theming: 2.9.0
  - thesearchpage: 2.4.3
  - twofactor_backupcodes: 1.23.0
  - twofactor_totp: 16.0.0
  - updatenotification: 1.24.0
  - user_status: 1.14.0
  - viewer: 7.0.0-dev.0
  - weather_status: 1.14.0
  - webhook_listeners: 1.6.0
  - workflow_script: 5.0.0
  - workflowengine: 2.16.0
Disabled:
  - app_api: 34.0.0 (installed 32.0.0)
  - circles: 34.0.0 (installed 28.0.0)
  - encryption: 2.22.0
  - files_archive: 1.2.8 (installed 1.2.8)
  - files_zip: 3.0.0 (installed 3.0.0)
  - firstrunwizard: 7.0.0-dev.0 (installed 2.18.0)
  - metadata: 0.24.0 (installed 0.24.0)
  - photos: 7.0.0 (installed 2.4.0)
  - side_menu: 6.0.1 (installed 6.0.1)
  - socialsharing_email: 4.1.0 (installed 4.1.0)
  - socialsharing_telegram: 4.1.0 (installed 4.1.0)
  - suspicious_login: 12.0.0-dev.0
  - testing: 1.23.0
  - twofactor_nextcloud_notification: 8.0.0
  - user_ldap: 1.25.0

Nextcloud Signing status

Nextcloud Logs

<details>

{
  "reqId": "Nrd5F8ZlSxmeEMhpV3fM",
  "level": 3,
  "time": "2026-08-13T21:35:04+03:00",
  "app": "core",
  "message": "Error while running background job OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob (id: 16785, arguments: null)",
  "version": "34.0.3.2",
  "exception": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'file_id' in WHERE is ambiguous",
    "Code": 1052,
    "Trace": [
      { "file": ".../lib/private/Preview/Db/PreviewMapper.php", "line": 250, "function": "findEntity", "class": "OCP\\AppFramework\\Db\\QBMapper" },
      { "file": ".../lib/private/Preview/Generator.php", "line": 605, "function": "getPreviewForSpecification", "class": "OC\\Preview\\Db\\PreviewMapper" },
      { "file": ".../lib/private/Preview/Generator.php", "line": 566, "function": "savePreview", "class": "OC\\Preview\\Generator" },
      { "file": ".../lib/private/Preview/Generator.php", "line": 184, "function": "generatePreview", "class": "OC\\Preview\\Generator" },
      { "file": ".../lib/private/PreviewManager.php", "line": 203, "function": "generatePreviews", "class": "OC\\Preview\\Generator" },
      { "file": ".../apps/previewgenerator/lib/Service/PreGenerateService.php", "line": 160, "function": "generatePreviews", "class": "OC\\PreviewManager" }
    ],
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\NonUniqueFieldNameException",
      "Message": "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'file_id' in WHERE is ambiguous",
      "Code": 1052
    }
  }
}


</details>

Additional info

The bug does not reproduce on PostgreSQL/SQLite in the same way only if those engines resolve the ambiguity differently; on MySQL/MariaDB it fails consistently on every preview save. Happy to submit a PR with the fix above if maintainers agree with the approach.

[joshtrichards]

The bug does not reproduce on PostgreSQL/SQLite in the same way only if those engines resolve the ambiguity differently; on MySQL/MariaDB it fails consistently on every preview save.

Agreed - makes sense.

Proposed fix for getByFileId() looks reasonable to me.

For getPreviewForSpecification(), maybe go a bit simpler for now... e.g. instead of:

		foreach ($parameters as $key => $value) {
    		$alias = ($key === 'version') ? 'v.' : 'p.';
    		$qb->andWhere($qb->expr()->eq(
				$alias . $key,
				$qb->createNamedParameter($value),
			));

Just:

		foreach ($parameters as $key => $value) {
			$qb->andWhere($qb->expr()->eq(
				'p.' . $key,
				$qb->createNamedParameter($value),
			));

...since there doesn't seem to be a need to expose anything beyond p. at the moment via that function.

Happy to submit a PR with the fix above if maintainers agree with the approach.

Please do so. Thanks!

[amessina]

Patching as above on v34.0.3 works (using PostgreSQL), though after patch, the next time cron is run, I get the following, possibly related error:

{
  "reqId": "DaZGBNFLDXLVCPBDSZe4",
  "level": 3,
  "time": "2026-08-14T17:16:37+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "scriptName": "/usr/share/nextcloud/cron.php",
  "message": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \"\"\nCONTEXT:  unnamed portal parameter $5 = ''",
    "Code": 7,
    "Trace": [
      {
        "file": "/usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php",
        "line": 60,
        "function": "wrap",
        "class": "OC\\DB\\Exceptions\\DbalException",
        "type": "::"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 261,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
        "line": 276,
        "function": "executeQuery",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
        "line": 382,
        "function": "findOneQuery",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php",
        "line": 250,
        "function": "findEntity",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
        "line": 605,
        "function": "getPreviewForSpecification",
        "class": "OC\\Preview\\Db\\PreviewMapper",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
        "line": 566,
        "function": "savePreview",
        "class": "OC\\Preview\\Generator",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
        "line": 184,
        "function": "generatePreview",
        "class": "OC\\Preview\\Generator",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/PreviewManager.php",
        "line": 203,
        "function": "generatePreviews",
        "class": "OC\\Preview\\Generator",
        "type": "->"
      },
      {
        "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
        "line": 160,
        "function": "generatePreviews",
        "class": "OC\\PreviewManager",
        "type": "->"
      },
      {
        "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
        "line": 141,
        "function": "processFile",
        "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
        "type": "->"
      },
      {
        "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
        "line": 110,
        "function": "processRow",
        "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
        "type": "->"
      },
      {
        "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
        "line": 73,
        "function": "startProcessing",
        "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
        "type": "->"
      },
      {
        "file": "/var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php",
        "line": 61,
        "function": "preGenerate",
        "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/public/BackgroundJob/Job.php",
        "line": 50,
        "function": "run",
        "class": "OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php",
        "line": 86,
        "function": "start",
        "class": "OCP\\BackgroundJob\\Job",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/core/Service/CronService.php",
        "line": 204,
        "function": "start",
        "class": "OCP\\BackgroundJob\\TimedJob",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/core/Service/CronService.php",
        "line": 107,
        "function": "runCli",
        "class": "OC\\Core\\Service\\CronService",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/cron.php",
        "line": 52,
        "function": "run",
        "class": "OC\\Core\\Service\\CronService",
        "type": "->"
      }
    ],
    "File": "/usr/share/nextcloud/lib/private/DB/Exceptions/DbalException.php",
    "Line": 50,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
      "Message": "An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \"\"\nCONTEXT:  unnamed portal parameter $5 = ''",
      "Code": 7,
      "Trace": [
        {
          "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1976,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1918,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1111,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/DB/Connection.php",
          "line": 427,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php",
          "line": 57,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 261,
          "function": "executeQuery",
          "class": "OC\\DB\\ConnectionAdapter",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
          "line": 276,
          "function": "executeQuery",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
          "line": 382,
          "function": "findOneQuery",
          "class": "OCP\\AppFramework\\Db\\QBMapper",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php",
          "line": 250,
          "function": "findEntity",
          "class": "OCP\\AppFramework\\Db\\QBMapper",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
          "line": 605,
          "function": "getPreviewForSpecification",
          "class": "OC\\Preview\\Db\\PreviewMapper",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
          "line": 566,
          "function": "savePreview",
          "class": "OC\\Preview\\Generator",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
          "line": 184,
          "function": "generatePreview",
          "class": "OC\\Preview\\Generator",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/private/PreviewManager.php",
          "line": 203,
          "function": "generatePreviews",
          "class": "OC\\Preview\\Generator",
          "type": "->"
        },
        {
          "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
          "line": 160,
          "function": "generatePreviews",
          "class": "OC\\PreviewManager",
          "type": "->"
        },
        {
          "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
          "line": 141,
          "function": "processFile",
          "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
          "type": "->"
        },
        {
          "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
          "line": 110,
          "function": "processRow",
          "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
          "type": "->"
        },
        {
          "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
          "line": 73,
          "function": "startProcessing",
          "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
          "type": "->"
        },
        {
          "file": "/var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php",
          "line": 61,
          "function": "preGenerate",
          "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/public/BackgroundJob/Job.php",
          "line": 50,
          "function": "run",
          "class": "OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php",
          "line": 86,
          "function": "start",
          "class": "OCP\\BackgroundJob\\Job",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/core/Service/CronService.php",
          "line": 204,
          "function": "start",
          "class": "OCP\\BackgroundJob\\TimedJob",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/core/Service/CronService.php",
          "line": 107,
          "function": "runCli",
          "class": "OC\\Core\\Service\\CronService",
          "type": "->"
        },
        {
          "file": "/usr/share/nextcloud/cron.php",
          "line": 52,
          "function": "run",
          "class": "OC\\Core\\Service\\CronService",
          "type": "->"
        }
      ],
      "File": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
      "Line": 87,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \"\"\nCONTEXT:  unnamed portal parameter $5 = ''",
        "Code": 7,
        "Trace": [
          {
            "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
            "line": 132,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::"
          },
          {
            "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php",
            "line": 69,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/DB/Middleware/ConnectionActivityStatement.php",
            "line": 26,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\Middleware\\AbstractStatementMiddleware",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1104,
            "function": "execute",
            "class": "OC\\DB\\Middleware\\ConnectionActivityStatement",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/DB/Connection.php",
            "line": 427,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php",
            "line": 57,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 261,
            "function": "executeQuery",
            "class": "OC\\DB\\ConnectionAdapter",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line": 276,
            "function": "executeQuery",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line": 382,
            "function": "findOneQuery",
            "class": "OCP\\AppFramework\\Db\\QBMapper",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php",
            "line": 250,
            "function": "findEntity",
            "class": "OCP\\AppFramework\\Db\\QBMapper",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
            "line": 605,
            "function": "getPreviewForSpecification",
            "class": "OC\\Preview\\Db\\PreviewMapper",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
            "line": 566,
            "function": "savePreview",
            "class": "OC\\Preview\\Generator",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
            "line": 184,
            "function": "generatePreview",
            "class": "OC\\Preview\\Generator",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/private/PreviewManager.php",
            "line": 203,
            "function": "generatePreviews",
            "class": "OC\\Preview\\Generator",
            "type": "->"
          },
          {
            "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
            "line": 160,
            "function": "generatePreviews",
            "class": "OC\\PreviewManager",
            "type": "->"
          },
          {
            "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
            "line": 141,
            "function": "processFile",
            "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
            "type": "->"
          },
          {
            "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
            "line": 110,
            "function": "processRow",
            "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
            "type": "->"
          },
          {
            "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
            "line": 73,
            "function": "startProcessing",
            "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
            "type": "->"
          },
          {
            "file": "/var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php",
            "line": 61,
            "function": "preGenerate",
            "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/public/BackgroundJob/Job.php",
            "line": 50,
            "function": "run",
            "class": "OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php",
            "line": 86,
            "function": "start",
            "class": "OCP\\BackgroundJob\\Job",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/core/Service/CronService.php",
            "line": 204,
            "function": "start",
            "class": "OCP\\BackgroundJob\\TimedJob",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/core/Service/CronService.php",
            "line": 107,
            "function": "runCli",
            "class": "OC\\Core\\Service\\CronService",
            "type": "->"
          },
          {
            "file": "/usr/share/nextcloud/cron.php",
            "line": 52,
            "function": "run",
            "class": "OC\\Core\\Service\\CronService",
            "type": "->"
          }
        ],
        "File": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 24,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \"\"\nCONTEXT:  unnamed portal parameter $5 = ''",
          "Code": "22P02",
          "Trace": [
            {
              "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
              "line": 130,
              "function": "execute",
              "class": "PDOStatement",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php",
              "line": 69,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/DB/Middleware/ConnectionActivityStatement.php",
              "line": 26,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Driver\\Middleware\\AbstractStatementMiddleware",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1104,
              "function": "execute",
              "class": "OC\\DB\\Middleware\\ConnectionActivityStatement",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/DB/Connection.php",
              "line": 427,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php",
              "line": 57,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 261,
              "function": "executeQuery",
              "class": "OC\\DB\\ConnectionAdapter",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
              "line": 276,
              "function": "executeQuery",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
              "line": 382,
              "function": "findOneQuery",
              "class": "OCP\\AppFramework\\Db\\QBMapper",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php",
              "line": 250,
              "function": "findEntity",
              "class": "OCP\\AppFramework\\Db\\QBMapper",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
              "line": 605,
              "function": "getPreviewForSpecification",
              "class": "OC\\Preview\\Db\\PreviewMapper",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
              "line": 566,
              "function": "savePreview",
              "class": "OC\\Preview\\Generator",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/Preview/Generator.php",
              "line": 184,
              "function": "generatePreview",
              "class": "OC\\Preview\\Generator",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/private/PreviewManager.php",
              "line": 203,
              "function": "generatePreviews",
              "class": "OC\\Preview\\Generator",
              "type": "->"
            },
            {
              "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
              "line": 160,
              "function": "generatePreviews",
              "class": "OC\\PreviewManager",
              "type": "->"
            },
            {
              "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
              "line": 141,
              "function": "processFile",
              "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
              "type": "->"
            },
            {
              "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
              "line": 110,
              "function": "processRow",
              "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
              "type": "->"
            },
            {
              "file": "/var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php",
              "line": 73,
              "function": "startProcessing",
              "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
              "type": "->"
            },
            {
              "file": "/var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php",
              "line": 61,
              "function": "preGenerate",
              "class": "OCA\\PreviewGenerator\\Service\\PreGenerateService",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/public/BackgroundJob/Job.php",
              "line": 50,
              "function": "run",
              "class": "OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php",
              "line": 86,
              "function": "start",
              "class": "OCP\\BackgroundJob\\Job",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/core/Service/CronService.php",
              "line": 204,
              "function": "start",
              "class": "OCP\\BackgroundJob\\TimedJob",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/core/Service/CronService.php",
              "line": 107,
              "function": "runCli",
              "class": "OC\\Core\\Service\\CronService",
              "type": "->"
            },
            {
              "file": "/usr/share/nextcloud/cron.php",
              "line": 52,
              "function": "run",
              "class": "OC\\Core\\Service\\CronService",
              "type": "->"
            }
          ],
          "File": "/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "Line": 130
        }
      }
    },
    "message": "Error while running background job OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob (id: 41930, arguments: null)",
    "exception": "{\"class\":\"OC\\DB\\Exceptions\\DbalException\",\"message\":\"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \\\"\\\"\\nCONTEXT:  unnamed portal parameter $5 = ''\",\"code\":7,\"file\":\"/usr/share/nextcloud/lib/private/DB/Exceptions/DbalException.php:50\",\"trace\":\"#0 /usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php(60): OC\\DB\\Exceptions\\DbalException::wrap()\\n#1 /usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(261): OC\\DB\\ConnectionAdapter->executeQuery()\\n#2 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(276): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(382): OCP\\AppFramework\\Db\\QBMapper->findOneQuery()\\n#4 /usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php(250): OCP\\AppFramework\\Db\\QBMapper->findEntity()\\n#5 /usr/share/nextcloud/lib/private/Preview/Generator.php(605): OC\\Preview\\Db\\PreviewMapper->getPreviewForSpecification()\\n#6 /usr/share/nextcloud/lib/private/Preview/Generator.php(566): OC\\Preview\\Generator->savePreview()\\n#7 /usr/share/nextcloud/lib/private/Preview/Generator.php(184): OC\\Preview\\Generator->generatePreview()\\n#8 /usr/share/nextcloud/lib/private/PreviewManager.php(203): OC\\Preview\\Generator->generatePreviews()\\n#9 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(160): OC\\PreviewManager->generatePreviews()\\n#10 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(141): OCA\\PreviewGenerator\\Service\\PreGenerateService->processFile()\\n#11 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(110): OCA\\PreviewGenerator\\Service\\PreGenerateService->processRow()\\n#12 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(73): OCA\\PreviewGenerator\\Service\\PreGenerateService->startProcessing()\\n#13 /var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php(61): OCA\\PreviewGenerator\\Service\\PreGenerateService->preGenerate()\\n#14 /usr/share/nextcloud/lib/public/BackgroundJob/Job.php(50): OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob->run()\\n#15 /usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php(86): OCP\\BackgroundJob\\Job->start()\\n#16 /usr/share/nextcloud/core/Service/CronService.php(204): OCP\\BackgroundJob\\TimedJob->start()\\n#17 /usr/share/nextcloud/core/Service/CronService.php(107): OC\\Core\\Service\\CronService->runCli()\\n#18 /usr/share/nextcloud/cron.php(52): OC\\Core\\Service\\CronService->run()\\n#19 {main}\",\"previous\":{\"class\":\"Doctrine\\DBAL\\Exception\\DriverException\",\"message\":\"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \\\"\\\"\\nCONTEXT:  unnamed portal parameter $5 = ''\",\"code\":7,\"file\":\"/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87\",\"trace\":\"#0 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1976): Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter->convert()\\n#1 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1918): Doctrine\\DBAL\\Connection->handleDriverException()\\n#2 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1111): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()\\n#3 /usr/share/nextcloud/lib/private/DB/Connection.php(427): Doctrine\\DBAL\\Connection->executeQuery()\\n#4 /usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php(57): OC\\DB\\Connection->executeQuery()\\n#5 /usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(261): OC\\DB\\ConnectionAdapter->executeQuery()\\n#6 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(276): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#7 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(382): OCP\\AppFramework\\Db\\QBMapper->findOneQuery()\\n#8 /usr/share/nextcloud/
lib/private/Preview/Db/PreviewMapper.php(250): OCP\\AppFramework\\Db\\QBMapper->findEntity()\\n#9 /usr/share/nextcloud/lib/private/Preview/Generator.php(605): OC\\Preview\\Db\\PreviewMapper->getPreviewForSpecification()\\n#10 /usr/share/nextcloud/lib/private/Preview/Generator.php(566): OC\\Preview\\Generator->savePreview()\\n#11 /usr/share/nextcloud/lib/private/Preview/Generator.php(184): OC\\Preview\\Generator->generatePreview()\\n#12 /usr/share/nextcloud/lib/private/PreviewManager.php(203): OC\\Preview\\Generator->generatePreviews()\\n#13 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(160): OC\\PreviewManager->generatePreviews()\\n#14 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(141): OCA\\PreviewGenerator\\Service\\PreGenerateService->processFile()\\n#15 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(110): OCA\\PreviewGenerator\\Service\\PreGenerateService->processRow()\\n#16 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(73): OCA\\PreviewGenerator\\Service\\PreGenerateService->startProcessing()\\n#17 /var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php(61): OCA\\PreviewGenerator\\Service\\PreGenerateService->preGenerate()\\n#18 /usr/share/nextcloud/lib/public/BackgroundJob/Job.php(50): OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob->run()\\n#19 /usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php(86): OCP\\BackgroundJob\\Job->start()\\n#20 /usr/share/nextcloud/core/Service/CronService.php(204): OCP\\BackgroundJob\\TimedJob->start()\\n#21 /usr/share/nextcloud/core/Service/CronService.php(107): OC\\Core\\Service\\CronService->runCli()\\n#22 /usr/share/nextcloud/cron.php(52): OC\\Core\\Service\\CronService->run()\\n#23 {main}\",\"previous\":{\"class\":\"Doctrine\\DBAL\\Driver\\PDO\\Exception\",\"message\":\"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \\\"\\\"\\nCONTEXT:  unnamed portal parameter $5 = ''\",\"code\":7,\"file\":\"/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:24\",\"trace\":\"#0 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(132): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\\n#1 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php(69): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\\n#2 /usr/share/nextcloud/lib/private/DB/Middleware/ConnectionActivityStatement.php(26): Doctrine\\DBAL\\Driver\\Middleware\\AbstractStatementMiddleware->execute()\\n#3 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): OC\\DB\\Middleware\\ConnectionActivityStatement->execute()\\n#4 /usr/share/nextcloud/lib/private/DB/Connection.php(427): Doctrine\\DBAL\\Connection->executeQuery()\\n#5 /usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php(57): OC\\DB\\Connection->executeQuery()\\n#6 /usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(261): OC\\DB\\ConnectionAdapter->executeQuery()\\n#7 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(276): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#8 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(382): OCP\\AppFramework\\Db\\QBMapper->findOneQuery()\\n#9 /usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php(250): OCP\\AppFramework\\Db\\QBMapper->findEntity()\\n#10 /usr/share/nextcloud/lib/private/Preview/Generator.php(605): OC\\Preview\\Db\\PreviewMapper->getPreviewForSpecification()\\n#11 /usr/share/nextcloud/lib/private/Preview/Generator.php(566): OC\\Preview\\Generator->savePreview()\\n#12 /usr/share/nextcloud/lib/private/Preview/Generator.php(184): OC\\Preview\\Generator->generatePreview()\\n#13 /usr/share/nextcloud/lib/private/PreviewManager.php(203): OC\\Preview\\Generator->generatePreviews()\\n#14 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(160): OC\\PreviewManager->generatePreviews()\\n#15 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(141): OCA\\
PreviewGenerator\\Service\\PreGenerateService->processFile()\\n#16 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(110): OCA\\PreviewGenerator\\Service\\PreGenerateService->processRow()\\n#17 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(73): OCA\\PreviewGenerator\\Service\\PreGenerateService->startProcessing()\\n#18 /var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php(61): OCA\\PreviewGenerator\\Service\\PreGenerateService->preGenerate()\\n#19 /usr/share/nextcloud/lib/public/BackgroundJob/Job.php(50): OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob->run()\\n#20 /usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php(86): OCP\\BackgroundJob\\Job->start()\\n#21 /usr/share/nextcloud/core/Service/CronService.php(204): OCP\\BackgroundJob\\TimedJob->start()\\n#22 /usr/share/nextcloud/core/Service/CronService.php(107): OC\\Core\\Service\\CronService->runCli()\\n#23 /usr/share/nextcloud/cron.php(52): OC\\Core\\Service\\CronService->run()\\n#24 {main}\",\"previous\":{\"class\":\"PDOException\",\"message\":\"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: \\\"\\\"\\nCONTEXT:  unnamed portal parameter $5 = ''\",\"code\":\"22P02\",\"file\":\"/usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130\",\"trace\":\"#0 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(130): PDOStatement->execute()\\n#1 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php(69): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\\n#2 /usr/share/nextcloud/lib/private/DB/Middleware/ConnectionActivityStatement.php(26): Doctrine\\DBAL\\Driver\\Middleware\\AbstractStatementMiddleware->execute()\\n#3 /usr/share/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): OC\\DB\\Middleware\\ConnectionActivityStatement->execute()\\n#4 /usr/share/nextcloud/lib/private/DB/Connection.php(427): Doctrine\\DBAL\\Connection->executeQuery()\\n#5 /usr/share/nextcloud/lib/private/DB/ConnectionAdapter.php(57): OC\\DB\\Connection->executeQuery()\\n#6 /usr/share/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(261): OC\\DB\\ConnectionAdapter->executeQuery()\\n#7 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(276): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#8 /usr/share/nextcloud/lib/public/AppFramework/Db/QBMapper.php(382): OCP\\AppFramework\\Db\\QBMapper->findOneQuery()\\n#9 /usr/share/nextcloud/lib/private/Preview/Db/PreviewMapper.php(250): OCP\\AppFramework\\Db\\QBMapper->findEntity()\\n#10 /usr/share/nextcloud/lib/private/Preview/Generator.php(605): OC\\Preview\\Db\\PreviewMapper->getPreviewForSpecification()\\n#11 /usr/share/nextcloud/lib/private/Preview/Generator.php(566): OC\\Preview\\Generator->savePreview()\\n#12 /usr/share/nextcloud/lib/private/Preview/Generator.php(184): OC\\Preview\\Generator->generatePreview()\\n#13 /usr/share/nextcloud/lib/private/PreviewManager.php(203): OC\\Preview\\Generator->generatePreviews()\\n#14 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(160): OC\\PreviewManager->generatePreviews()\\n#15 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(141): OCA\\PreviewGenerator\\Service\\PreGenerateService->processFile()\\n#16 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(110): OCA\\PreviewGenerator\\Service\\PreGenerateService->processRow()\\n#17 /var/lib/nextcloud/apps/previewgenerator/lib/Service/PreGenerateService.php(73): OCA\\PreviewGenerator\\Service\\PreGenerateService->startProcessing()\\n#18 /var/lib/nextcloud/apps/previewgenerator/lib/BackgroundJob/PreviewJob.php(61): OCA\\PreviewGenerator\\Service\\PreGenerateService->preGenerate()\\n#19 /usr/share/nextcloud/lib/public/BackgroundJob/Job.php(50): OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob->run()\\n#20 /usr/share/nextcloud/lib/public/BackgroundJob/TimedJob.php(86): OCP\\BackgroundJob\\Job->start()\\n#21 /usr/share/nextcloud/core/Service/CronService.php(204)
: OCP\\BackgroundJob\\TimedJob->start()\\n#22 /usr/share/nextcloud/core/Service/CronService.php(107): OC\\Core\\Service\\CronService->runCli()\\n#23 /usr/share/nextcloud/cron.php(52): OC\\Core\\Service\\CronService->run()\\n#24 {main}\"}}}}",
    "CustomMessage": "Error while running background job OCA\\PreviewGenerator\\BackgroundJob\\PreviewJob (id: 41930, arguments: null)"
  },
  "userAgent": "--",
  "version": "34.0.3.2",
  "occ_command": [
    "/usr/share/nextcloud/cron.php"
  ]
}