SOLVED Domain delete error

[comdif]

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'

 

[comdif]

I understain the problem is a bug on sms app code.

The SMS install code create a table v and not a v_sms_messages, if I create v_sms_messages and v_sms_destinations manualy my problem is
solved and I can delete domains.

CREATE TABLE v (
sms_message_uuid uuid PRIMARY KEY,
extension_uuid uuid,
domain_uuid uuid,
start_stamp timestamp,
from_number text,
to_number text,
message text,
direction text,
response text,
carrier text);