Cannot delete contact (with postgres) #1903
Description
Describe the bug
Cannot delete a contact.
To Reproduce
- Install admidio with postgres backend
- Create a contact
- Delete the contact
- See error
Expected behavior
The contact is deleted.
System (please complete the following information):
- Admidio v5.0.0
- Database [PostgreSQL]
Additional context
the log
admidio-psql | 2025-11-16 12:21:35.177 CET [246] ERROR: relation "adm_guestbook_comments" does not exist at character 13
admidio-psql | 2025-11-16 12:21:35.177 CET [246] STATEMENT: DELETE FROM adm_guestbook_comments
admidio-psql | WHERE gbc_usr_id_create = 3
admidio-psql | 2025-11-16 12:21:35.177 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.177 CET [246] STATEMENT: DEALLOCATE pdo_stmt_00000025
admidio-psql | 2025-11-16 12:21:35.177 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.177 CET [246] STATEMENT: DELETE FROM adm_members
admidio-psql | WHERE mem_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.177 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.177 CET [246] STATEMENT: DELETE FROM adm_ids
admidio-psql | WHERE ids_usr_id = 2
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-app | [Sun Nov 16 12:21:35.180330 2025] [php:error] [pid 170] [client 185.125.190.39:57053] PHP Fatal error: Uncaught Error: Call to a member function rowCount() on false in /opt/app-root/src/src/Infrastructure/Email.php:273\nStack trace:\n#0 /opt/app-root/src/src/Infrastructure/Email.php(806): Admidio\\Infrastructure\\Email->addRecipientsByRole()\n#1 /opt/app-root/src/src/Infrastructure/ChangeNotification.php(484): Admidio\\Infrastructure\\Email->sendNotification()\n#2 /opt/app-root/src/src/Infrastructure/ChangeNotification.php(505): Admidio\\Infrastructure\\ChangeNotification->sendNotifications()\n#3 [internal function]: Admidio\\Infrastructure\\ChangeNotification->shutdown()\n#4 {main}\n thrown in /opt/app-root/src/src/Infrastructure/Email.php on line 273, referer: http://localhost:3100/modules/contacts/contacts.php
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: INSERT INTO adm_ids
admidio-app | 185.125.190.39 - - [16/Nov/2025:12:21:35 +0100] "POST /modules/contacts/contacts_function.php?mode=delete&user_uuid=08a1eec8-076d-4766-a990-8aeb1a685c09 HTTP/1.1" 500 76
admidio-psql | (ids_usr_id, ids_reference_id)
admidio-psql | SELECT 2, msc_msg_id
admidio-psql | FROM adm_messages_content
admidio-psql | WHERE msc_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_messages_content
admidio-psql | WHERE msc_msg_id IN (SELECT ids_reference_id
admidio-psql | FROM adm_ids
admidio-psql | WHERE ids_usr_id = 2)
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_messages_recipients
admidio-psql | WHERE msr_msg_id IN (SELECT ids_reference_id
admidio-psql | FROM adm_ids
admidio-psql | WHERE ids_usr_id = 2)
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_messages
admidio-psql | WHERE msg_id IN (SELECT ids_reference_id
admidio-psql | FROM adm_ids
admidio-psql | WHERE ids_usr_id = 2)
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_ids
admidio-psql | WHERE ids_usr_id = 2
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_messages_recipients
admidio-psql | WHERE msr_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.178 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.178 CET [246] STATEMENT: DELETE FROM adm_messages_content
admidio-psql | WHERE NOT EXISTS (SELECT 1 FROM adm_messages_recipients
admidio-psql | WHERE msr_msg_id = msc_msg_id)
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DELETE FROM adm_messages
admidio-psql | WHERE NOT EXISTS (SELECT 1 FROM adm_messages_recipients
admidio-psql | WHERE msr_msg_id = msg_id)
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DELETE FROM adm_registrations
admidio-psql | WHERE reg_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DELETE FROM adm_auto_login
admidio-psql | WHERE atl_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DELETE FROM adm_sessions
admidio-psql | WHERE ses_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DELETE FROM adm_user_data
admidio-psql | WHERE usd_usr_id = 3
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: SELECT column_name, column_default, is_nullable, data_type,
admidio-psql | (SELECT 'YES' from information_schema.key_column_usage kcu
admidio-psql | WHERE kcu.table_name = c.table_name
admidio-psql | and kcu.column_name = c.column_name ) as key
admidio-psql | FROM information_schema.columns c
admidio-psql | WHERE table_name = $1
admidio-psql | 2025-11-16 12:21:35.179 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.179 CET [246] STATEMENT: DEALLOCATE pdo_stmt_00000010
admidio-psql | 2025-11-16 12:21:35.180 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.180 CET [246] STATEMENT: SELECT first_name.usd_value AS firstname, last_name.usd_value AS lastname, email.usd_value AS email
admidio-psql | FROM adm_members mem
admidio-psql | INNER JOIN adm_roles
admidio-psql | ON rol_id = mem_rol_id
admidio-psql | INNER JOIN adm_categories
admidio-psql | ON cat_id = rol_cat_id
admidio-psql | INNER JOIN adm_users
admidio-psql | ON usr_id = mem_usr_id
admidio-psql | INNER JOIN adm_user_data AS email
admidio-psql | ON email.usd_usr_id = usr_id
admidio-psql | AND LENGTH(email.usd_value) > 0
admidio-psql | INNER JOIN adm_user_fields AS field
admidio-psql | ON field.usf_id = email.usd_usf_id
admidio-psql | AND field.usf_type = 'EMAIL'
admidio-psql |
admidio-psql | LEFT JOIN adm_user_data AS last_name
admidio-psql | ON last_name.usd_usr_id = usr_id
admidio-psql | AND last_name.usd_usf_id = $1 -- $gProfileFields->getProperty('LAST_NAME', 'usf_id')
admidio-psql | LEFT JOIN adm_user_data AS first_name
admidio-psql | ON first_name.usd_usr_id = usr_id
admidio-psql | AND first_name.usd_usf_id = $2 -- $gProfileFields->getProperty('FIRST_NAME', 'usf_id')
admidio-psql | WHERE rol_uuid = $3 -- $roleUuid
admidio-psql | AND ( cat_org_id = $4 -- $gCurrentOrgId
admidio-psql | OR cat_org_id IS NULL )
admidio-psql | AND usr_valid = true
admidio-psql | AND mem_begin <= $5 -- DATE_NOW
admidio-psql | AND mem_end > $6 -- DATE_NOW
admidio-psql | AND usr_id <> $7 -- $gCurrentUserId
admidio-psql | 2025-11-16 12:21:35.180 CET [246] ERROR: current transaction is aborted, commands ignored until end of transaction block
admidio-psql | 2025-11-16 12:21:35.180 CET [246] STATEMENT: DEALLOCATE pdo_stmt_00000009