We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Execution of a query to the database failed - Duplicate entry

    • 19369
    • 1,098 Posts
    microcipcip Reply #1, 16 years, 6 months ago
    Hi, Mozilla Firefox crashed while I was editing a TV rolleyes. Now I get this error when I open a resource...

    Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\jertix\manager\includes\header.inc.php:7) in C:\xampp\htdocs\jertix\manager\includes\document.parser.class.inc.php  on line 2732
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Duplicate entry '1356' for key 'PRIMARY' »
      SQL: INSERT INTO `jertix2`.`jertix2_manager_log` (timestamp, internalKey, username, action, itemid, itemname, message) VALUES ('1270358558', '1', 'admin', '27', '3', '-', 'Editing document')
      Jertix.org -> Web Design & Development, Motion Graphics | Follow me on Twitter | MODx Tutorials (in Italiano) | MODx Snippets (English)
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      sottwell Reply #2, 16 years, 6 months ago
      Try logging out, then clear your browser cache and cookies for your domain, then log in again. It sounds like a stale cookie holdover from the crashed session.

      Go to Reports -> Manager Actions, do a search, and the link for emptying the table will be in the paragraph of text above the table.

      You can also open the Backup tool and click the blue link to empty the table.

      If you can’t do either of these, you’ll have to go into the database manually to either truncate the table or remove the offending record.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 19369
        • 1,098 Posts
        microcipcip Reply #3, 16 years, 6 months ago
        Thanks so much sottwell!

        You can also open the Backup tool and click the blue link to empty the table.--> This works
          Jertix.org -> Web Design & Development, Motion Graphics | Follow me on Twitter | MODx Tutorials (in Italiano) | MODx Snippets (English)