8 replies to this topic

[justinswa]

Hello,

OSC 2.2Rc2a

I can set up specials discounts in admin and the reduced price shows in red with the original price scored out when you look you look at the product details in product_info.php. Great. However, if you look at the product summary anywhere else  - within its category or withing the specials category, only the original and not the reduced price shows. Anybody with any ideas how I can display the special price here as well?

Thanks

[justinswa]

worth a bump.... Does anybody else have this problem or is it only me?

[justinswa]

Just me here I guess. Hello.....hello.....hello. Very echoy.

[mhvideos]

I think it is only you as my RC2a store shows the reduced prices with the original scored out in every location that the products price appears, tables specials screen etc

Sorry but I have no answer to your problem

Martin

[justinswa]

mhvideos, on 23 February 2012 - 11:26 AM, said:

I think it is only you as my RC2a store shows the reduced prices with the original scored out in every location that the products price appears, tables specials screen etc

Sorry but I have no answer to your problem

Martin

Thank you for confirming my suspicions. I have a feeling that this may have gone wrong when I changed everything to make the site php 5.3 compatible. Just have to try and find out why which will be a bit more complicated.....

[mhvideos]

Your problem could be here in

catalog/includes/functions/general.php

Find

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status");

Replace with

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status = 1");

This is listed in the update document as a Bug

Martin

[justinswa]

mhvideos, on 23 February 2012 - 07:02 PM, said:

Your problem could be here in

catalog/includes/functions/general.php

Find

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status");

Replace with

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status = 1");

This is listed in the update document as a Bug

Martin

Thanks, that was worth a try but didn't work. Could you tell me where you saw the bug reported please?

[mhvideos]

It is in the upgrade guide from 2.2 to 2.3.0

This can be found in the complete download for 2.3.1 here

http://www.oscommerce.com/solutions/oscommerce

[justinswa]

Martin, thanks for your help. Have now resolved this. I had an addon that caused the problem. There are so many addons and hacks to this installation that there's hardly any original code left. I always try and annotate my hack so I can remind myself what I have done but the addons are not always well commented...