I know this addon is probably old and outdated since 2007, but I installed it and seems to be ok with adding new related products in admin. but not getting any hits on the database in the optional_related_products.php sql query. So the section does not show even though I know the database contains the corrected data. Below is the query.
$attributes = "
SELECT
pop_products_id_slave,
products_name,
products_model,
products_price,
products_quantity,
products_tax_class_id,
products_image
FROM " .
TABLE_PRODUCTS_RELATED_PRODUCTS . ", " .
TABLE_PRODUCTS_DESCRIPTION . " pd, ".
TABLE_PRODUCTS . " p
WHERE pop_products_id_slave = p.products_id
AND pd.products_id = p.products_id
AND language_id = '" . (int)$languages_id . "'
AND pop_products_id_master = '".$HTTP_GET_VARS['products_id']."'
AND products_status='1' " . $orderBy;
$attribute_query = tep_db_query($attributes);
if (tep_db_num_rows($attribute_query)>0) {
$count = 0;
?>
Thanks if anyone can help..