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 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 > lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > 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 >lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > lists.digium.com/mailman/listinfo/asterisk-users > > >