- Nextcloud Server version: 31.0.8
- Operating system and version: Debian 12
- Web server and version: nginx/1.22.1
- Reverse proxy and version: HAProxy version 3.0.11-9e587df
- PHP version: 8.3
- Is this the first time you’ve seen this error? (Yes / No): Yes
- When did this problem seem to first start? about 1 week ago
- Installation method Bare metal
- Are you using Cloudflare, mod_security, or similar? No
Summary of the issue you are facing:
I’m unable to see any of the contacts in my instance for my user. I looked at this ticket (HELP: my addressbook is gone) but had no luck.
here is the output of my query:
nextcloud=# select id, LENGTH(carddata) FROM oc_cards ORDER BY LENGTH(carddata) DESC LIMIT 10;
id | length
-----+--------
4 | 14234
2 | 13405
3 | 10405
263 | 8651
132 | 8496
258 | 7464
311 | 7252
316 | 7231
245 | 6849
308 | 6644
(10 rows)
There are no errors appearing in the log, but the address books do appear in the databse:
nextcloud=# select * from oc_addressbooks;
id | principaluri | displayname | uri | description | synctoken
----+----------------------------------------------------------------+------------------------+--------------------------------------+-----------------------------------------------------------+-----------
2 | principals/users/7094395e-2b52-103b-96be-91ddb9ee6866 | Contacts | contacts | | 1
1 | principals/system/system | system | system | System addressbook which holds all users of this instance | 44
9 | principals/users/lgwapnitsky | Sync | 5e7c1f6a-1e5d-48ba-af95-9859dd1ee151 | | 1
4 | principals/users/keycloak-0f7bda07-1548-480d-b328-9765ca8445f2 | Ham Contacts | ham-contacts | | 2
3 | principals/users/keycloak-0f7bda07-1548-480d-b328-9765ca8445f2 | Contacts | contacts | | 6
10 | principals/users/lgwapnitsky | Google Contacts import | Google Contacts import |
Steps to replicate it (hint: details matter!):
- Go to contacts (no existing ABs appear)
- Try to create a new address book
- Error appears
An error occurred, unable to create the address book
Log Entries
Nothing appears related to the contacts
Configuration
{
"system": {
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"nextcloud.wapnitsky.com"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "pgsql",
"version": "31.0.8.1",
"overwrite.cli.url": "https:\/\/10.150.88.154",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"app_install_overwrite": [
"user_saml",
"ldaporg",
"duplicatefinder",
"podcast",
"apporder",
"snappymail"
],
"filelocking.enabled": "true",
"memcache.local": "\\OC\\Memcache\\Redis",
"memcache.distributed": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0
},
"mail_smtpmode": "smtp",
"mail_smtpsecure": "ssl",
"mail_sendmailmode": "smtp",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "465",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"forwarded_for_headers": [
"HTTP_X_FORWARDED_FOR"
],
"data-fingerprint": "bb19d01d19121fb91de0eefb23ebcad7",
"maintenance": false,
"maintenance_window_start": 100,
"ncd_aria2_binary": "\/usr\/bin\/aria2c",
"loglevel": 2,
"theme": "",
"updater.release.channel": "stable",
"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",
"memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg",
"memories.vod.ffprobe": "\/usr\/bin\/ffprobe",
"enabledPreviewProviders": [
"OC\\Preview\\Image",
"OC\\Preview\\Movie"
],
"preview_max_x": 1024,
"preview_max_y": 1024,
"memories.db.triggers.fcu": true,
"default_phone_region": "US",
"twofactor_enforced": "true",
"twofactor_enforced_groups": [
"nextcloud"
],
"twofactor_enforced_excluded_groups": []
}
}
App list
Enabled:
- activity: 4.0.0
- app_api: 5.0.2
- apporder: 0.15.0
- bookmarks: 15.1.3
- bruteforcesettings: 4.0.0
- calendar: 5.3.9
- cloud_federation_api: 1.14.0
- comments: 1.21.0
- contacts: 7.2.5
- dashboard: 7.11.0
- dav: 1.33.0
- duplicatefinder: 1.7.3
- external: 6.0.2
- federatedfilesharing: 1.21.0
- federation: 1.21.0
- files: 2.3.1
- files_downloadlimit: 4.0.0
- files_external: 1.23.0
- files_pdfviewer: 4.0.0
- files_reminders: 1.4.0
- files_sharing: 1.23.1
- files_trashbin: 1.21.0
- files_versions: 1.24.0
- fileslibreofficeedit: 2.0.1
- firstrunwizard: 4.0.0
- gpoddersync: 3.12.0
- impersonate: 2.0.0
- integration_google: 4.1.0
- integration_paperless: 1.0.7
- logreader: 4.0.0
- lookup_server_connector: 1.19.0
- news: 26.1.0
- notes: 4.12.3
- notifications: 4.0.0
- oauth2: 1.19.1
- onlyoffice: 9.10.0
- password_policy: 3.0.0
- photos: 4.0.0
- privacy: 3.0.0
- profile: 1.0.0
- provisioning_api: 1.21.0
- serverinfo: 3.0.0
- settings: 1.14.0
- sharebymail: 1.21.0
- skyprint: 0.1.7
- snappymail: 2.38.2
- sociallogin: 6.0.2
- support: 3.0.0
- survey_client: 3.0.0
- suspicious_login: 9.0.1
- systemtags: 1.21.1
- tasks: 0.16.1
- text: 5.0.0
- theming: 2.6.1
- twofactor_backupcodes: 1.20.0
- updatenotification: 1.21.0
- user_status: 1.11.0
- viewer: 4.0.0
- webapppassword: 25.3.0
- webhook_listeners: 1.2.0
- workflowengine: 2.13.0
Disabled:
- admin_audit: 1.21.0
- circles: 31.0.0 (installed 30.0.0)
- contactsinteraction: 1.12.0 (installed 1.12.0)
- encryption: 2.19.0 (installed 2.18.0)
- nextcloud_announcements: 3.0.0 (installed 3.0.0)
- recommendations: 4.0.0 (installed 4.0.0)
- related_resources: 2.0.0 (installed 2.0.0)
- twofactor_nextcloud_notification: 5.0.0 (installed 5.0.0)
- twofactor_totp: 13.0.0-dev.0 (installed 13.0.0-dev.0)
- user_ldap: 1.22.0 (installed 1.22.0)
- weather_status: 1.11.0 (installed 1.11.0)
