Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Location
    San Juan, Puerto Rico
    Posts
    1,525
    Plugin Contributions
    9

    Default Sql Delay Issues

    PHP Version 5.2.17
    MySql: 5.1.61
    Fresh install for over a year.

    Mods Installed:
    Biggest ones: FEC, IH3, Recover Cart, Profit Margin, PriceMap

    In the past few days my customer is having the following issue:
    -when he publish/unpublish categories there's up to a minute delay to show up or disappear from the category box. It's the only "delay" he's getting. There's no delays when he insert new products, or when you put something in your cart or browse through the store; it's only on that area.

    Here's 1 of the 2 files generated on the cache error log (the other one is too long):
    ** file removed**

    Host check and they said all their databases, files, scripts are working fine and didn't find any issues at their end. Any idea of this message?
    IDEAS Girl
    IDEAS Creative Group
    = Your image... our business!
    My contributions: SophyBlue / Sophy Blue-Grey / Mistik / The Bookshelf / Dynamic Sideboxes

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

    Default Re: Sql Delay Issues

    IMPORTANT NOTE:
    The files in the /cache/ folder serve multiple purposes.
    The ONLY files related to ERRORS are those named "myDebug-xxxxxxxxxxx.log"

    EVERYTHING ELSE is NOT related to errors, and should NOT be posted publicly.

    The content you posted above has been removed.
    .

    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.

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

    Default Re: Sql Delay Issues

    Make sure your admin and non-admin configure.php files are using the SAME setting for SQL_CACHE_METHOD. Best is "none" or "database".
    .

    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.

  4. #4
    Join Date
    Aug 2005
    Location
    San Juan, Puerto Rico
    Posts
    1,525
    Plugin Contributions
    9

    Default Re: Sql Delay Issues

    The content you posted above has been removed.
    Thanks!

    YEAP! That was the issue, since I didn't install it, didn't have a clue that could be wrongly set. You are a genius!
    IDEAS Girl
    IDEAS Creative Group
    = Your image... our business!
    My contributions: SophyBlue / Sophy Blue-Grey / Mistik / The Bookshelf / Dynamic Sideboxes

 

 

Similar Threads

  1. v139h Performance issues - making sense of SQL report
    By jgold723 in forum General Questions
    Replies: 1
    Last Post: 7 Jul 2012, 11:15 PM

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