Leads Test ERROR

Any and all non-support discussions

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

Leads Test ERROR

Postby ruben23 » Fri Jul 12, 2019 10:12 am

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.
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: Leads Test ERROR

Postby williamconley » Sun Jul 21, 2019 6:39 pm

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
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Leads Test ERROR

Postby ruben23 » Fri Oct 18, 2019 7:33 am

@Williamconley

what to do with this somehow.? to resolve this error, should i correct the script.?
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 62 guests