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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
bump