Jump to content


Photo

Tasks - Mandatory completed date?

tasks Completed Date

  • Please log in to reply
3 replies to this topic

#1 k1000o

k1000o

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts
  • LocationMadrid

Posted 04 June 2012 - 01:51 PM

When creating tasks the completed date is mandatory, is this normal?

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'completeddatetime' at row 1
I would say that this field will be only completed automatically later hen the tasks is checked as completed, or manually modified later.

#2 Jason

Jason

    Administrator

  • Administrators
  • 864 posts
  • LocationChicago

Posted 04 June 2012 - 06:31 PM

When creating tasks the completed date is mandatory, is this normal?

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'completeddatetime' at row 1
I would say that this field will be only completed automatically later hen the tasks is checked as completed, or manually modified later.

It is not mandatory, but my guess is you have something that needs to be changed with your my.ini to allow for null values for completeddatetime.

Jason Green
Zurmo Team
Need support? Upgrade now


#3 k1000o

k1000o

    Advanced Member

  • Members
  • PipPipPip
  • 112 posts
  • LocationMadrid

Posted 04 June 2012 - 07:49 PM

You were right, after removing STRICT_TRANS_TABLES from sql-mode it works o.k

#4 Jason

Jason

    Administrator

  • Administrators
  • 864 posts
  • LocationChicago

Posted 04 June 2012 - 09:02 PM

ok good. I believe this issue is resolved as something that is looked at during installation.

Jason Green
Zurmo Team
Need support? Upgrade now






Also tagged with one or more of these keywords: tasks, Completed, Date

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users