<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
ALTER TABLE kamailio.voicemail_spool CHANGE COLUMN origtime origtime
VARCHAR(16) DEFAULT '';
ALTER TABLE kamailio.voicemail_spool CHANGE COLUMN duration duration
VARCHAR(16) DEFAULT '';
<br>
<br>
That is how it was done.<br>
<br>
show create table voicemail_spool;<br>
<table id="table_results" class="data">
<tbody>
<tr class="odd hover">
<td>voicemail_spool</td>
<td>CREATE TABLE `voicemail_spool` (<br>
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br>
`msgnum` int(11) NOT NULL DEFAULT '0',<br>
`dir` varchar(127) DEFAULT '',<br>
`context` varchar(63) DEFAULT '',<br>
`macrocontext` varchar(63) DEFAULT '',<br>
`callerid` varchar(255) DEFAULT '',<br>
`origtime` varchar(16) DEFAULT '',<br>
`duration` varchar(16) DEFAULT '',<br>
`mailboxuser` varchar(255) DEFAULT '',<br>
`mailboxcontext` varchar(63) DEFAULT '',<br>
`recording` longblob,<br>
PRIMARY KEY (`id`),<br>
KEY `dir` (`dir`),<br>
KEY `mailboxuser_idx` (`mailboxuser`),<br>
CONSTRAINT `v_s_mailboxuser_ref` FOREIGN KEY
(`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`)
ON DELETE CASCADE ON UPDATE CASCADE<br>
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=latin1</td>
</tr>
</tbody>
</table>
<br>
<br>
Every has the uuid in the customer_id table and these match in the
subscriber table as well.<br>
<br>
All three statements you provided, return the same result as you
said it should.<br>
<br>
<br>
On 10/11/2011 5:36 PM, Daniel Tiefnig wrote:
<blockquote cite="mid:4E94B6F1.8010904@sipwise.com" type="cite">On
10/11/2011 09:24 PM, Jonathan Scott wrote:
<br>
<blockquote type="cite">The one thing I did manually change in the
database was in
<br>
voicemail_spool the table structure was not correct and you
could not
<br>
record your own greetings... other than that, I have not touched
<br>
anything.
<br>
</blockquote>
<br>
Well, so how did you change it? Can you send the SQL statement(s)
you
<br>
have used? The output of "show create table voicemail_spool;"
could also
<br>
be helpful.
<br>
<br>
Further you could check if the entries in the voicemail_users
table are
<br>
correct. Does every entry have a UUID in the customer_id column?
Do
<br>
these match to UUIDs in the subscriber table?
<br>
You can do a quick check with the following three statements, all
should
<br>
output the same value:
<br>
<br>
select count(*) from subscriber;
<br>
<br>
select count(*) from voicemail_users;
<br>
<br>
select count(*) from subscriber
<br>
inner join voicemail_users on uuid = customer_id;
<br>
<br>
br,
<br>
daniel
<br>
<br>
_______________________________________________
<br>
Spce-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Jonathan Scott Knox
Systems Administrator
XATel Communication
7 Green Street, Biddeford ME. 04005
(207)391.1000 (Mon - Thur, 9AM - 6PM. Friday - 9AM - 5PM.)</pre>
</body>
</html>