Duplicated "new products" when they're less than 9

[moosesoom]

Hi everybody,
my shop's showing 9 new products (i think that's the default setting).
In some categories when I have only 1 (or any number of new products less then 9) new product, New Products Listing shows 2 or more copies of this product. I was looking for a solution browsing php code but I cannot find it (not yet, anyway).

Please, there's someone with same problem? any solutions out there?

[moosesoom]

I had same problem in both new and special products.
Here's a simple hack to solve it.

Fisrt copy new_products.php and specials_index.php from /includes/modules to /includes/modules/CUSTOM_TEMPLATE

(where CUSTOM_TEMPLATE is your current template name)

In both files find $row and $col variable initialization:

$row = 0;
$col = 0; 

add following line:

$mycounter = 0 

Next, find $col variable increment:

    $col ++; 

add following line:

    $mycounter ++; 

Next in specials_index.php file, find:

while (!$specials_index->EOF)  { 

and change it to:

while ( (!$specials_index->EOF) && ($mycounter < $num_products_count) ) { 

Next in new_products.php file, find:

while (!$new_products->EOF)  { 

and change it to:

while ((!$new_products->EOF) && ($mycounter < $num_products_count)) { 

That's all folks... (you may want to apply similar hacks to featured products box also...I'm pretty sure you have to modify featured_products.php the very same way)

[moosesoom]

NEW ALTERNATIVE HACK: just another solution for same problem

Tonite I was not sleeping as I should....so I spent a little bit of my time playing with another solution to this problem).

I don't know if it's less or more heavy to compute....for sure it allows you to modify just one line of involved files without declaring or using new variables:

Fisrt, copy new_products.php and specials_index.php from /includes/modules to /includes/modules/CUSTOM_TEMPLATE

(where CUSTOM_TEMPLATE is your current template name)

In specials_index.php file, find:

while (!$specials_index->EOF)  { 

and change it to:

while ( (!$specials_index->EOF) && (((($row * $col) + ((SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS - $col) * ($row - 1))) + SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS) < $num_products_count) ) { 

Next in new_products.php file, find:

while (!$new_products->EOF)  { 

and change it to:

while ((!$new_products->EOF) && (((($row * $col) + ((SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - $col) * ($row - 1))) + SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS) < $num_products_count) ) { 

That's all folks... (you may want to apply similar hacks to featured products box also...I'm pretty sure you have to modify featured_products.php the very same way)[/QUOTE]

SOME EXPLANATIONS

Every matrix element can be represented by row and column values.

Its numerical order in the matrix can be computed ad follows:

(R * C) + ((MAXC - C) * (R - 1))

Where:

     R is the row
     C is the column
     MAXC is the number of columns in our matrix

In my hack:

     R is $row variable
     C is $col variable
     MAXC is SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS and SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS constants

In ZC matrix first row and column have a value of zero, so I had to slightly modify the formula to:

((R * C) + ((MAXC - C) * (R - 1))) + MAXC

[DrByte]

Hi everybody,
my shop's showing 9 new products (i think that's the default setting).
In some categories when I have only 1 (or any number of new products less then 9) new product, New Products Listing shows 2 or more copies of this product. I was looking for a solution browsing php code but I cannot find it (not yet, anyway).

That's not normal behavior. You've likely got damaged data or damaged code causing the abnormal duplication.
I don't see any such duplication on a clean fresh new install, using demo data or adding my own products.

[moosesoom]

Thanks Dr.
The only thing (apparently) changed in news/specials products was the hack to obtain real randomness taken from http://www.zen-cart.com/forum/showth...t=70543&page=3 thread

Tomorrow I'll try the hack on a virgin test shop just to be sure....

[moosesoom]

That's not normal behavior. You've likely got damaged data or damaged code causing the abnormal duplication.

Just finished some tests.
It turned to be a consequence of the "random hack" I talked about in my previous post.