Cannot upload leads

[ykhan]

I deleted the leads fromthe table through MySQL prompt and now whatever file I try to upload using the Lead Loader, no leads actually get uploaded even though I get a message GOOD: 1000 BAD: 71 etc. after I process a file.

VicidialNOW 1.2

[ykhan]

It appears that I might have boched something up. I only see one lead in on the list page. WHen I try to add leads using INSERT ni MySQL, the first lead goes in ok, but the second time I try to insert the same fields:

Code: Select all

insert into vicidial_list values('lead01','2004-01-06','','NEW','','','','105','','','1','7275551212','Mr','Matt','X','Freely','1234 Fake St.','','','Clearwater','FL','','33760','','M','1970-01-01','','test@test.com','suprise','comments go here','0','');

I get this message:

Code: Select all

ERROR 1062 (23000): Duplicate entry '4294967295' for key 1

Is there a way for me to revert tothe original vicidial_list table?

[ykhan]

RESOLVED

I dropped the table VICIDIAL_LIST. Then recreated by copying from the MySQL_AST_CREATE_tables.sql file. After this process, I was able to upload leads normally.

[Op3r]

strangely I find this being a problem of mine too.

and no I cant just drop the whole table as lots of list are there.

Is there anything can be to be able to load leads? or check on how to fix this?