Scenario: Clean install of 5.0 no other data.
- Create Lead "Bing Lee"
- Change Global and Local date format to: dd/mm/YYYY and time to hh:mm am/pm
- Go to lead - create a call in activities
- Create Contact of same name to cause conflict
- Convert Lead
- Select existing contact
- Error
----------------------------------------------------------------------------
Leads: Convert Lead
Query Failed:INSERT into calls set id='6ec41fef-db19-70ca-a8c9-4782bbbce2e9', name='Bingy Baby', date_entered='08/01/2008 10:53am', date_modified='2008-01-07 23:55:38', modified_user_id='1', created_by='1', description=null, deleted='0', assigned_user_id='1', duration_hours=0, duration_minutes=15, date_start='2008-01-23 00:00:00', date_end='2008-01-23', parent_type='Contacts', status='Planned', direction='Outbound', parent_id='5b0416fe-6763-320d-cb6b-4782bb63d84c', reminder_time=-1, outlook_id=null::MySQL error 1292: Incorrect datetime value: '08/01/2008 10:53am' for column 'date_entered' at row 1
-------------------------------------------------------------------------------------
- Change date format to YYYY/mm/dd and repeat - OK!
Bookmarks