3-Way Call Dial Prefix in latest admin.php from SVN

[okli]

Using 2.0.5 SVN 991 I believe.
Admin.php:
VERSION: 2.0.5-148 BUILD: 81103-1408

Fields in campaign details page-
3-Way Call Outbound CallerID:
3-Way Call Dial Prefix:

are populated incorrectly with values from vicidial_campaign table:
campaign_shift_start_time
campaign_shift_length

This breaks transfer/conf function as dialed conf number gets prefix '1600' in this example.

Actually I don't see campaign_shift_start_time and campaign_shift_length fields in campaign details page:


In admin_changes.log I see:

Wed, 05 Nov 2008 13:00:41 -0800|MODIFY CAMPAIGN INFO|admin|70.79.XXX.XXX|UPDATE vicidial_campaigns set campaign_name='Test campaign 2 for VICIDIAL',active='Y',dial_status_a='',dial_status_b='',dial_status_c='',dial_status_d='',dial_status_e='',lead_order='DOWN',allow_closers='Y',hopper_level='5', auto_dial_level='0', next_agent_call='oldest_call_finish', local_call_time='24hours', voicemail_ext='', dial_timeout='60', dial_prefix='9', campaign_cid='00000000', campaign_vdad_exten='8369', web_form_address='/vicidial/vtiger_search2.php', park_ext='', park_file_name='', campaign_rec_exten='8309', campaign_recording='ONDEMAND', campaign_rec_filename='AGENT_CAMPAIGN_CUSTPHONE_FULLDATE', campaign_script='', get_call_launch='NONE', am_message_exten='', amd_send_to_vmx='N', xferconf_a_dtmf='',xferconf_a_number='',xferconf_b_dtmf='',xferconf_b_number='',lead_filter_id='NONE',alt_number_dialing='N',scheduled_callbacks='N',drop_action='MESSAGE',drop_call_seconds='5',safe_harbor_exten='8307',wrapup_seconds='0',wrapup_message='Wrapup Call',closer_campaigns='',use_internal_dnc='Y',allcalls_delay='0',omit_phone_code='N',dial_method='MANUAL',available_only_ratio_tally='N',adaptive_dropped_percentage='3',adaptive_maximum_level='3.0',adaptive_latest_server_time='2100',adaptive_intensity='0',adaptive_dl_diff_target='0',concurrent_transfers='AUTO',auto_alt_dial='NONE',agent_pause_codes_active='N',campaign_description='Test campaign 2 for VICIDIAL',campaign_changedate='2008-11-05 13:00:41',campaign_stats_refresh='N',disable_alter_custdata='N',no_hopper_leads_logins='Y',list_order_mix='DISABLED',campaign_allow_inbound='N',manual_dial_list_id='998',default_xfer_group='---NONE---',xfer_groups='',queue_priority='50',drop_inbound_group='---NONE---',disable_alter_custphone='Y',display_queue_count='Y',manual_dial_filter='NONE',agent_clipboard_copy='NONE',agent_extended_alt_dial='N',use_campaign_dnc='N',three_way_call_cid='0900',three_way_dial_prefix='1600' where campaign_id='TEST2';|N|

Note

three_way_call_cid='0900',three_way_dial_prefix='1600'

Is it a bug or I did something wrong?

[mflorell]

Looks like you ran the upgrade_2.0.5.sql file more than once

just run these queries:
ALTER TABLE vicidial_campaigns DROP campaign_shift_start_time;
ALTER TABLE vicidial_campaigns DROP campaign_shift_length;
ALTER TABLE vicidial_campaigns DROP campaign_day_start_time;


We have seen this before.

[okli]

That fixed it, thanks.

When updating SVN versions should I run upgrade_2.0.5.sql as well?

BTW is google your brother or something?

[mflorell]

If upgrading from one SVN trunk snapshot to another you need to look at the system_settings table db_schema_version and open up the upgrade_2.0.5.sql file and only execute the SQL statements AFTER the db_schema_version that you are using.

[okli]

I got it, thanks a lot.