Error message: Duplicate entry '0' for key1

  • 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



Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks