[asterisk-bugs] [Asterisk 0016016]: fullcontact not updated in database

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16016 
====================================================================== 
Reported By:                rossbeer
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16016
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.1.6 
JIRA:                        
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-10-03 14:27 CDT
Last Modified:              2009-10-04 06:49 CDT
====================================================================== 
Summary:                    fullcontact not updated in database
Description: 
The fullcontact field is not updated in the realtime database. All other
fields are updated correctly.


====================================================================== 

---------------------------------------------------------------------- 
 (0111825) rossbeer (reporter) - 2009-10-04 06:49
 https://issues.asterisk.org/view.php?id=16016#c111825 
---------------------------------------------------------------------- 
CREATE TABLE  `asterisk`.`sipregs` (
  `name` varchar(10) NOT NULL,
  `ipaddr` char(15) DEFAULT NULL,
  `port` smallint(5) unsigned DEFAULT NULL,
  `regseconds` int(10) DEFAULT NULL,
  `defaultuser` char(10) DEFAULT NULL,
  `fullcontact` char(35) DEFAULT NULL,
  `regserver` char(20) DEFAULT NULL,
  `useragent` char(32) DEFAULT NULL,
  `lastms` int(10) DEFAULT NULL,
  `username` char(20) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

There are no messages, but every other coloum is updated. However the
regserver is not updated either though it is set in sip.conf and
asterisk.conf

Also this is also the case if 'sipregs' realtime table is not used. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-10-04 06:49 rossbeer       Note Added: 0111825                          
======================================================================