There are plenty of errors like this in my suitecrm.log:
09/04/16 01:31:27 [2492][b37204dd-fd64-564a-390d-56a3525b637b][FATAL] Query Failed: INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summary,date_modified,action,session_id,visible ) VALUES ( '2555ba28-efc8-81e7-316b-57cbdb617969','b37204dd-fd64-564a-390d-56a3525b637b','Accounts','158bc1ce-082e-b643-f0a6-57bd8a3165c1','شهید سلیمانی','2016-09-04 08:31:27','detailview','615cj4cjb2d21odnp1c6puovq7','1'): MySQL error 1062: Duplicate entry '0' for key 'PRIMARY'
What are they related to?
SuiteCRM 7.6.4
WampStack Bitnami installation on Windows 7
The tracker table gets filled with users activity, there’s some duplicate fields, do you ever modified something in that table? do you have like an user activity report addon or something like that? you can safely truncate that table, but make a backup first, of course if you’re not using it
best regards
Actually there is a similar problem for the CASES table. I suspect something has gone wrong and has reset some tables id-auto-increment columns. I checked the “tracker” table and there was a record with id=0.
How can I identify the problem?
I use no add-on.
These are major changes I have made to my project:
I installed SuiteCRM 7.4.3 using bitnami wampstack on windows 7,
and then upgraded to 7.5.3 using upgrade wizard,
and then upgraded to 7.6.4 using upgrade wizard.
I faced a high-response-time and the problem was a bug in upgrade-to-7.6.4 and to solve it I modified the “Reminders” table by changing all records’ “deleted” column to 1.