Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2020-05-22 23:02:44.230525 [NOTICE] switch_cpp.cpp:1447 [voicemail] SQL: SELECT * FROM v_domains WHERE domain_name = :domain_name; params:{"domain_name":"neotech"}
- 2020-05-22 23:02:44.230525 [NOTICE] switch_cpp.cpp:1447 [voicemail] SQL: SELECT * FROM v_voicemails
- WHERE domain_uuid = :domain_uuid
- AND voicemail_id = :voicemail_id; params:{"domain_uuid":"b1a1c390-dfc4-4ddb-8bbb-ae93e0d93c24"}
- 2020-05-22 23:02:44.230525 [ERR] switch_cpp.cpp:1447 [database] can not bind parameter: undefined parameter: voicemail_id
- 2020-05-22 23:02:44.230525 [NOTICE] switch_cpp.cpp:1447 [voicemail] SQL: SELECT extension, number_alias from v_extensions
- WHERE domain_uuid = :domain_uuid
- AND (
- mwi_account = :voicemail_id
- or mwi_account = :mwi_account
- or number_alias = :voicemail_id
- ); params:{"voicemail_id":"151","domain_uuid":"b1a1c390-dfc4-4ddb-8bbb-ae93e0d93c24","mwi_account":"151@neotech"}
- 2020-05-22 23:02:44.230525 [NOTICE] switch_cpp.cpp:1447 [voicemail-count] SQL: SELECT
- ( SELECT count(*)
- FROM v_voicemail_messages as m inner join v_voicemails as v
- on v.voicemail_uuid = m.voicemail_uuid
- WHERE v.voicemail_id = :voicemail_id AND v.domain_uuid = :domain_uuid
- AND (m.message_status is null or m.message_status = '')
- ) as new_messages,
- ( SELECT count(*)
- FROM v_voicemail_messages as m inner join v_voicemails as v
- on v.voicemail_uuid = m.voicemail_uuid
- WHERE v.voicemail_id = :voicemail_id AND v.domain_uuid = :domain_uuid
- AND m.message_status = 'saved'
- ) as saved_messages
- ; params: {"voicemail_id":"151","domain_uuid":"b1a1c390-dfc4-4ddb-8bbb-ae93e0d93c24"}
- 2020-05-22 23:02:44.270537 [NOTICE] switch_cpp.cpp:1447 [voicemail-count] mailbox: 151 messages: 157/8
- 2020-05-22 23:02:44.270537 [NOTICE] switch_cpp.cpp:1447 [voicemail] mailbox: 151@neotech messages: 157 new message(s)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement