Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
When I click on a Company name, the company does load, but I get this error message at the top:
Unable to execute your query. Please correct this error.
You may need to update your database structure.
Duplicate entry '0' for key 1.
I tried to execute:
INSERT INTO recent_items ( USER_ID, ON_WHAT_TABLE, RECENT_ACTION, ON_WHAT_ID, RECENT_ITEM_TIMESTAMP ) VALUES ( 2, 'companies', '', 209, '2009-10-09 09:46:26' )
I have already updated the database structure.
The only thing I can attribute this to is that recently our hosting company "migrated" us to another server and system, and it caused this problem as well as other issues with our website.
Here's an update:
When I delete/truncate the recent_items table of the database, the error message disappears, but only for one query. After clicking on a second company name (or contact name) the error message appears again.