vicidial.org

version: 2.14b0.5
SVN Version: 3067
DB Schema Version: 1564
DB Schema Update Date: 2019-03-01 18:32:30
Password Encryption:DISABLED - S1 - C1
Auto User-add Value: 101
Recording Prompt Count: 0
Install Date: 2019-03-01
ASterisk 1.8
Scratch install Ubuntu Server



any idea on this error also when i execute this script ---> /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --forcelistid=107 --forcephonecode=1

Code: Select all

root@vicisip:/usr/src/astguiclient/trunk/extras# /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --forcelistid=107 --forcephonecode=1

----- FORCE LISTID OVERRIDE: 107 -----


----- FORCE PHONECODE OVERRIDE: 1 -----













-- VICIDIAL_IN_new_leads_file.pl --

This program is designed to take a tab delimited file and import it into the VICIDIAL system.

performance_test_leads.txt 8088890
performance_test_leads.txt 8088890

DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.
DBD::mysql::db do failed: Incorrect integer value: '' for column `asterisk`.`vicidial_list`.`lead_id` at row 1 at /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl line 2684, <infile> line 0.000000.


what field order are you using?

if it doesn't match this field list, that's your problem:

/vicidial/help.php?ADD=99999#list_loader

@Williamconley

what to do with this somehow.? to resolve this error, should i correct the script.?