Object of class DateTimeImmutable could not be converted to string #15625
Description
How to use GitHub
- Please use the 👍 reaction to show that you are affected by the same issue.
- Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
- Subscribe to receive notifications on status change and new comments.
Steps to reproduce
Absolutely no clue what caused this. I just noticed it in my logs and thought I would report it.
Expected behaviour
Error does not occur.
Actual behaviour
Error does occur.
Talk app
Talk app version: 21.1.2
Custom Signaling server configured: no
Custom TURN server configured: no
Custom STUN server configured: no
Browser
Not relevant since this occurred as part of a cron job, but I'll include it anyways.
Microphone available: yes
Camera available: yes
Operating system: Arch Linux
Browser name: Firefox
Browser version: 142.0b5
Browser log
N/A
Server configuration
Operating system: Ubuntu
Web server: Apache
Database: MySQL
PHP version: 8.3.11
Nextcloud Version: 31.0.7.1
List of activated apps:
Details
Enabled:
- activity: 4.0.0
- admin_audit: 1.21.0
- analytics: 5.8.0
- announcementcenter: 7.1.4
- app_api: 5.0.2
- apporder: 0.15.0
- audioplayer: 3.5.1
- breezedark: 29.0.0
- bruteforcesettings: 4.0.0
- calendar: 5.3.8
- camerarawpreviews: 0.8.7
- cfg_share_links: 7.0.1
- checksum: 1.2.6
- circles: 31.0.0
- cloud_federation_api: 1.14.0
- comments: 1.21.0
- contacts: 7.2.3
- contactsinteraction: 1.12.0
- cookbook: 0.11.3
- dashboard: 7.11.0
- dav: 1.33.0
- dav_push: 0.0.3
- deck: 1.15.2
- external: 6.0.2
- facerecognition: 0.9.70
- federatedfilesharing: 1.21.0
- files: 2.3.1
- files_automatedtagging: 2.0.0
- files_downloadactivity: 1.18.1
- files_downloadlimit: 4.0.0
- files_external: 1.23.0
- files_fulltextsearch: 31.0.0
- files_fulltextsearch_tesseract: 27.0.1
- files_markdown: 2.4.1
- files_pdfviewer: 4.0.0
- files_readmemd: 3.0.2
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_texteditor: 2.15.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- fileslibreofficeedit: 2.0.1
- firstrunwizard: 4.0.0
- flow_notifications: 2.0.1
- fulltextsearch: 31.0.0
- fulltextsearch_elasticsearch: 31.0.0
- group_default_quota: 0.1.11
- group_everyone: 0.1.17
- groupfolders: 19.1.3
- groupquota: 0.2.2
- guests: 4.3.0
- health: 2.2.2
- imageconverter: 2.0.5
- impersonate: 2.0.0
- integration_github: 3.2.1
- integration_gitlab: 3.2.0
- integration_google: 4.1.0
- integration_mastodon: 3.1.1
- integration_moodle: 1.0.2
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- maps: 1.6.0
- memories: 7.6.1
- messagevault: 1.0.3
- metadata: 0.22.0
- music: 2.2.0
- news: 26.1.0
- nextcloud_announcements: 3.0.0
- notes: 4.12.2
- notifications: 4.0.0
- notify_push: 1.1.0
- oauth2: 1.19.1
- occweb: 0.2.3
- onlyoffice: 9.9.0
- password_policy: 3.0.0
- phonetrack: 0.8.2
- photos: 4.0.0
- previewgenerator: 5.9.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- quota_warning: 1.21.0
- recognize: 9.0.3
- recommendations: 4.0.0
- related_resources: 2.0.0
- secrets: 2.1.2
- serverinfo: 3.0.0
- settings: 1.14.0
- sharingpath: 0.4.4
- side_menu: 5.1.1
- spreed: 21.1.2
- suspicious_login: 9.0.1
- systemtags: 1.21.1
- tables: 0.9.5
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- theming_customcss: 1.18.0
- thesearchpage: 1.2.12
- timemanager: 0.3.18
- timetracker: 0.0.85
- twofactor_admin: 4.8.0
- twofactor_backupcodes: 1.20.0
- twofactor_nextcloud_notification: 5.0.0
- twofactor_totp: 13.0.0-dev.0
- updatenotification: 1.21.0
- uppush: 2.3.0
- user_status: 1.11.0
- user_usage_report: 2.0.0
- viewer: 4.0.0
- weather: 1.7.7
- weather_status: 1.11.0
- webhook_listeners: 1.2.0
- welcome: 1.3.0
- workflow_media_converter: 1.15.1
- workflow_ocr: 1.31.2
- workflow_pdf_converter: 2.0.0
- workflow_script: 2.0.0
- workflowengine: 2.13.0
Disabled: - assistant: 2.5.0 (installed 2.5.0)
- carnet: 0.25.6 (installed 0.25.6)
- collectives: 3.0.3 (installed 3.0.3)
- cospend: 3.0.11 (installed 3.0.11)
- drawio: 3.1.0 (installed 3.1.0)
- duplicatefinder: 1.7.3 (installed 1.7.3)
- electronicsignatures: 3.0.5 (installed 3.0.5)
- encryption: 2.19.0 (installed 2.19.0)
- end_to_end_encryption: 1.17.0 (installed 1.17.0)
- epubreader: 1.4.7 (installed 1.4.7)
- extract: 1.3.6 (installed 1.3.6)
- federation: 1.21.0 (installed 1.17.0)
- files_accesscontrol: 2.0.0 (installed 2.0.0)
- files_antivirus: 6.0.2 (installed 6.0.2)
- files_archive: 1.2.7 (installed 1.2.7)
- files_mindmap: 0.0.33 (installed 0.0.33)
- files_rightclick: 0.15.1 (installed 0.15.1)
- files_scripts: 4.1.0 (installed 4.1.0)
- files_trackdownloads: 1.11.0 (installed 1.11.0)
- files_zip: 2.1.0 (installed 2.1.0)
- flowupload: 1.1.3 (installed 1.1.3)
- forms: 5.1.2 (installed 5.1.2)
- google_synchronization: 3.2.0 (installed 3.2.0)
- hsts: 0.9.0 (installed 0.9.0)
- integration_openai: 3.7.1 (installed 3.7.1)
- integration_reddit: 2.1.0 (installed 2.1.0)
- integration_twitter: 1.0.7 (installed 1.0.7)
- libresign: 11.2.5 (installed 11.2.5)
- mediadc: 0.4.0 (installed 0.4.0)
- money: 0.30.0 (installed 0.30.0)
- ncdownloader: 1.0.23 (installed 1.0.23)
- ocdownloader: 1.9.1 (installed 1.9.1)
- ocsms: 2.2.0 (installed 2.2.0)
- officeonline: 3.1.0 (installed 3.1.0)
- pride_flags: 1.1.2 (installed 1.1.2)
- profiler: 1.6.0 (installed 1.6.0)
- ransomware_protection: 1.14.0 (installed 1.14.0)
- richdocuments: 8.7.3 (installed 8.7.3)
- riotchat: 0.19.0 (installed 0.19.0)
- root_cache_cleaner: 0.1.8 (installed 0.1.8)
- sharebymail: 1.21.0 (installed 1.17.0)
- socialsharing_email: 3.3.0 (installed 3.3.0)
- storj: 0.0.9 (installed 0.0.9)
- support: 3.0.0 (installed 1.10.0)
- survey_client: 3.0.0 (installed 1.15.0)
- twofactor_gateway: 0.20.0 (installed 0.20.0)
- unsplash: 3.1.0 (installed 3.1.0)
- user_ldap: 1.22.0 (installed 1.17.0)
- video_converter: 1.0.6 (installed 1.0.6)
- webhooks: 0.4.3 (installed 0.4.3)
Nextcloud configuration:
Details
{
"system": {
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"nextcloud.solonovamax.gay",
"nextcloud.solonovamax.ca",
"86.48.27.44"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"version": "31.0.7.1",
"dbtype": "mysql",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"dbtableprefix": "oc_",
"installed": true,
"default_language": "en",
"force_language": false,
"default_locale": "en_US",
"default_phone_region": "CA",
"force_locale": false,
"defaultapp": "dashboard,files",
"knowledgebaseenabled": true,
"allow_user_to_change_display_name": true,
"remember_login_cookie_lifetime": 1296000,
"session_lifetime": 86400,
"session_relaxed_expiry": true,
"session_keepalive": true,
"auto_logout": false,
"token_auth_enforced": false,
"token_auth_activity_update": 300,
"auth.bruteforce.protection.enabled": true,
"auth.webauthn.enabled": true,
"twofactor_enforced": false,
"twofactor_enforced_groups": [
"admin"
],
"twofactor_enforced_excluded_groups": [],
"auth.storeCryptedPassword": true,
"hide_login_form": false,
"skeletondirectory": "\/var\/www\/nextcloud\/data\/skeleton",
"overwriteprotocol": "https",
"overwritehost": "nextcloud.solonovamax.gay",
"overwritewebroot": "\/",
"overwrite.cli.url": "https:\/\/nextcloud.solonovamax.gay\/",
"htaccess.RewriteBase": "\/",
"htaccess.IgnoreFrontController": false,
"trashbin_retention_obligation": "auto",
"versions_retention_obligation": "auto",
"appcodechecker": true,
"updatechecker": true,
"updater.server.url": "***REMOVED SENSITIVE VALUE***",
"updater.release.channel": "stable",
"has_internet_connection": true,
"connectivity_check_domains": [
"www.nextcloud.com",
"www.startpage.com",
"www.eff.org",
"www.edri.org"
],
"check_for_working_wellknown_setup": true,
"check_for_working_htaccess": true,
"check_data_directory_permissions": true,
"config_is_read_only": false,
"log_type": "file",
"log_type_audit": "file",
"logfile": "\/var\/log\/nextcloud\/nextcloud.log",
"logfile_audit": "\/var\/log\/nextcloud\/audit.log",
"logfilemode": 416,
"loglevel": 2,
"loglevel_frontend": 2,
"syslog_tag": "Nextcloud",
"syslog_tag_audit": "Nextcloud",
"logdateformat": "F d, Y H:i:s",
"logtimezone": "America\/Toronto",
"log_query": true,
"log_rotate_size": 104857600,
"profiler": false,
"customclient_desktop": "https:\/\/nextcloud.com\/install\/#install-clients",
"customclient_android": "https:\/\/play.google.com\/store\/apps\/details?id=com.nextcloud.client",
"customclient_ios": "https:\/\/itunes.apple.com\/us\/app\/nextcloud\/id1125420102?mt=8",
"customclient_ios_appid": "1125420102",
"appstoreenabled": true,
"appstoreurl": "https:\/\/apps.nextcloud.com\/api\/v1",
"apps_paths": [
{
"path": "\/var\/www\/nextcloud\/apps",
"url": "\/apps",
"writable": true
}
],
"enable_previews": true,
"preview_format": "webp",
"preview_concurrency_all": 4,
"preview_concurrency_new": 2,
"preview_max_x": 4096,
"preview_max_y": 4096,
"preview_max_filesize_image": 128,
"preview_max_memory": 512,
"preview_libreoffice_path": "\/usr\/bin\/libreoffice",
"preview_imaginary_url": "***REMOVED SENSITIVE VALUE***",
"preview_ffmpeg_path": "\/usr\/bin\/ffmpeg",
"enabledPreviewProviders": [
"OC\\Preview\\Imaginary",
"OC\\Preview\\ImaginaryPDF",
"OC\\Preview\\Movie",
"OC\\Preview\\MP4",
"OC\\Preview\\TXT",
"OC\\Preview\\MarkDown",
"OC\\Preview\\PDF",
"OC\\Preview\\OpenDocument",
"OC\\Preview\\Office",
"OC\\Preview\\MSOffice2007",
"OC\\Preview\\MSOffice2003",
"OC\\Preview\\MSOfficeDoc",
"OC\\Preview\\EMF",
"OC\\Preview\\StarOffice",
"OC\\Preview\\Illustrator",
"OC\\Preview\\Photoshop",
"OC\\Preview\\Postscript",
"OC\\Preview\\Krita",
"OC\\Preview\\Font",
"OC\\Preview\\TIFF",
"OC\\Preview\\HEIC",
"OC\\Preview\\WebP",
"OC\\Preview\\JPEG",
"OC\\Preview\\PNG",
"OC\\Preview\\GIF",
"OC\\Preview\\SVG",
"OC\\Preview\\BMP",
"OC\\Preview\\XBitmap",
"OC\\Preview\\TGA",
"OC\\Preview\\SGI",
"OC\\Preview\\Image"
],
"maintenance": false,
"maintenance_window_start": 1,
"memcache.local": "\\OC\\Memcache\\APCu",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0,
"read_timeout": 100
},
"memcached_options": {
"14": 50,
"15": 50,
"19": 50,
"20": 50,
"8": 50,
"-1001": true,
"16": true,
"18": true
},
"cache_chunk_gc_ttl": 86400,
"sharing.enable_share_accept": true,
"mysql.utf8mb4": true,
"share_folder": "\/Share\/",
"theme": "",
"cipher": "AES-256-CTR",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"forwarded_for_headers": [
"HTTP_X_FORWARDED",
"HTTP_FORWARDED_FOR",
"HTTP_X_FORWARDED_FOR",
"HTTP_X_REAL_IP"
],
"max_filesize_animated_gifs_public_sharing": 10,
"filelocking.enabled": true,
"filelocking.ttl": 7200,
"filelocking.debug": false,
"enable_file_metadata": true,
"app_install_overwrite": [
"files_trackdownloads",
"epubreader",
"mindmap_app",
"pdfdraw",
"ocsms",
"occweb",
"files_markdown",
"impersonate",
"files_readmemd",
"duplicatefinder",
"apporder",
"breezedark",
"files_downloadactivity",
"carnet",
"workflow_media_converter",
"google_synchronization",
"libresign",
"messagevault",
"timetracker",
"weather",
"files_fulltextsearch_tesseract",
"files_texteditor",
"files_rightclick",
"sharingpath",
"richdocuments",
"integration_moodle",
"health"
],
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtpauthtype": "PLAIN",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "1025",
"mail_smtpauth": 1,
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"memories.exiftool": "\/usr\/bin\/exiftool",
"has_rebuilt_cache": true,
"memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64",
"memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
"memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
"activity_expire_days": 90,
"debug": false,
"allow_local_remote_servers": true,
"memories.vod.disable": false,
"memories.db.triggers.fcu": true,
"memories.gis_type": 1,
"memories.timeline.default_path": "_empty_",
"memories.viewer.high_res_cond_default": "zoom",
"memories.vod.vaapi": false,
"memories.vod.vaapi.low_power": false,
"memories.exiftool_no_local": true
}
}Server log (data/nextcloud.log)
Formatted Log JSON
{
"reqId": "xEsKtXDU15b3sJJluWTB",
"level": 3,
"time": "2025-08-03T18:25:09-04:00",
"remoteAddr": "",
"user": "--",
"app": "no app in context",
"method": "",
"url": "/cron.php",
"message": "DB QueryBuilder: error trying to log SQL query",
"userAgent": "--",
"version": "31.0.7.1",
"exception": {
"Exception": "Error",
"Message": "Object of class DateTimeImmutable could not be converted to string",
"Code": 0,
"Trace": [
{
"file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 284,
"function": "prepareForExecute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/spreed/lib/Manager.php",
"line": 966,
"function": "executeQuery",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/spreed/lib/BackgroundJob/ExpireObjectRooms.php",
"line": 55,
"function": "getExpiringRoomsForObjectType",
"class": "OCA\\Talk\\Manager",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/spreed/lib/BackgroundJob/ExpireObjectRooms.php",
"line": 48,
"function": "executeRetention",
"class": "OCA\\Talk\\BackgroundJob\\ExpireObjectRooms",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/public/BackgroundJob/Job.php",
"line": 61,
"function": "run",
"class": "OCA\\Talk\\BackgroundJob\\ExpireObjectRooms",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
"line": 97,
"function": "start",
"class": "OCP\\BackgroundJob\\Job",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php",
"line": 84,
"function": "start",
"class": "OCP\\BackgroundJob\\TimedJob",
"type": "->"
},
{
"file": "/var/www/nextcloud/cron.php",
"line": 170,
"function": "execute",
"class": "OCP\\BackgroundJob\\TimedJob",
"type": "->"
}
],
"File": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"Line": 169,
"message": "DB QueryBuilder: error trying to log SQL query",
"exception": [],
"CustomMessage": "DB QueryBuilder: error trying to log SQL query"
},
"id": "688fe902576cf"
}If needed, I can provide surrounding log messages.