Sql Delay Issues

1 Jun 2012, 5:07 AM

#1

IDEASLady

Totally Zenned

Join Date:: Aug 2005
Location:: Trujillo Alto, Puerto Rico
Posts:: 1,456
Plugin Contributions:: 4

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? :blink:

IDEASLady
IDEAS Creative Studio

Your image... our business!

1 Jun 2012, 6:24 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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.

1 Jun 2012, 6:26 AM

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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.

1 Jun 2012, 2:28 PM

#4

IDEASLady

Totally Zenned

Join Date:: Aug 2005
Location:: Trujillo Alto, Puerto Rico
Posts:: 1,456
Plugin Contributions:: 4

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! :smartalec:

IDEASLady
IDEAS Creative Studio

Your image... our business!