Archive July Leads in LX.COM

Ran archival job manually but many errors are being generated such as the one below . July leads appear to have been already stored however they are not showing up in the ‘Archive Leads’ section. This has been an issue and will need further research. (possibly a developer to fix it)

/******************************************/
Email function in commonFunctions.inc.php
/******************************************/

There was a database error generated by a calling script.
Parent script was /mng/admin/archivedLeads/archiveLeadsOneMonth_working.php.

The statement was
——————————-
INSERT INTO
archivedLeads_log
(CompanyName,CampaignName,ClientId,CampaignId,NumLeads,LeadState,ArchivePeriod,Filename,DateAdded)
VALUES (‘Sparkroom’,’Westwood College – SR’,’49’,’305′,’375′,’accepted’,’2015-07-01′,’Westwood College – SR_accepted_1438625909.csv’,now()), (‘Sparkroom’,’Westwood College – SR’,’49’,’305′,’39’,’rejected’,’2015-07-01′,’Westwood College – SR_rejected_1438625909.csv’,now()), (‘Sparkroom’,’Westwood College – SR’,’49’,’305′,’6′,’junked’,’2015-07-01′,’Westwood College – SR_junked_1438625909.csv’,now()), (‘Sparkroom’,’Westwood College – SR’,’49’,’305′,’1′,’bad’,’2015-07-01′,’Westwood College – SR_bad_1438625909.csv’,now())
——————————-
Database Error was

——————————-

——————————-

Just ran it and same errors. However if you need a particular archive for any month you can pull them down from this URL. It’s not very pretty but it works

http://leadxpert.com/leadArchives/

No even sure what happened but I may have to send this to a developer and it’s gonna take time to try and explain LX to some snake charmer in India. I will see what I can do.

1. Status changed from Custom Dev to Closed.
2. Category set to Bug.