[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-14 21:19 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
====================================================================== 

---------------------------------------------------------------------- 
 (0096371) qualleyiv (reporter) - 2008-12-14 21:19
 http://bugs.digium.com/view.php?id=14002#c96371 
---------------------------------------------------------------------- 
Ok, here's a failure log:

[Dec 13 18:06:58] VERBOSE[148] pbx.c:   == Spawn extension (smitten,
14027309248, 3) exited non-zero on 'Local/14027309248 at smitten-1b6a;2'
[Dec 13 18:06:58] ERROR[148] cdr_addon_mysql.c: Failed to insert into
database: (1136) Column count doesn't match value count at row 1
[Dec 13 18:06:58] NOTICE[148] cdr_addon_mysql.c: Failing SQL: INSERT INTO
cdr () VALUES ('')

Here's the cdr_mysql.conf:

[global]
hostname=localhost
dbname=asterisk
table=cdr
;password=
user=asterisk
;port=3306
sock=/var/mysql/mysql.sock


Note that I've got the mysql asterisk user setup so it does not require a
password. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-14 21:19 qualleyiv      Note Added: 0096371                          
======================================================================