Product_not_found_but

[Trichome]

amanda,

 

I am having the same problem that the person whom just posted to your contribution encountered. It finds products, but doesn't display them.

 

Any Ideas?

[OceanRanch]

Just a shot in the dark.

 

Check admin->configuration->My store->Search engine Safe URL's

 

If set to true try setting it to false.

 

Tom

[Trichome]

I am using the SEF contribution w/ a few mod_ tweaks. I see that someone added a fix and I installed it. I works now, but I cannot get the manufacturers to show up.

[boxtel]

amanda,

 

I am having the same problem that the person whom just posted to your contribution encountered. It finds products, but doesn't display them.

 

Any Ideas?

<{POST_SNAPBACK}>

 

 

the query change for speed is the one in this mod, so in products_info, not in seo_cache.

 

it means change this query which gets to much info :

 

// the requested product could not be found. But we do not give up.

// Check if it was disabled and get the category id of that product

$product_check_query = tep_db_query("select pc.categories_id

from " . TABLE_PRODUCTS . " p,

" . TABLE_PRODUCTS_DESCRIPTION . " pd,

" . TABLE_PRODUCTS_TO_CATEGORIES . " pc

where p.products_status != '1' and

p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and

pd.products_id = p.products_id and

pd.products_id = pc.products_id and

pd.language_id = '" . (int)$languages_id . "'");

 

 

into this query as we only want the category id:

 

// the requested product could not be found.

// Check if it was disabled and get the category id of that product

$product_check_query = tep_db_query("select categories_id

from " . TABLE_PRODUCTS_TO_CATEGORIES . "

where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

[boxtel]

I am using the SEF contribution w/ a few mod_ tweaks. I see that someone added a fix and I installed it. I works now, but I cannot get the manufacturers to show up.

<{POST_SNAPBACK}>

 

 

to display the manufacturers, add this to the queries select clause:

 

m.manufacturers_name,