Table 'asterisk.recording_log' doesn't exist

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

Moderators: enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, s0lid

Table 'asterisk.recording_log' doesn't exist

Postby himanshu.jaiswal » Tue Apr 03, 2018 3:19 am

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.
himanshu.jaiswal
 
Posts: 7
Joined: Wed Aug 09, 2017 9:06 am

Re: Table 'asterisk.recording_log' doesn't exist

Postby mflorell » Tue Apr 03, 2018 5:02 am

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Table 'asterisk.recording_log' doesn't exist

Postby himanshu.jaiswal » Tue Apr 03, 2018 5:30 am

Thanks.

Its working great. :)
himanshu.jaiswal
 
Posts: 7
Joined: Wed Aug 09, 2017 9:06 am


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 55 guests