Page 1 of 7 123 ... LastLast
Results 1 to 10 of 69
  1. #1
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default [Done v1.6.0] 1062:Duplicate entry for key 1 in db_cache

    I don't know how long I've been getting these, but I seem to be getting about one a day:
    PHP Fatal error: 1062uplicate entry 'zc_d6616cb5f4c2cb55d422ea67feb723b0' for key 1 :: insert into db_cache set cache_entry_name = 'zc_d6616cb5f4c2cb55d422ea67feb723b0',

    Then, after cache data,

    cache_entry_created = '1360021508' in /homepages/5/d232125156/.../store/includes/classes/db/mysql/query_factory.php on line 120

    I recently converted this store from 1.3.8 to 1.5.1. (It's possible I've been getting this for years, as I just discovered the logs.) The database upgrade ran fine. Server info:

    Server OS: Linux 2.6.28.8-20120713a-iscsi-ntacker-3ware-sec8-fmon-igb-dif2-grsec
    Database: MySQL 5.0.96-1~ui60+1
    HTTP Server: Apache
    PHP Version: 5.2.17 (Zend: 2.2.0)
    PHP Memory Limit: 90M PHP Safe Mode: Off
    PHP File Uploads: On
    Max Size: 40M POST Max Size: 8M
    Database Data Size: 15,414 kB
    Database Index Size: 4,572 kB
    Thanks,
    Ray

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Check your configure.php file for "cache" setting

    Is it the database??

    I suspect that it is.....

    Probably caused from a link that included a zenid
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Thank you so much for your prompt response -- you have no idea how much I appreciate it.

    Yes, it is set to the database. I often send links, but try to remember to remove the zenid from them. Are you saying it's simply a zenid in a link that I forgot to remove and there's nothing to worry about?
    Thanks,
    Ray

  4. #4
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Sorry ... this was a duplicate post caused by my ISP. I sometimes get up to 20 seconds latency and have to refresh, and it causes duplicates. I couldn't figure out how to delete it.
    Last edited by rayw1679; 6 Feb 2013 at 05:33 PM.
    Thanks,
    Ray

  5. #5
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Set it to "none" for the time being as see what happens

    Check your account for host provided stats and see if you can find where the link is coming from

    Yes it appears to be a link that included a zenid
    Zen-Venom Get Bitten

  6. #6
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Thank you very much for your prompt reply.
    Thanks,
    Ray

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Quote Originally Posted by kobra View Post
    Probably caused from a link that included a zenid
    Nope. Won't be related to zenid in the URL.

    But truncating the db_cache table might clear up any leftover entries from older versions that might be causing conflicts.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Thank you, DrByte. I have gone into the store manager to confirm cleanup of debug log files, and that didn’t stop it. If you’re referring to something else, I have searched FAQ’s and I can’t figure out what I’m supposed to do. If you could please send me in the right direction, I would appreciate it.
    Thanks,
    Ray

  9. #9
    Join Date
    Mar 2005
    Location
    Waxahachie, Texas
    Posts
    174
    Plugin Contributions
    0

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    Thank you, DrByte. I have gone into the store manager to confirm cleanup of debug log files, and that didn’t stop it. If you’re referring to something else, I have searched FAQ’s and I can’t figure out what I’m supposed to do. If you could please send me in the right direction, I would appreciate it.
    Thanks,
    Ray

  10. #10
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: 1062:Duplicate entry for key 1 in db_cache

    The FILES in your cache folder are simply REPORTING the error, which exists in your database.

    Dr Byte is suggesting you TRUNCATE your db_cache table (that means EMPTY it).

    While this can probably be done from your zc admin >>> tools >>> insert sql patches , it is better that it is done in phpMyAdmin (via your hosts c-panel), and only AFTER you have made a full backup of the database.

    When working in phpMyAdmin, set your store to maintenance mode.
    19 years a Zencart User

 

 
Page 1 of 7 123 ... LastLast

Similar Threads

  1. Replies: 3
    Last Post: 21 Jan 2016, 10:35 PM
  2. ERROR message help 1062 Duplicate entry for key 1 in db_cache
    By shartlesville in forum General Questions
    Replies: 4
    Last Post: 30 Aug 2012, 03:21 AM
  3. 1062 Duplicate entry '1-1' for key 1
    By spooky130 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 18 Jun 2011, 05:33 AM
  4. Replies: 6
    Last Post: 30 Dec 2008, 12:49 AM
  5. 1062 Duplicate entry db_cache ?
    By FoneGuy in forum General Questions
    Replies: 5
    Last Post: 30 Jan 2008, 07:42 AM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR