Jump to content
Sign in to follow this  
FrankCRFG

Products Extra Fields, Products Extra Fields installation problems

Recommended Posts

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.

Go to the top of the pageReport Post

 

 

Any one have correct instructions?

Of at least option for other contributions that make it easier to add fields

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×