clamhost Posted March 13, 2014 Report Share Posted March 13, 2014 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2014-03-13T19:31:57+00:00' for column 'date_closed' at row 1 on line 124 in/home/billing/public_html/lib/model.php #0 /home/billing/public_html/lib/model.php(124): PDOStatement->execute(Array)#1 /home/billing/public_html/components/record/record.php(233): Model->query('UPDATE `support...', Array)#2 /home/billing/public_html/plugins/support_manager/models/support_manager_tickets.php(100): Record->update('support_tickets', Array, Array)#3 /home/billing/public_html/plugins/support_manager/models/support_manager_tickets.php(269): SupportManagerTickets->edit('46', Array)#4 /home/billing/public_html/plugins/support_manager/controllers/admin_tickets.php(289): SupportManagerTickets->addReply('46', Array, Array)#5 /home/billing/public_html/lib/dispatcher.php(111): AdminTickets->reply()#6 /home/billing/public_html/index.php(21): Dispatcher::dispatch('/admin/plugin/s...')#7 {main} Getting this error upon closing a ticket. Not had this error before. madinazakirova 1 Link to comment Share on other sites More sharing options...
clamhost Posted March 13, 2014 Author Report Share Posted March 13, 2014 This is happening with every single ticket now. Link to comment Share on other sites More sharing options...
Paul Posted March 13, 2014 Report Share Posted March 13, 2014 Are you running the official support manager plugin that we ship with Blesta, or the modified version? Have you changed anything, like the date/time format in the settings, or upgraded/downgraded anything on the server? Michael 1 Link to comment Share on other sites More sharing options...
clamhost Posted March 14, 2014 Author Report Share Posted March 14, 2014 Hi, I'm using the official support manager. and all the settings are exactly the same. Link to comment Share on other sites More sharing options...
PauloV Posted March 14, 2014 Report Share Posted March 14, 2014 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2014-03-13T19:31:57+00:00' for column 'date_closed' at row 1 on line 124 in/home/billing/public_html/lib/model.php #0 /home/billing/public_html/lib/model.php(124): PDOStatement->execute(Array) #1 /home/billing/public_html/components/record/record.php(233): Model->query('UPDATE `support...', Array) #2 /home/billing/public_html/plugins/support_manager/models/support_manager_tickets.php(100): Record->update('support_tickets', Array, Array) #3 /home/billing/public_html/plugins/support_manager/models/support_manager_tickets.php(269): SupportManagerTickets->edit('46', Array) #4 /home/billing/public_html/plugins/support_manager/controllers/admin_tickets.php(289): SupportManagerTickets->addReply('46', Array, Array) #5 /home/billing/public_html/lib/dispatcher.php(111): AdminTickets->reply() #6 /home/billing/public_html/index.php(21): Dispatcher::dispatch('/admin/plugin/s...') #7 {main} Getting this error upon closing a ticket. Not had this error before. Hello, It seems like you have change the "Tickets replay Date Format" on config file form this: M j Y g:i A (this is the correct one) to this: Y-m-d H:i:sP (this cannot work) Is that correct? Regards, PV Link to comment Share on other sites More sharing options...
clamhost Posted March 23, 2014 Author Report Share Posted March 23, 2014 The issue was something to do with the actual CPanel Server. Since moved back over to Precona and all works great. Link to comment Share on other sites More sharing options...
Tyson Posted March 25, 2014 Report Share Posted March 25, 2014 This is fixed in CORE-1110. Link to comment Share on other sites More sharing options...
Recommended Posts