Custom date fields causing wider problems on IIS

[andrewm]

I've got a problem with custom fields which seems to be related to custom date fields. I reproduced it as follows:

- Clean install of Sugar Suite 4.5.1a on Windows 200 Server / IIS 5.0 / PHP 5.2.1 / MySQL 5.0.27
- Created 2 custom fields in the account module: one text, one date
- Added the custom text field to the edit view of the Accounts module (ie I didn't add the date field)
- Created a new record with a value in the custom text field.
- Edited the record and changed the text field. The new value is NOT saved

Notes:
- If I remove the date field from the module (even though its not being used) then any changes to the custom text fields are saved as expected.
- If I place the date field on the EDIT layout, the custom data won't save at all
- If I do the above procedure on the current SugarCRM demo site, it works fine.

Anyone any ideas for this?

[andrewm]

I just noticed the following in the log:

03/13/2007 12:07:02 AM,744 [7096] ERROR SugarCRM - MySQL error 1292: Incorrect date value: 'NULL' for column 'lastrevieweddate_c' at row 1

So I'm guessing it could be related to this thread:

http://www.sugarcrm.com/forums/showt...highlight=1292

Though I don't see a concrete resolution in that thread - anyone know of one?

[wjohnson]

When we ran into that problem we were able to get around it by turning off MySQL strict mode at the instruction of Sugar Support. I don't really view that as a solution because we have a financial application running off MySQL as well which really benefits from strict mode. I hope that future versions of Sugar will make the changes necessary to run in MySQL strict mode.

[andrewm]

Thanks - turning off STRICT mode did indeed fix it.

I agree with you that Sugar should be able to use that mode.