2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] message length: 7
AND voicemail_message_uuid = :uuid; params:{"uuid":"abc57a52-1e55-4d01-b9f1-839831d251b0","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
WHERE domain_uuid = :domain_uuid
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT * FROM v_voicemail_messages
AND voicemail_id = :voicemail_id; params:{"voicemail_id":"1001","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
WHERE domain_uuid = :domain_uuid
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT * FROM v_voicemails
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] mailbox: 1001@pbx.example.com messages: 1 new message(s)
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail-count] mailbox: 1001 messages: 1/0
; params: {"voicemail_id":"1001","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
) as saved_messages
AND m.message_status = 'saved'
WHERE v.voicemail_id = :voicemail_id AND v.domain_uuid = :domain_uuid
on v.voicemail_uuid = m.voicemail_uuid
FROM v_voicemail_messages as m inner join v_voicemails as v
( SELECT count(*)

) as new_messages,
AND (m.message_status is null or m.message_status = '')
WHERE v.voicemail_id = :voicemail_id AND v.domain_uuid = :domain_uuid
on v.voicemail_uuid = m.voicemail_uuid
FROM v_voicemail_messages as m inner join v_voicemails as v
( SELECT count(*)
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail-count] SQL: SELECT
); params:{"mwi_account":"1001@pbx.example.com","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b","voicemail_id":"1001"}
or number_alias = :voicemail_id
or mwi_account = :mwi_account
mwi_account = :voicemail_id
AND (
WHERE domain_uuid = :domain_uuid
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT extension, number_alias from v_extensions
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT voicemail_id FROM v_voicemails WHERE voicemail_uuid = :voicemail_uuid; params:{"voicemail_uuid":"690c5867-51db-423d-ac42-725e380d8106","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
AND message_status = 'saved' ; params:{"voicemail_uuid":"690c5867-51db-423d-ac42-725e380d8106","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
AND voicemail_uuid = :voicemail_uuid
WHERE domain_uuid = :domain_uuid
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT count(*) as saved_messages FROM v_voicemail_messages
AND (message_status is null or message_status = '') ; params:{"voicemail_uuid":"690c5867-51db-423d-ac42-725e380d8106","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b"}
AND voicemail_uuid = :voicemail_uuid
WHERE domain_uuid = :domain_uuid
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: SELECT count(*) as new_messages FROM v_voicemail_messages
2017-03-02 10:52:13.105210 [ERR] switch_cpp.cpp:1366 [database] can not bind parameter: undefined parameter: transcription
) ; params:{"start_epoch":1488469923,"caller_id_name":"2002","domain_uuid":"2c68414e-9cf3-4d1c-a1bc-f5d6a672284b","message_length":7,"voicemail_uuid":"690c5867-51db-423d-ac42-725e380d8106","voicemail_message_uuid":"abc57a52-1e55-4d01-b9f1-839831d251b0","caller_id_number":"2002"}
:message_length
:transcription,
:caller_id_number,
:caller_id_name,
:start_epoch,
:voicemail_uuid,
:domain_uuid,
:voicemail_message_uuid,
(
VALUES
)
message_length
message_transcription,
caller_id_number,
caller_id_name,
created_epoch,
voicemail_uuid,
domain_uuid,
voicemail_message_uuid,
(
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail] SQL: INSERT INTO v_voicemail_messages
2017-03-02 10:52:13.105210 [NOTICE] switch_cpp.cpp:1366 [voicemail]
abc57a52-1e55-4d01-b9f1-839831d251b0 2017-03-02 10:52:13.105210 [DEBUG] mod_hash.c:297 Usage for pbx.example.com_1001 is now 0