Whats New box selects 100 extra products than specified by "Selection of Random New Products"

Description

The query used by the Whats New box selects the number of products specified by "Selection of Random New Products", then an additional 100 products.

This is caused by an extra 1 placed after "limit".

To fix, open /catalog/includes/boxes/whats_new.php and find around line 20;
if ($random_product = tep_random_select("select p.products_id, p.prod...

At the end of this line change;
...ucts_date_added desc limit 1" . MAX_RANDOM_SELECT_NEW)) {

To;
...ucts_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) {

Environment

None

Steps to reproduce

None

Status

Assignee

Giles Marshall

Reporter

Scott Murphy

Labels

None

Severity

Minor

Components

Fix versions

Affects versions

v2.5.1

Priority

Configure