clamhost Posted March 13, 2014 Report 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
clamhost Posted March 13, 2014 Author Report Posted March 13, 2014 This is happening with every single ticket now.
Paul Posted March 13, 2014 Report 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
clamhost Posted March 14, 2014 Author Report Posted March 14, 2014 Hi, I'm using the official support manager. and all the settings are exactly the same.
PauloV Posted March 14, 2014 Report 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
clamhost Posted March 23, 2014 Author Report 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.
Recommended Posts