asterisk users - Jan 2005 - ASTCC - error on call end

Hi

I get an error popping up when the call ends as follows:


DBD::mysql::db do failed: Unknown column 'callstart' in 'field
list' at
/var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 32.

Does anyone else get this same thing?
Looks as if my database table is wrong, or something else is 
up...not sure

Thanks
Clive

There is a field missing in the admin.cgi CREATE for cdrs.

add: callstart CHAR(24) to the cdrs table

There is a patch to fix the cgi at

http://bugs.digium.com/bug_view_page.php?bug_id=0002796 

It just hasn't made it through to CVS yet.


Karl Putz
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com]On Behalf Of
> clive@sentechsa.com
> Sent: Tuesday, January 11, 2005 9:45 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [Asterisk-Users] ASTCC - error on call end
> 
> 
> Hi
> 
> I get an error popping up when the call ends as follows:
> 
> 
> DBD::mysql::db do failed: Unknown column 'callstart' in 'field
list' at
> /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 32.
> 
> Does anyone else get this same thing?
> Looks as if my database table is wrong, or something else is 
> up...not sure
> 
> Thanks
> Clive
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
>

There is a bug in the database creation line.  Add a field 'callstart'  
CHAR (24) and it should work.

Darren

clive@sentechsa.com wrote:
>Hi
>
>I get an error popping up when the call ends as follows:
>
>
>DBD::mysql::db do failed: Unknown column 'callstart' in 'field
list' at
>/var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 32.
>
>Does anyone else get this same thing?
>Looks as if my database table is wrong, or something else is 
>up...not sure
>
>Thanks
>Clive
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users@lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>  
>