Unable to access any information

[kharris]

Had to move my database from MySQL 5.0 to MySQL 4.x. The move seemed to be fine, but now every time I click on a client name, account name, activity, project or any list item, I get a message about not being able to insert a message into tracker. Here is a sample when trying to click on a contact: (I changed the contact name to Firstname Lastname, but the rest of the error is exactly what I see.

Query Failed:INSERT into tracker ( user_id, module_name, item_id, item_summary,date_modified) values ('46fbede2-3157-8ae0-9ad6-443a88691084', 'Contacts', '3a316977-baee-b398-62ee-44493d7d26b8', 'Firstname Lastname','2006-08-17 19:01:25')::MySQL error 1062: Duplicate entry '0' for key 1


Any help will be greatly appreciated as we have come to rely on this program.

[kharris]

I figured it out about 10min after I made the post. When the transfer was made apparently that tracker table primary key did not become 'auto increment'. I changed it and things are working fine now.