FrankCRFG Posted April 15, 2009 Share Posted April 15, 2009 Any one else have this issue? I have been looking at the Products Extra Fields contribution http://addons.oscommerce.com/info/2202 The installation instructions do not appear to be correct for the Product Extra Fields 2.0j version for doing a clean install. I have osCommerce Online Merchant v2.2 RC2a. - clean install -(2.2 Release Candidate 2a + buySAFE) On one part of the instructions state 8. catalog/advanced_search_result.php Replace the following (approx on line 221): $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; BUT my has $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "; if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) { $select_str .= ", SUM(tr.tax_rate) as tax_rate "; } $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) { if (!tep_session_is_registered('customer_country_id')) { $customer_country_id = STORE_COUNTRY; $customer_zone_id = STORE_ZONE; } $from_str .= " left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')"; } $from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; It is not the same. ALSO Even though section 9 and on may be need only if upgrading, it seems it should be stated so. Section 9 9. admin/includes/functions/general.php New chapter since v1.3 Find function tep_remove_product. Inside this function find: tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where products_id = '" . (int)$product_id . "'"); and immediately after add: // START: Extra Fields Contribution tep_db_query("delete from " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " where products_id = " . (int)$product_id); // END: Extra Fields Contribution This is not in the oscommerce file. also Section 10 refers says 10. catalog/advanced_search.php Find the lines at the top of the file that read as follows: <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript" src="includes/general.js"></script> a line with <script language="javascript" src="includes/general.js"></script> does not exist the 1st one does. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.