Help? Newest listings on homepage showing ALL Listings

[zman78]

Hello,
I am trying to limit the newest listing limit to 20 on my home page. It keeps showing all of them!

here is my hom.tpl file sectio for newest listings:

{new_listings number=20 table_attr='width="100%" style="border: 1px solid #000;"' td_attr='valign="middle" align="left"' img_break="

Shouldnt this show 20?

Zack

[Chaslie]

zman78,
Agreed - there is certainly a problem with this - please be patient whilst it is been addressed.

Have added this to the 'Bug Tracker'.

In the meantime, if required, you may wish to disable your 'new listings' feature until a fix is organised.

[Maffo]

I ran into this problem a while ago.

A crude fix is if you open,

includes/classes/smarty/plugins/function.new_listings.php and look for this piece of code.

PHP Code:

 $sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC "; 


you can add LIMIT 20 to the end of the statement

PHP Code:

 ORDER BY p.dateadded DESC LIMIT 20"; 


Its not the ideal solution but it will get you through until this issue is resolved.

[zman78]

I really dont mind it showing all of them for now, im just concerned for when i reach like 100 listings. Until then I am being patient!

Thanks!

Zack

[Eric Barnes]

v3.1.2 has this now fixed.

[Chaslie]

Thanks Maffo - appreciated.