New Products show ALL products - Workaround Not Working

10 Sep 2006, 7:27 AM

#1

New Zenner

Join Date:: Mar 2006
Location:: Durham, UK
Posts:: 78
Plugin Contributions:: 0

New Products show ALL products - Workaround Not Working

Workaround for New Products show ALL products regardless of settings

Have edited /includes/functions/functions_lookups.php as instructed but result is that New Products are removed entirely from centre module, sidebox and Categories box in both upgraded and fresh installations.

INSTALLATIONS:
Fresh 1.3.0.2 Upgraded to 1.3.5 (09042006)
Fresh 1.3.5 (09042006)

10 Sep 2006, 1:41 PM

#2

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: New Products show ALL products - Workaround Not Working

Check and see if the 120 works for you and the 7 ... I think I see why I left in that itty bit of code ... :rolleyes:

10 Sep 2006, 2:33 PM

#3

imac

New Zenner

Join Date:: Mar 2006
Location:: Durham, UK
Posts:: 78
Plugin Contributions:: 0

Re: New Products show ALL products - Workaround Not Working

Ajeh:

Check and see if the 120 works for you and the 7 ... I think I see why I left in that itty bit of code ... :rolleyes:Apply patch to virgin 1.3.5 install.
Set New Product Listing - Limited to ...
0 - New Products boxes and Categories link vanish
7 - ditto
14 - ditto
30 - ditto
60 - ditto
90 - ditto
120 - ditto

Hey! If it was that easy everybody would be doing it :cool:

10 Sep 2006, 2:36 PM

#4

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: New Products show ALL products - Workaround Not Working

I have a re-write for the New Products test so that the what of is a new product now produces a blazingly fast query vs the old methods ...

http://www.zen-cart.com/forum/showthread.php?p=259165#post259165

Tests on a 700,000 product database use to take forever ... as in 30-60+ seconds and now take 0.2 seconds to 2.0 seconds for this query depending on the server ...

Somewhere in the processes of writting this I must have gotten interrupted and never got it cased out for the 2 oddities of All and Current month ...

Thanks for your patiences on this ... let me know if you have further problems ... :cool:

10 Sep 2006, 3:00 PM

#5

imac

New Zenner

Join Date:: Mar 2006
Location:: Durham, UK
Posts:: 78
Plugin Contributions:: 0

Re: New Products show ALL products - Workaround Not Working

Ajeh:

I have a re-write for the New Products test so that the what of is a new product now produces a blazingly fast query vs the old methods ...

http://www.zen-cart.com/forum/showthread.php?p=259165#post259165 That looks like a worker. Thanks again Linda. :thumbsup: How many coffees do I owe you now?
Ajeh:

Thanks for your patiences on this ... let me know if you have further problems ... :cool:You're helping sort out people's problems on a Sunday morning for free. What's not to be patient about? :smile:

10 Sep 2006, 3:35 PM

#6

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: New Products show ALL products - Workaround Not Working

Coffee keeps Zen Cart humming along ...

Glad this solution has taken care of the problem ... :smile: