Help : Query Failed

[ecs_technical]

Hi Guys,
I am a newbie in SugarCRM

We are experiencing this kind of problem:

Query Failed:INSERT into tracker ( user_id, module_name, item_id, item_summary, date_modified, action, session_id, visible) values ('717bc272-0a8d-bca9-993b-4a67b2a337b6', 'P1_Task_Schedules', '18c52fe2-2b44-4914-50b7-4bfc7d751d6f', 'VSX7000s','2010-05-27 02:28:03', 'detailview', NULL, 1)::MySQL error 1062: Duplicate entry '46853' for key 1


can you give us any resolutions for this. Thank You!

james

[datasponge]

That error indicates a duplicate primary key... that is you tried to insert a record that was already in the tracker table (or at least one whose key was the same).

The tracker table key field is 'id' and it is an auto_increment field. The value '46853' was not specified in the query, so the database should have handled making id unique for you. You can look up the record in tracker with this id value and see if it gives you any clues.

But I'm not familiar enough with tracker to know what happened. What steps did you take that resulted in this message?

Phil