Realtime table queue_log@asterisk: Column time cannot be a datetime Works fine once the time column is turned to char...
On Tue, 2011-06-07 at 10:43 +0530, Satish Barot wrote: > > I use following for MySQL... > > CREATE TABLE queue_log( > id int(11) NOT NULL auto_increment, > time datetime not null, > queuename VARCHAR(50), > agent VARCHAR(50), > callid varchar(32), > event VARCHAR(100), > data1 VARCHAR(100), > data2 VARCHAR(100), > data3 VARCHAR(100), > data4 VARCHAR(100), > data5 VARCHAR(100), > PRIMARY KEY (id) > ) ENGINE=InnoDB ; > > > Check the link to know the meaning of data1,data2... for Events. > http://www.voip-info.org/wiki/view/Asterisk+log+queue_log > > [SATISH] > > > On Mon, Jun 6, 2011 at 1:49 PM, Ishfaq Malik <i...@pack-net.co.uk> > wrote: > On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: > > Hi Does anyone know of an accurate resource I could refer to > for this? > > > > The best I can find is > > > > http://www.voip-info.org/wiki/view/Asterisk+queue_log+on > +MySQL > > > > And that table wont create in my database... > > > > Thanks > > > > Ish > > > Can someone at least point me to the source file that I can > analyse to > find out the table requirements? > > Ish > > -- > Ishfaq Malik > Software Developer > PackNet Ltd > > Office: 0161 660 3062 > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by > http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every > Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users