Re: [asterisk-users] RealTime Queue Logging in 1.8

2011-06-07 Thread Ishfaq Malik
Thanks for that, the table got created. Should be plain sailing from here on :) Ish 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

Re: [asterisk-users] RealTime Queue Logging in 1.8

2011-06-07 Thread Ishfaq Malik
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,

Re: [asterisk-users] RealTime Queue Logging in 1.8

2011-06-06 Thread Ishfaq Malik
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

Re: [asterisk-users] RealTime Queue Logging in 1.8

2011-06-06 Thread Satish Barot
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),

[asterisk-users] RealTime Queue Logging in 1.8

2011-06-02 Thread Ishfaq Malik
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 -- Ishfaq Malik Software Developer PackNet Ltd Office: 0161 660 3062 --