Results 1 to 10 of 136

Hybrid View

  1. #1
    Join Date
    Jun 2009
    Location
    Thessaloniki, Greece
    Posts
    41
    Plugin Contributions
    1

    Default Re: Query Cache v1.0

    Quote Originally Posted by Eric Chen View Post
    Hello, Everyone,

    I installed the plugin in my website. It seems quite good and reduce many sql query.
    without Query Cache: 2000+ queries
    with Query Cache v1.6: about 500 queries

    But it seems having a bug. My website in browser will show following wrong code when I upload a product to my store.

    1062 Duplicate entry 'ca34fbe5f9a075091ad59abf02c259a7-1' for key 1
    in:
    [INSERT INTO seo_cache (cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires) VALUES ('ca34fbe5f9a075091ad59abf02c259a7', '1', 'seo_urls_v2_products', /GbVE6QO7VPWmV2X+v2B7jb8RuacilmdVghNzVjNS1US7i1Pn/PhT/K4j2YLH6jlv7iYbBhjD6abt5uZMCymyYs0Bzt/wc=', '1', '1', 'EVAL', '2013-03-26 03:27:49', '2013-04-25 03:27:49')]

    The above wrong code only shows one time on browser, after I upload a new product into my store. And then my website is OK if I repeat to click any page. Please anyone has ever met the same issue, or any advise regarding above wrong code. Thank you in advance.

    Witch is the Zen Cart version you are using query cache?
    My Online Store thanks to Zen Cart
    If everything else fails.... read the f@#$%ing manual :)
    And always remember before any change!!! Backup to be able to go back!

  2. #2

    Default Re: Query Cache v1.0

    Quote Originally Posted by infogate View Post
    Witch is the Zen Cart version you are using query cache?
    The Zen Cart version is 1.3.8a. Thank you.

  3. #3
    Join Date
    Jun 2009
    Location
    Thessaloniki, Greece
    Posts
    41
    Plugin Contributions
    1

    Default Re: Query Cache v1.0

    Quote Originally Posted by Eric Chen View Post
    The Zen Cart version is 1.3.8a. Thank you.
    I suggest unistall V1.7 cause it is tested and works fro 1.3.9 installations and try an older version like 1.6 or 1.6.1.

    The other option is to update zencart installation :)

    If you're not upgrading for awhile, a good idea is to try one of the following tips ---> http://www.data-diggers.com/advanced...formance-tips/

    Remember before any change!!! Backup to be able to go back!
    My Online Store thanks to Zen Cart
    If everything else fails.... read the f@#$%ing manual :)
    And always remember before any change!!! Backup to be able to go back!

 

 

Similar Threads

  1. v139e Query cache AND Image cache
    By ttfan in forum General Questions
    Replies: 0
    Last Post: 3 Aug 2012, 12:18 PM
  2. Query Cache Info?
    By Miff in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 13 Dec 2011, 02:07 PM
  3. Which Query Cache for version 1.3.9d
    By alx-tc in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 28 Oct 2011, 01:34 PM
  4. Re: Simple Cache vs. Query Cache
    By matteoraggi in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 12 May 2011, 11:09 AM
  5. Simple Cache vs. Query Cache vs. Magneticone Performance Mod?
    By NBordeau in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 24 May 2010, 03:55 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