This is a discussion on Cross Sell product Prioritization within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; There appears to be an error in the file: catalog/includes/modules/xsell_products.php $xsell_query (line 14) is currently: $xsell_query = tep_db_query("select distinct p.products_id, ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| There appears to be an error in the file: catalog/includes/modules/xsell_products.php $xsell_query (line 14) is currently: $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, m.manufacturers_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and m.manufacturers_id = p.manufacturers_id and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); this should be: $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, m.manufacturers_name, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and m.manufacturers_id = p.manufacturers_id and p.products_status = '1' order by xp.sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED); |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| Submit it to the bugtracker - explain the error/problems and post the fixed code there.
__________________ JPF - osCMax Fourm Moderator Try out our osCMax at: Live Catalog Demo Limited access Admin: Live Admin Demo Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped! |
|
#3
| |||
| |||
| Now submitted. Also, please ignore above code as I had previously modified it to include the manufacturer's name. The code submitted to the bugtracker relates to the original downloaded in V2RC2. |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cross Sell interface... can you add a search function? | taol | osCMax v2 Customization/Mods | 1 | 12-15-2005 12:28 PM |
| Cross Sell Problem | warrenthewindmill | osCMax v1.7 Discussion | 4 | 12-03-2003 08:00 AM |
| X-Cross shows 6 products, how about 9 | peter | osCommerce 2.2 Modification Help | 0 | 11-21-2003 11:43 AM |
| Cross Sell not working | Anonymous | osCMax v1.7 Discussion | 27 | 11-10-2003 11:29 AM |