Table 'asterisk.recording_log' doesn't exist

[himanshu.jaiswal]

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/AST_CRON_audio_1_move_mix.pl
DBD::mysql::st execute failed: Table 'asterisk.recording_log' doesn't exist at /usr/share/astguiclient/AST_CRON_audio_1_move_mix.pl 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/AST_CRON_audio_1_move_mix.pl line 239.
[root@go ~]#

Can somebody help me how to resolve this issue.

[mflorell]

Can't say I've ever seen a table just disappear before, then again we never recommend using GoAutoDial.

Try recreating the table from the CREATE statement that you'll find in the "extras/MySQL_AST_CREATE_tables.sql" file.

[himanshu.jaiswal]

Thanks.

Its working great.