I don't have the vicidial_campaigns table
Posted: Wed Feb 28, 2007 1:01 pmHi, I am doing a new installation from svn.
The version is: 2.0.3b4.5
But when I create the tables from /usr/src/astguiclient/agc_2-X/trunk/extras/MySQL_AST_CREATE_tables.sql. I have the following error
The code from MySQL_AST_CREATE_tables.sql that makes this error is:
And when I type show tables, I don't have the vicidial_campaigns table:
I think this can cause some issues.
The version is: 2.0.3b4.5
But when I create the tables from /usr/src/astguiclient/agc_2-X/trunk/extras/MySQL_AST_CREATE_tables.sql. I have the following error
- Code: Select all
Query OK, 0 rows affected (0.06 sec)
ERROR 1060 (42S21): Duplicate column name 'auto_alt_dial_statuses'
Query OK, 0 rows affected (0.10 sec)
The code from MySQL_AST_CREATE_tables.sql that makes this error is:
- Code: Select all
CREATE TABLE vicidial_campaigns (
campaign_id VARCHAR(8) PRIMARY KEY NOT NULL,
campaign_name VARCHAR(40),
active ENUM('Y','N'),
dial_status_a VARCHAR(6),
dial_status_b VARCHAR(6),
dial_status_c VARCHAR(6),
dial_status_d VARCHAR(6),
dial_status_e VARCHAR(6),
lead_order VARCHAR(20),
park_ext VARCHAR(10),
park_file_name VARCHAR(10),
web_form_address VARCHAR(255),
allow_closers ENUM('Y','N'),
hopper_level INT(8) UNSIGNED default '1',
auto_dial_level VARCHAR(6) default '0',
next_agent_call ENUM('random','oldest_call_start','oldest_call_finish','overall_user_level') default 'oldest_call_finish',
local_call_time VARCHAR(10) DEFAULT '9am-9pm',
voicemail_ext VARCHAR(10),
dial_timeout TINYINT UNSIGNED default '60',
dial_prefix VARCHAR(20) default '9',
campaign_cid VARCHAR(10) default '0000000000',
campaign_vdad_exten VARCHAR(20) default '8365',
campaign_rec_exten VARCHAR(20) default '8309',
campaign_recording ENUM('NEVER','ONDEMAND','ALLCALLS','ALLFORCE') default 'ONDEMAND',
campaign_rec_filename VARCHAR(50) default 'FULLDATE_CUSTPHONE',
campaign_script VARCHAR(10),
get_call_launch ENUM('NONE','SCRIPT','WEBFORM') default 'NONE',
am_message_exten VARCHAR(20),
amd_send_to_vmx ENUM('Y','N') default 'N',
xferconf_a_dtmf VARCHAR(50),
xferconf_a_number VARCHAR(50),
xferconf_b_dtmf VARCHAR(50),
xferconf_b_number VARCHAR(50),
alt_number_dialing ENUM('Y','N') default 'N',
scheduled_callbacks ENUM('Y','N') default 'N',
lead_filter_id VARCHAR(10) default 'NONE',
drop_call_seconds TINYINT(3) unsigned default '5',
safe_harbor_message ENUM('Y','N') default 'N',
safe_harbor_exten VARCHAR(20) default '8307',
display_dialable_count ENUM('Y','N') default 'Y',
wrapup_seconds SMALLINT(3) UNSIGNED default '0',
wrapup_message VARCHAR(255) default 'Wrapup Call',
closer_campaigns TEXT default '',
use_internal_dnc ENUM('Y','N') default 'N',
allcalls_delay SMALLINT(3) UNSIGNED default '0',
omit_phone_code ENUM('Y','N') default 'N',
dial_method ENUM('MANUAL','RATIO','ADAPT_HARD_LIMIT','ADAPT_TAPERED','ADAPT_AVERAGE') default 'MANUAL',
available_only_ratio_tally ENUM('Y','N') default 'N',
adaptive_dropped_percentage SMALLINT(3) default '3',
adaptive_maximum_level VARCHAR(6) default '3.0',
adaptive_latest_server_time VARCHAR(4) default '2100',
adaptive_intensity VARCHAR(6) default '0',
adaptive_dl_diff_target SMALLINT(3) default '0',
concurrent_transfers ENUM('AUTO','1','2','3','4','5','6','7','8','9','10') default 'AUTO',
auto_alt_dial ENUM('NONE','ALT_ONLY','ADDR3_ONLY','ALT_AND_ADDR3') default 'NONE',
auto_alt_dial_statuses VARCHAR(255) default ' B N NA DC -',
agent_pause_codes_active ENUM('Y','N') default 'N',
campaign_description VARCHAR(255),
campaign_changedate DATETIME,
campaign_stats_refresh ENUM('Y','N') default 'N',
campaign_logindate DATETIME,
auto_alt_dial_statuses VARCHAR(255) default ' NEW -'
);
And when I type show tables, I don't have the vicidial_campaigns table:
- Code: Select all
mysql> show tables;
+--------------------------------+
| Tables_in_asterisk |
+--------------------------------+
| call_log |
| conferences |
| inbound_numbers |
| live_channels |
| live_inbound |
| live_inbound_log |
| live_sip_channels |
| park_log |
| parked_channels |
| phone_favorites |
| phones |
| recording_log |
| server_performance |
| server_updater |
| servers |
| system_settings |
| vicidial_agent_log |
| vicidial_auto_calls |
| vicidial_call_times |
| vicidial_callbacks |
| vicidial_campaign_hotkeys |
| vicidial_campaign_server_stats |
| vicidial_campaign_stats |
| vicidial_campaign_statuses |
| vicidial_closer_log |
| vicidial_conferences |
| vicidial_dnc |
| vicidial_hopper |
| vicidial_inbound_groups |
| vicidial_lead_filters |
| vicidial_lead_recycle |
| vicidial_list |
| vicidial_list_pins |
| vicidial_lists |
| vicidial_live_agents |
| vicidial_log |
| vicidial_manager |
| vicidial_pause_codes |
| vicidial_phone_codes |
| vicidial_postal_codes |
| vicidial_remote_agents |
| vicidial_scripts |
| vicidial_server_trunks |
| vicidial_state_call_times |
| vicidial_stations |
| vicidial_statuses |
| vicidial_user_groups |
| vicidial_user_log |
| vicidial_users |
| vicidial_xfer_log |
| web_client_sessions |
+--------------------------------+
51 rows in set (0.00 sec)
I think this can cause some issues.