Hello and thank you for this great product, I have installed two fusion PBX on Debian 9 remote server and all have the same problem.
I can't delete any domain, I have just this on postgresql logs:
2019-04-23 16:09:37.615 UTC [13538] fusionpbx@fusionpbx ERROR: relation "v_sms_messages" does not exist at character 13
2019-04-23 16:09:37.615 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_sms_messages where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_sms_destinations where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_streams where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_greetings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemails where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_messages where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_destinations where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_options where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_webrtc where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_webrtc where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_xml_cdr where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_xmpp where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_domains where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_domain_settings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_groups where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_group_users where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_group_permissions where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_users where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_user_settings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
I can't delete any domain, I have just this on postgresql logs:
2019-04-23 16:09:37.615 UTC [13538] fusionpbx@fusionpbx ERROR: relation "v_sms_messages" does not exist at character 13
2019-04-23 16:09:37.615 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_sms_messages where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_sms_destinations where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_streams where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_greetings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemails where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_messages where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.616 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_destinations where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_voicemail_options where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_webrtc where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_webrtc where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_xml_cdr where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_xmpp where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.617 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_domains where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_domain_settings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_groups where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_group_users where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_group_permissions where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_users where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx ERROR: current transaction is aborted, commands ignored until end of transaction block
2019-04-23 16:09:37.618 UTC [13538] fusionpbx@fusionpbx STATEMENT: delete from v_user_settings where domain_uuid = '8243e736-c86a-40c6-ad8b-3641a581a683'
Last edited: