Table 'asterisk.recording_log' doesn't exist

Added by IT Admin 24 days ago

Hi Team,

i have installed Goautodial 3.3 recently. Everything was working fine until yesterday. When i search for call recordings under Lead Search it shows the following error.

Error Number: 1146

Table 'asterisk.recording_log' doesn't exist

SELECT `recording_id`, `channel`, `server_ip`, `extension`, `start_time`, `start_epoch`, `end_time`, `end_epoch`, `length_in_sec`, `length_in_min`, `filename`, `location`, `lead_id`, `user`, `vicidial_id` FROM (`recording_log`) WHERE `lead_id` = '2'

Also when I run the following cron job I get same Table 'asterisk.recording_log' doesn't exist.

[root@go ~]# /usr/share/astguiclient/
DBD::mysql::st execute failed: Table 'asterisk.recording_log' doesn't exist at /usr/share/astguiclient/ line 239.
executing: select recording_id,length_in_sec from recording_log where filename='20180403-113041_TESTCAMP_08025284000_agent004_CALLERID' order by recording_id desc LIMIT 1; Table 'asterisk.recording_log' doesn't exist at /usr/share/astguiclient/ line 239.
[root@go ~]#

Can somebody help me how to resolve this issue.

Error.JPG (31.1 kB)