Cron Job importing emails fail

[VPSKing]

Hello

I have annoying issue with importing emails from my gmail.com. Sometimes Cron Job Fail to import emails and I need to debug it first then enable the task again. It can be several times/day.

Here is my email setup:





Error log
Exception: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 IN /home/xxxxxx/public_html/billing/includes/components/mailimport/class.mailimport.php(437), stack trace:
#0 /home/xxxxxx/public_html/billing/includes/components/mailimport/class.mailimport.php(437): PDOStatement->execute()
#1 /home/xxxx/public_html/billing/includes/components/mailimport/class.mailimport.php(312): MailImport->logTicketImport()
#2 /home/xxxx/public_html/billing/includes/components/mailimport/class.imapfetch.php(645): MailImport->import()
#3 /home/xxxxx/public_html/billing/includes/modules/Site/automation/models/class.automation_model.php(794): ImapFetch->fetch()
#4 /home/xxxxx/public_html/billing/includes/modules/Site/automation/models/class.automation_model.php(1112): Automation_Model->importPOP()
#5 /home/cheapseo/public_html/billing/includes/modules/Site/automation/models/class.automation_model.php(940): Automation_Model->automate()
#6 /home/xxxxx/public_html/billing/includes/modules/Site/automation/models/class.automation_model.php(891): Automation_Model->loadProfiles()
#7 /home/xxxxxxx/public_html/billing/includes/modules/Site/automation/cli/class.automation_controller.php(11): Automation_Model::run()
#8 /home/xxxxxxxx/public_html/billing/hbf/core/class.controller.php(257): Automation_Controller->_default()
#9 /home/xxxxxxxx/public_html/billing/hbf/core/types/class.cli_frontcontroller.php(41): Controller::dispatchControl()
#10 /home/xxxxxxx/public_html/billing/hbf/core/class.frontcontroller.php(124): CLI_FrontController::dispatch()
#11 /home/xxxxxx/public_html/billing/hbf/core/class.frontcontroller.php(107): FrontController->handleRequest()
#12 /home/xxxxx/public_html/billing/admin/cron.php(13): FrontController::init('cli')
#13 {main}




Please advice

[BRJP]

This is very odd - we use email all the time and never receive any problems.

The only observation I would make is that you are using IMAP connectivity rather and POP3.  We use POP3 (via SECURE) and this works constantly with importing emails from clients every 5 minutes.  It could be that the email script/program is better with POP3 than IMAP.

You are also importing email from a public mail provider (GMAIL) which I would advise you change to a private email account so you have more control over the account.

[VPSKing]

Thanks for your replay.
I changed my method from imap to pop. Lets see if this solve the issue.

Actually using gmail to have better chance to reach clients inbox.

This is very odd - we use email all the time and never receive any problems.

The only observation I would make is that you are using IMAP connectivity rather and POP3.  We use POP3 (via SECURE) and this works constantly with importing emails from clients every 5 minutes.  It could be that the email script/program is better with POP3 than IMAP.

You are also importing email from a public mail provider (GMAIL) which I would advise you change to a private email account so you have more control over the account.

[BRJP]

Lets see how that goes and post back here with the result!