Error message: Duplicate entry '0' for key1

rebaths
2009-10-09
2013-04-26
  • rebaths
    rebaths
    2009-10-09

    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.

     
  • rebaths
    rebaths
    2009-10-09

    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.

     
  • rebaths
    rebaths
    2009-10-12

    bump