[Spce-user] Voicemail Folders

Daniel Tiefnig dtiefnig at sipwise.com
Tue Oct 11 17:36:49 EDT 2011


On 10/11/2011 09:24 PM, Jonathan Scott wrote:
> The one thing I did manually change in the database was in
> voicemail_spool the table structure was not correct and you could not
> record your own greetings... other than that, I have not touched
> anything.

Well, so how did you change it? Can you send the SQL statement(s) you
have used? The output of "show create table voicemail_spool;" could also
be helpful.

Further you could check if the entries in the voicemail_users table are
correct. Does every entry have a UUID in the customer_id column? Do
these match to UUIDs in the subscriber table?
You can do a quick check with the following three statements, all should
output the same value:

select count(*) from subscriber;

select count(*) from voicemail_users;

select count(*) from subscriber
        inner join voicemail_users on uuid = customer_id;

br,
daniel




More information about the Spce-user mailing list