qdPM Extended
project management software for growth
qdPM Extended based on free version of qdPM and has extended functionality and extra features read more.
Home About What's New? Features Demo Buy Now Translations Bug Report Forum Blog Contact Us

ticket by email batch emailtickets.php



Posts: 9

Joined: Fri Jan 03, 2014 11:47 pm

Post Wed Jan 08, 2014 3:20 pm

ticket by email batch emailtickets.php

When running the batch for the ticket by email feature I get the following error regarding a DATE format.

Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with messa
ge 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '20
14-01-06T18:50:28-05:00' for column 'created_at' at row 1' in C:\Web sites\SOLUT
Stack trace:
#0 C:\Web sites\SOLUTION-ORANGE\support.solutionorange.com\html\core\lib\vendor\
tement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Obj
#1 C:\Web sites\SOLUTION-ORANGE\support.solutionorange.com\html\core\lib\vendor\
(1042): Doctrine_Connection_Statement->execute(Array)
#2 C:\Web sites\SOLUTION-ORANGE\support.solutionorange.com\html\core\lib\vendor\
symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Con in C:\Web
b\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine\Connection.php on line 1

My system get email through an Exchange IMAP server using

IMAP Server: (My exchange server)
mailbox: (empty)
Login: (exchange username...this is not an email format)
Password: (my password)

Delete Emails is uncheck for the moment for testing;

As I said in another post, I had to mdify some files to be able to send email on my smtp server which is not the same as the exchange. Since you are using the login as the "FROM" address. My smtp refuse the message as the sender is invalid format. My FROM is hardcoded inside the php file as a temporary fix.


User avatar

Site Admin

Posts: 533

Joined: Thu Aug 05, 2010 12:44 pm

Post Tue Jan 14, 2014 11:42 am

Re: ticket by email batch emailtickets.php

Please load attached file in core/lib folder and then try again

let me know if this error is fixed
(17.45 KiB) Downloaded 363 times


Posts: 9

Joined: Fri Jan 03, 2014 11:47 pm

Post Mon Jan 20, 2014 7:30 pm

Re: ticket by email batch emailtickets.php

It seems to work for the moment. except of course for the from address I described in another post.

thank you

Return to Version 3 Support

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software.