Meetings SQL Error 1062

[ptemplin7]

Hi all,
Have a funny error showing up in the log file as a SQL 1062 error Duplicate entry. I turned on the Debug and caught the following:
[There seems to be an issue with the custom fields we have added.]

Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query:SELECT date_modified FROM meetings WHERE id='976deeb3-436f-df0c-88fb-4b195bde11b5' AND modified_user_id != '64619cad-9247-0967-b5f3-498a0dcbee35' AND (modified_user_id != '64619cad-9247-0967-b5f3-498a0dcbee35' OR date_modified > DATE_FORMAT('2009-12-04 18:56:05', '%Y-%m-%d %H:%i:%s'))
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query Execution Time:0.0002748966217041
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query:UPDATE meetings_cstm SET  account_id_c='88c6cf27-c4c4-f046-aa70-4829f5de7afb' ,confirmed_by_c='' ,confirm_date_c=NULL WHERE id_c='976deeb3-436f-df0c-88fb-4b195bde11b5'
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query Execution Time:0.00017690658569336
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query:INSERT INTO meetings_cstm (id_c ,account_id_c ,confirmed_by_c ,confirm_date_c ) VALUES ('976deeb3-436f-df0c-88fb-4b195bde11b5' ,'88c6cf27-c4c4-f046-aa70-4829f5de7afb' ,'' ,NULL )
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query Execution Time:0.00011801719665527
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][ERROR] MySQL error 1062: Duplicate entry '976deeb3-436f-df0c-88fb-4b195bde11b5' for key 1
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Update Meeting: Update meetings set name='Abe - 3:00 Meeting re: Roth Conversion', date_modified='2009-12-04 18:56:44', modified_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', created_by='64619cad-9247-0967-b5f3-498a0dcbee35', description=null, deleted='0', assigned_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', location='xxx', duration_hours=0, duration_minutes=15, date_start='2009-12-16 23:00:00', date_end='2009-12-16', parent_type='Cases', status='Planned', parent_id='cff16c75-9700-246f-19e4-4942ad224fd5', reminder_time=900, outlook_id=null WHERE ID = '976deeb3-436f-df0c-88fb-4b195bde11b5'
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Save: Update meetings set name='xxx - 3:00 Meeting re: Roth Conversion', date_modified='2009-12-04 18:56:44', modified_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', created_by='64619cad-9247-0967-b5f3-498a0dcbee35', description=null, deleted='0', assigned_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', location='Arlington', duration_hours=0, duration_minutes=15, date_start='2009-12-16 23:00:00', date_end='2009-12-16', parent_type='Cases', status='Planned', parent_id='cff16c75-9700-246f-19e4-4942ad224fd5', reminder_time=900, outlook_id=null WHERE ID = '976deeb3-436f-df0c-88fb-4b195bde11b5'
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query:Update meetings set name='xxx- 3:00 Meeting re: Roth Conversion', date_modified='2009-12-04 18:56:44', modified_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', created_by='64619cad-9247-0967-b5f3-498a0dcbee35', description=null, deleted='0', assigned_user_id='64619cad-9247-0967-b5f3-498a0dcbee35', location='xxx', duration_hours=0, duration_minutes=15, date_start='2009-12-16 23:00:00', date_end='2009-12-16', parent_type='Cases', status='Planned', parent_id='cff16c75-9700-246f-19e4-4942ad224fd5', reminder_time=900, outlook_id=null WHERE ID = '976deeb3-436f-df0c-88fb-4b195bde11b5'
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][INFO] Query Execution Time:0.00022006034851074
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][DEBUG] save_relationship_changes(): From relationship_field array - adding a relationship record: users = 64619cad-9247-0967-b5f3-498a0dcbee35
Fri Dec  4 10:56:44 2009 [1765][64619cad-9247-0967-b5f3-498a0dcbee35][DEBUG] SugarBean.load_relationships, Loading relationship (users)

What I noticed above is that it does and update and then tries to insert. Seems like this may be a bug? Anybody seen anything like this?

Sugar 5.2a (will be upgrading to k soon, but have some customizations I've not had a chance to lock down.)
CENTOS 5, Linux Server, Apache all the regs.

Thanks PAris

[akkimca]

hi...

from where u getting this error ??? in detailview, listview, sub panel ????

if u getting error in subpanel view than its a relationship problem

[ptemplin7]

Found this in the log file after seeing the error. Turned on the debugging and captured this segment.
Might have been in the listview or when opening a meeting. Created a meeting so it might be in the editview. I suppose I can test some more to zero in further. I have been getting these sql error for multiple records.

The suspicious behavior seems to be the update and then trying to insert at the next moment which should give the sql error!

Will dig a bit further and look at writing up a bug report for this.
Paris