Cache Error

[BlessIsaacola]

Our add to cart wasn't working for a few hours this morning and really wasn't sure what was going on. Looking into the error logging file shows this error:

[28-Apr-2010 05:18:12] PHP Warning: filemtime() [<a href='function.filemtime'>function.filemtime</a>]: stat failed for /DELETED/DELETED/public_html/cache/FILENAME.sql in /DELETED/DELTED/public_html/includes/classes/cache.php on line 59


Line 59 reads:

if (filemtime(DIR_FS_SQL_CACHE . '/' . $zp_cache_name . '.sql') > (time() - $zf_cachetime)) { 

Not exactly sure what caused this but it was a show stopper since our customer couldn't add to cart. The screen just hangs.

I rebooted mysql server and everything is working fine again. Wanted to post just in case something is obvious that might be wrong with line 59.

Thanks!

[DrByte]

"stat failed" means the server's filesystem refused to disclose information about the file to the script which was asking for it.
Thus, when filemtime() attempted to check the file's timestam, it threw that error.

Possible workarounds:
a) work with your hosting company to fix the permissions problems preventing it from working
b) change your caching method to 'database' or blank instead of 'file'

[BlessIsaacola]

"stat failed" means the server's filesystem refused to disclose information about the file to the script which was asking for it.
Thus, when filemtime() attempted to check the file's timestam, it threw that error.

Possible workarounds:
a) work with your hosting company to fix the permissions problems preventing it from working
b) change your caching method to 'database' or blank instead of 'file'

Thanks DrByte for the prompt response. I trying to read in the FAQ about the different cache methods file, database, blank and wasn't able to find enough information.

Can you either explain or point me to where I can find out which option is best.

Why would I use database versus file or none.

We have a lot of products on our site as well categories, is one setting better than the other?

Thanks!

[DrByte]

The SQL caching affected by this ONLY affects your admin configuration switches. Thus, disabling that caching will typically cause almost no noticeable effect.

You can make the change in your configure.php files.

[BlessIsaacola]

Thanks! In our case it seems like the database option might be the happy medium. When I set it to "none" the query on product page almost double and the query time increase a little bit. Storing it in database reduces parse time but queries and query time went up a bit.

For now I am going to leave it set as "database" and observe to see how things play out.

[BlessIsaacola]

DrByte, thought I did post this for you to set me straight again :)

This is the latest error I received:

[28-Apr-2010 16:06:52] PHP Warning: require(includes/index_filters/default) [function.require]: failed to open stream: No such file or directory in /*/*/public_html/includes/modules/pages/index/header_php.php on line 49
[28-Apr-2010 16:06:52] PHP Fatal error: require() [function.require]: Failed opening required 'includes/index_filters/default' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /*/*/public_html/includes/modules/pages/index/header_php.php on line 49

Line 49 reads:

require(DIR_WS_INCLUDES . zen_get_index_filters_directory($typefilter . '_filter.php')); 

Is this another one of those permission issue and if so what permission is needed?

Thanks!

[DrByte]

No, that's a bad product type set in your products. Completely unrelated.

[BlessIsaacola]

No, that's a bad product type set in your products. Completely unrelated.

Say what? You're funny DrByte! Like I am really going to know what that means. Are you saying is possible to have a single product with wrong product_type? How would I even start to find which product it might be out of 15,000+ products?

DrByte, this is your fault, now I see everything wrong on our site because of the cool error logging introduced in 1.3.9a of course you know I love this tool.

[DrByte]

What files do you have in your /includes/index_filters/ folder?
And are there any subfolders? if so, what's in those?

[BlessIsaacola]

What files do you have in your /includes/index_filters/ folder?
And are there any subfolders? if so, what's in those?

I have the following 3 files:

1. 1. record_company_filter.php
   2. music_genre_filter.php
   3. default_filter.php