[asterisk-bugs] [Asterisk 0014002]: cdr_addon_mysql.c: Column count doesn't match value count

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14002 
====================================================================== 
Reported By:                qualleyiv
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   14002
Category:                   CDR/General
Reproducibility:            random
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.1-beta1 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-12-01 09:30 CST
Last Modified:              2008-12-10 22:35 CST
====================================================================== 
Summary:                    cdr_addon_mysql.c: Column count doesn't match value
count
Description: 
Things will be working just fine and then I'll sporadically receive:

[Dec  1 09:17:11] ERROR[139] cdr_addon_mysql.c: Failed to insert into
database: (1136) Column count doesn't match value count at row 1

I'm wondering if it might be/be related to this bug:
http://bugs.digium.com/view.php?id=13815
====================================================================== 

---------------------------------------------------------------------- 
 (0096173) qualleyiv (reporter) - 2008-12-10 22:35
 http://bugs.digium.com/view.php?id=14002#c96173 
---------------------------------------------------------------------- 
Here you are, please ask if you need anything else:

-- phpMyAdmin SQL Dump
-- version 3.0.0-beta
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 10, 2008 at 10:35 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `asterisk`
--

-- --------------------------------------------------------

--
-- Table structure for table `cdr`
--

CREATE TABLE `cdr` (
  `calldate` datetime NOT NULL default '0000-00-00 00:00:00',
  `clid` varchar(80) NOT NULL default '',
  `src` varchar(80) NOT NULL default '',
  `dst` varchar(80) NOT NULL default '',
  `dcontext` varchar(80) NOT NULL default '',
  `channel` varchar(80) NOT NULL default '',
  `dstchannel` varchar(80) NOT NULL default '',
  `lastapp` varchar(80) NOT NULL default '',
  `lastdata` varchar(80) NOT NULL default '',
  `duration` int(11) NOT NULL default '0',
  `billsec` int(11) NOT NULL default '0',
  `disposition` varchar(45) NOT NULL default '',
  `amaflags` int(11) NOT NULL default '0',
  `accountcode` varchar(20) NOT NULL default '',
  `userfield` varchar(255) NOT NULL default '',
  `uniqueid` varchar(32) NOT NULL,
  KEY `calldate` (`calldate`),
  KEY `dst` (`dst`),
  KEY `accountcode` (`accountcode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-10 22:35 qualleyiv      Note Added: 0096173                          
======================================================================