Blank Category Pages (2 cats only) - Missing argument 2 for cache::sql_cache_exists()

I have about 11 categories on my site and all of them except two work fine
the two that dont work when i click on them the page loads blank...
but when i de activate the products in those categories it works fine...
can anyone help???

[21-Jun-2012 10:26:41] PHP Warning: Missing argument 2 for cache::sql_cache_exists(), called in /html/includes/classes/db/mysql/query_factory.php on line 123 and defined in /html/includes/classes/cache.php on line 43
[21-Jun-2012 10:26:42] PHP Warning: Cannot modify header information - headers already sent by (output started at /html/includes/languages/black_pure_free/english.php:1421) in /html/includes/init_includes/init_templates.php on line 155
[21-Jun-2012 10:26:42] PHP Warning: Cannot modify header information - headers already sent by (output started at /html/includes/languages/black_pure_free/english.php:1421) in /html/includes/functions/functions_general.php on line 89

Can anybody help?

Open up a debug file and post that here for me to read.

ksookma:

Open up a debug file and post that here for me to read.

dude the debug file is in the original post... lol

Hi,

Can you post which version of Zen Cart you are using.

Thanks

wilt:

Hi,

Can you post which version of Zen Cart you are using.

Thanks

Version 1.5

Hi,

It looks like you have customised versions of the files, that the errors are contained in.

Do you have any contributions installed ?

wilt:

Hi,

It looks like you have customised versions of the files, that the errors are contained in.

Do you have any contributions installed ?

The Time Zone Fix
And The Testimonials module

hi,

In /html/includes/classes/db/mysql/query_factory.php

There is a line that reads

function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {

can you paste here, that line and the following 30 lines.

Note that "the time zone fix" addon is NOT needed in v1.5, because that code is already built-in. So, it could be that you're using a version of query_factory that was build for an older version of Zen Cart.

DrByte:

Note that "the time zone fix" addon is NOT needed in v1.5, because that code is already built-in. So, it could be that you're using a version of query_factory that was build for an older version of Zen Cart.

ahhhh, is there anyway to remove it then as i am unsure how to remove them

wilt:

hi,

In /html/includes/classes/db/mysql/query_factory.php

There is a line that reads

function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {

can you paste here, that line and the following 30 lines.

function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {

// bof: collect database queries

if (defined('STORE_DB_TRANSACTIONS') && STORE_DB_TRANSACTIONS=='true') {

  global $PHP_SELF, $box_id, $current_page_base;

  if (strtoupper(substr($zf_sql,0,6))=='SELECT' /*&& strstr($zf_sql,'products_id')*/) {

    $f=@fopen(DIR_FS_SQL_CACHE.'/query_selects_' . $current_page_base . '_' . time() . '.txt','a');

    if ($f) {

      fwrite($f,  "\n\n" . 'I AM HERE ' . $current_page_base . /*zen_get_all_get_params() .*/ "\n" . 'sidebox: ' . $box_id . "\n\n" . "Explain \n" . $zf_sql.";\n\n");

      fclose($f);

    }

    unset($f);

  }

}

// eof: collect products_id queries

global $zc_cache;

if ($zf_limit) {

danmiddo:

ahhhh, is there anyway to remove it then as i am unsure how to remove them
Simple: if you replaced any files when you installed the addon, then put back the original versions of those files.

DrByte:

Simple: if you replaced any files when you installed the addon, then put back the original versions of those files.

i've replaced the file again but i ran an sql...
how would i remove that?

Still hav'nt uninstalled the sql if thats what i need to do but my newest debug is this

[26-Jun-2012 10:30:55] PHP Warning: Cannot modify header information - headers already sent by (output started at /html/includes/languages/black_pure_free/english.php:1421) in /html/includes/init_includes/init_templates.php on line 155
[26-Jun-2012 10:30:56] PHP Warning: Cannot modify header information - headers already sent by (output started at /html/includes/languages/black_pure_free/english.php:1421) in /html/includes/functions/functions_general.php on line 89

Unrelated to sql.

A quick FAQ search for "headers already sent" brings up this article: http://www.zen-cart.com/content.php?129-warning-headers-already-sent

DrByte:

Unrelated to sql.

A quick FAQ search for "headers already sent" brings up this article: http://www.zen-cart.com/content.php?129-warning-headers-already-sent

Finally sorted thanks :)

DrByte:

Note that "the time zone fix" addon is NOT needed in v1.5, because that code is already built-in. So, it could be that you're using a version of query_factory that was build for an older version of Zen Cart.

I upgraded 1 site for my client from 1.3.9 to 1.5.0 and was getting this error. So I updated query_factory.php file from original zc 1.5 and it solved the problem but in ZC admin > version time zone in Central but customer is in Eastern. How I can correct this now?