Converting Leads

[chrislynch8]

Hi,

I have a trail version of the Professional Edition. I am trying to convert a lead and I get the following error

Query Failed:INSERT into tasks set id='42527c6e-0599-644a-7cdb-4728a0c954a0', date_entered='31-10-2007 03:10pm', date_modified='2007-10-31 15:33:23', assigned_user_id='b2663cb9-5577-92b7-de05-4726fc0e612d', modified_user_id='b2663cb9-5577-92b7-de05-4726fc0e612d', created_by='b2663cb9-5577-92b7-de05-4726fc0e612d', team_id='cf1bc6e4-8115-f3cd-6f1e-4726fc6a8e42', name='Meeting', status='Completed', date_due_flag='off', date_due='2007-10-31', time_due='11:00:00', date_start_flag='off', date_start=null, time_start=null, parent_type='Contacts', parent_id='34bd1fe2-34ad-027d-19c1-4728a0e43956', contact_id='34bd1fe2-34ad-027d-19c1-4728a0e43956', priority='Medium', description='Meeting to find out what John requires', deleted='0'::MySQL error 1292: Incorrect datetime value: '31-10-2007 03:10pm' for column 'date_entered' at row 1

It appears the Date is causing an issue. I don't know how or why.

Chris

[eggsurplus]

Chris,

I'm not sure how the date_entered even got to that value but it needs to be formatted as Year/Month/Day instead of Day/Month/Year in MySQL.

[Angel]

Just out of curiosity, what is the date format set to for the login that is having that problem?

[chrislynch8]

Just out of curiosity, what is the date format set to for the login that is having that problem?

This user is formatted for day/month/year in the option in his account.

[chrislynch8]

Chris,

I'm not sure how the date_entered even got to that value but it needs to be formatted as Year/Month/Day instead of Day/Month/Year in MySQL.

I changed that around and still the same issue. It seem to happen when I have note,meeting etc linked to the lead. When I remove all the meetings notes the convert works correctly.


Also it is still creating the contact and account but the error is preventing the lead status from changing to converted

[Angel]

Have you checked the dates on the linked records to make sure that they are correct (meetings, tasks, etc.)?

What happens if you add a new lead, add a new task for that lead and then convert that lead?

[xnavarro]

I am having the same problem. it is very consitent and it happens when converting leads that have activities associated with them. Apparently the date format in the SQL Insert statement is incompatible with mysql - see bellow. I tried different date formats in the settings on Sugarcrm.com. No luck. Is there a setting in mySQL perhaps? or is this a known defect that is fixed in later verisions (I am on 4.51). Any help would be appreciated.


Query Failed:INSERT into tasks set id='6d6e3f7a-a251-9121-a8a9-47b457eb116a', date_entered='02-14-2008 09:58am', date_modified='2008-02-14 14:59:38', assigned_user_id='99162e6d-4736-f760-1501-44bf8227a4d5', modified_user_id='99162e6d-4736-f760-1501-44bf8227a4d5', created_by='99162e6d-4736-f760-1501-44bf8227a4d5', name='Test Task', status='Not Started', date_due_flag='off', date_due=null, time_due=null, date_start_flag='off', date_start=null, time_start=null, parent_type='Accounts', parent_id='21e8ccc5-04c0-dc5b-1df8-47b457f019b1', contact_id=null, priority='Medium', description='test', deleted='0'::MySQL error 1292: Incorrect datetime value: '02-14-2008 09:58am' for column 'date_entered' at row 1

[clint]

Well, this is definitely a bug. Are you on the latest patch (i) of 4.5.1? We fixed this bug in 5.0 since it was first reported back in October. I'm pretty sure we fixed this in 4.5.1 also.

A possible workaround is to set your system default date format to yyyy-mm-dd in the Admin->Locale Setting screen.