Call history error Unknown field: disposition
Hello,
first of all sorry for my english.
I recently installed fop2 on a Asterisk 13.11.2 and FreePBX 13.0.190. By reading various posts I created a new user called fop2 in asterisk manager_custom.conf, I modified the fop2.cfg files in / usr / local / fop2 with the credentials of 'fop2 user'
so far so good, giving the command / usr / local / fop2 / fop2_server --test, I get:
Flash Operator Panel 2 - fop2.lic License file not found.
Running in Demo Mode
Connection manager to OK!
I can see the extensions, everything works fine, it is really an excellent software.
My problem is the call history. I have the guaranteed access to asteriskcdrdb.cdr with:
GRANT ALL PRIVILEGES ON asteriskcdrdb. * To fop2 @ localhost identified by 'XXXXX'.
I also changed the file
showcdr.php: $ grid-> set_table ( 'asteriskcdrdb.cdr'); and
phonetabs.php: $ res = $ db-> check ( "DESC asteriskcdrdb.cdr");
Unfortunately I can not see the call history, the error is:
An error has occurred
Unknown field: disposition
Unknown field: calldate.
If I open the files http: //x.x.x.x/fop2/phonetabs.php and http: //x.x.x.x/fop2/showcdr.php, I can see the call history and the phonebook.
If I install the call history plugin, the error is the same.
I do not know where to look to solve, please help me, I do not have enough experience.
Thanks so much
first of all sorry for my english.
I recently installed fop2 on a Asterisk 13.11.2 and FreePBX 13.0.190. By reading various posts I created a new user called fop2 in asterisk manager_custom.conf, I modified the fop2.cfg files in / usr / local / fop2 with the credentials of 'fop2 user'
so far so good, giving the command / usr / local / fop2 / fop2_server --test, I get:
Flash Operator Panel 2 - fop2.lic License file not found.
Running in Demo Mode
Connection manager to OK!
I can see the extensions, everything works fine, it is really an excellent software.
My problem is the call history. I have the guaranteed access to asteriskcdrdb.cdr with:
GRANT ALL PRIVILEGES ON asteriskcdrdb. * To fop2 @ localhost identified by 'XXXXX'.
I also changed the file
showcdr.php: $ grid-> set_table ( 'asteriskcdrdb.cdr'); and
phonetabs.php: $ res = $ db-> check ( "DESC asteriskcdrdb.cdr");
Unfortunately I can not see the call history, the error is:
An error has occurred
Unknown field: disposition
Unknown field: calldate.
If I open the files http: //x.x.x.x/fop2/phonetabs.php and http: //x.x.x.x/fop2/showcdr.php, I can see the call history and the phonebook.
If I install the call history plugin, the error is the same.
I do not know where to look to solve, please help me, I do not have enough experience.
Thanks so much
Comments
thank you so much