Results 1 to 5 of 5

Threaded View

  1. #1
    Join Date
    Jul 2009
    Location
    Roswell, NM, USA
    Posts
    97
    Plugin Contributions
    0

    Default ERROR message help 1062 Duplicate entry for key 1 in db_cache

    I just checked my cache file and found a log file that is rather large, 120,138 bytes. It is a Fatal Error 1062 duplicate entry for the cache file:

    Code:
    [26-Aug-2012 13:43:04 UTC] PHP Fatal error:  1062:Duplicate entry 'zc_dXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' for key 1 :: insert into db_cache set cache_entry_name = 'zc_dXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
                                                     cache_data = ' too much data to input, the forum refused to post it or upload it in any form '
                       cache_entry_created = '1345988584' in /home/www/XXXXXX/zen-cart/includes/classes/db/mysql/query_factory.php on line 101
    I looked at similar threads and could see one that might address my issue because they are all from several years ago and both zen-cart and the MySQL/PHP have been upgraded. I don't want to risk further damage by trying to fix it without asking for help first.

    I do not know what triggered it as I was not online when it happened.

    Any ideas on how to fix it? I'm also getting reports from my hosting company that the CPU usage is way too high, could this be related?

    Blessings,
    Krisann

    ################################################################################ ##########
    Pertinent Details

    Zen Cart 1.5.0
    Database Patch Level: 1.5.0
    v1.5.0 [2012-08-13 12:56:00] (Version Update 1.3.9->1.5.0)
    v1.3.9h [2011-10-12 22:06:48] (Fresh Installation)

    Server OS: Linux 2.6.30.1-3.AM_64
    Database: MySQL 5.0.51a-24-log
    HTTP Server: Apache/2.2.11
    PHP Version: 5.3.9 (Zend: 2.3.0)
    PHP Memory Limit: 64M
    PHP Safe Mode: Off
    PHP File Uploads: On

    Currently installed mods:

    Admin Display Product Catalog Thumb
    Admin_Login_As_Customer_v3.0_For_ZCv150
    Admin Notes Advanced
    Admin Change PW Display
    Admin sort order alpha
    Backup MySQL plugin v5
    Backup Zencart v1
    Confirm Email Address 1.3a
    Contact Us- add subject
    contest system 1
    Define Pages- shopping cart
    Dynamic Filter (not working 100% due to required change in /incl/fun/functions_general.php)
    Easy Attributes 1.3.91.5.0
    edit_orders_v4.0.2
    Email for 404 v122
    Fast Easy Checkout 1.5.0
    Image Handler 4
    Mailchimp 3.0
    Multi Cross Sell
    newsletter_discount_3.0
    Piccadilly_Posh (template)
    Recover Cart Sales
    Rewards Points Full Suite 2.1.b
    Save Sideboxes Layout

    Edited Admin Sort Order: Alpha

    Bug Fixes applied:
    Current Categories incorrect when copying a product
    Customer authorization e-mail not sent out on pressing "the red button".
    extra closing head in admin profiles.php (changed to </thead>)
    Incorrect database constant used in tpl_account_default.php
    PayPal has unexpectedly returned a blank address
    PHP Warning: strlen() expects parameter 1 to be string
    popup_search_help popup missing [close] link
    Zen_back_link bug fix
    Last edited by shartlesville; 26 Aug 2012 at 05:39 PM.

 

 

Similar Threads

  1. Replies: 3
    Last Post: 21 Jan 2016, 10:35 PM
  2. v151 [Done v1.6.0] 1062:Duplicate entry for key 1 in db_cache
    By rayw1679 in forum General Questions
    Replies: 68
    Last Post: 16 Feb 2015, 05:32 PM
  3. ERROR message help 1062 Duplicate entry '1-1' for key 1
    By worshamdesigns in forum Setting Up Categories, Products, Attributes
    Replies: 10
    Last Post: 11 Feb 2011, 12:58 AM
  4. Replies: 6
    Last Post: 30 Dec 2008, 12:49 AM
  5. Error: 1062 Duplicate entry '0-78' for key 1
    By G33K-Chik in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 15 Apr 2008, 08:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg