You are here:  » Missing Related Products

Support Forum



Missing Related Products

Submitted by scorpionwsm on Sat, 2007-07-14 12:16 in

Hi David,

I have done a couple of modifications to which suddenly I am missing the related products.

It is turned on in the config

It is working here http://www.worldhotels.org.uk/product/1881-for-Men-100ml-Eau-de-Toilette-Spray.html on my test site

but not here http://www.priceuk.co.uk/product/LEXMARK-X9350.html at one of my sites

Any suggestions about how to get this working again.

I think it should only be the products.php file where it should be, also html/related

I have had a look at the files, but I cant see why it's suddenly vanished.

Regards

Mark

Submitted by support on Sat, 2007-07-14 15:03

Hi Mark,

The related products are selected by the code enclosed within this IF statement in products.php

if ($config_useRelated || (!isset($product)))

...and then displayed via call from the bottom of that script:

if (isset($related)) require("html/related.php");

First, check that these are in place. If everything looks ok, try forcing that section of code, so instead of:

if ($config_useRelated || (!isset($product)))

use:

if (1)

If related products are still not displayed, the most likely variabled to have become corrupted is $q, as this is what is used to construct the SQL. Print it out just before the above code as follows:

  print "<p>Now searching for related products using search term: ".$q."</p>"

If $q does not look correct, the look for any modifications that may have changed that variable...

Hope this helps!
Cheers,
David.

Submitted by scorpionwsm on Sun, 2007-07-15 15:38

Hi David,

Now I am puzzled, I have done a fresh install, using the original PT, some some mods and edits to the database, copied everything that was working into a new folder, done a install on a clean database, using the files that I had modified and no related products.

Yet while I was adding the mods, I saw the related products come up.

Will do some more checking but I havent changed many database statements at all.

Will report more in a sec

Submitted by scorpionwsm on Sun, 2007-07-15 15:39

Sorry forgot that last one, I was on a different thread for some reason :)

Submitted by scorpionwsm on Sun, 2007-07-15 15:56

Hi David,

I have found my problem, I went through all the MYSQL changes that I made and added to my custom file.

This is the node that was causing me a problem during install

http://www.pricetapestry.com/node/1224

The fullname descriptionname (blah blah blah)

Doesn't work for some reason on a fresh install.

Not sure why though.

Regards

Mark