Project

General

Profile

Forums » GOautodial Help »

You need to enter the campaign 2

Added by Kirill Ragimov about 4 years ago

Good afternoon, when an agent chooses a company and joins it, (judging by the sound of the connection), the right side of the interface does not change to a soft background, with a second connection to the company, the interface returns to normal, but the operator begins to hear himself

GoAutoDial4.iso

a domain with a certificate is installed

Operating system updated

GoAutoDial updated from Git

I attach a video for clarity

https://youtu.be/PwtIY_3LC4o


Replies (5)

RE: You need to enter the campaign 2 - Added by Wittie Manansala about 4 years ago

Try to run the following:

mysql goautodial -A

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_ids TEXT;
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_list_id BIGINT UNSIGNED DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN manual_dial_min_digits INT DEFAULT '6';
MariaDB [goautodial]> update go_campaigns set default_country_code='USA_1';

MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_chat tinyint(1) NULL DEFAULT '1';
MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_webrtc tinyint(1) DEFAULT '1';

use asterisk

MariaDB [asterisk]> UPDATE system_settings SET agent_whisper_enabled='1';

Thanks

RE: You need to enter the campaign 2 - Added by Kirill Ragimov about 4 years ago

thanks, I did it on my own

RE: You need to enter the campaign 2 - Added by Alberto Fish about 4 years ago

Kirill Ragimov wrote in RE: You need to enter the campaign 2:

thanks, I did it on my own

Hi, Could you share your solution?
thanks!

RE: You need to enter the campaign 2 - Added by Alberto Fish about 4 years ago

Wittie Manansala wrote in RE: You need to enter the campaign 2:

Try to run the following:

mysql goautodial -A

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_ids TEXT;
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_list_id BIGINT UNSIGNED DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN manual_dial_min_digits INT DEFAULT '6';
MariaDB [goautodial]> update go_campaigns set default_country_code='USA_1';

MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_chat tinyint(1) NULL DEFAULT '1';
MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_webrtc tinyint(1) DEFAULT '1';

use asterisk

MariaDB [asterisk]> UPDATE system_settings SET agent_whisper_enabled='1';

Thanks

Hi, I tried but not luck:

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT 'NORMAL'' at line 1
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'cb_noexpire'
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'cb_sendemail'
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT 'USA_1'' at line 1
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'enable_callback_alert'
.....................

RE: You need to enter the campaign 2 - Added by Alberto Fish about 4 years ago

Alberto Fish wrote in RE: You need to enter the campaign 2:

Wittie Manansala wrote in RE: You need to enter the campaign 2:

Try to run the following:

mysql goautodial -A

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_ids TEXT;
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_list_id BIGINT UNSIGNED DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN manual_dial_min_digits INT DEFAULT '6';
MariaDB [goautodial]> update go_campaigns set default_country_code='USA_1';

MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_chat tinyint(1) NULL DEFAULT '1';
MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_webrtc tinyint(1) DEFAULT '1';

use asterisk

MariaDB [asterisk]> UPDATE system_settings SET agent_whisper_enabled='1';

Thanks

Hi, I tried but not luck:

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT 'NORMAL'' at line 1
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'cb_noexpire'
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'cb_sendemail'
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT 'USA_1'' at line 1
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'enable_callback_alert'
.....................

Ok, I changed some somethings. Now it works.

mysql goautodial -A

MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR DEFAULT 'NORMAL';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR DEFAULT 'USA_1';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_ids TEXT;
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN google_sheet_list_id BIGINT UNSIGNED DEFAULT '0';
MariaDB [goautodial]> ALTER TABLE go_campaigns ADD COLUMN manual_dial_min_digits INT DEFAULT '6';
MariaDB [goautodial]> update go_campaigns set default_country_code='USA_1';

MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_chat tinyint(1) NULL DEFAULT '1';
MariaDB [goautodial]> ALTER TABLE users ADD COLUMN enable_webrtc tinyint(1) DEFAULT '1';

    (1-5/5)     Go to top