Product duplicated

[athena]

Just some weirdness.

One product, out of over a thousand products, has a duplicate in the shop, but not in the admin.

Everything, including the ID is the same.

Why would a category page pull up just one of its products twice and not the search box pull it up twice?

Not seeing this on any other category page.

I'll fix it by just deleting and re-entering it, but wonder if anyone else has seen this?

[twitchtoo]

Remember the logic needed to use computers and run code...
- there is only one product being displayed by the code twice
- the product exists as two 'duplicate' products
- the code is returning search criteria within one or multiple pages that follow written conditions within the code that are conflicting
- there is no spoon.

If we could see the page, the code or understand in detail the steps or behaviours to recreate then we can find an answer. Perhaps a corrupt db field, maybe an SQL query is returning what it sees - double.

Or maybe someone made a second product with the same name and somewhere in the cart there's an SQL query using the 'name' field and not the unique 'ID' field - This has happened to myself and my clients in the past.

[athena]

Thank you,

Here is the Category listing showing the first product there as a duplicate

iPod + Tabliet + MP3


Here is the resulting page from typing in that product into the search box or just type in the product ID 1500 or any combination. No duplicates:

eSeries

[Ajeh]

If you were to go to phpMyAdmin and search the table for:
products_id 1500

How many records are found?

What are the categories_id for those with products_id 1500?

[athena]

Just one. Thank you, Linda

[Ajeh]

If you then search the table:
products_description

for the products_id 1500 how many records to you see?

[athena]

Just one there as well. Thanks

I just checked, also, the search for "1500" and there don't seem to be any duplications of product ID in any of my tables.

[Ajeh]

Well ... for giggles and grins you could try, in phpMyAdmin, doing a repair on each of the tables ...

I do not have any idea the size of your database or tables so you may want to do just a few tables at a time ...

[athena]

OK. We'll keep an eye out to see if this should pop up again and I'll post here if so. Thanks for your time.

[twitchtoo]

I'd love to see the code that's responsible for this on your site:

  <tr  class="productListing-odd">    <td class="productListing-data" align="center"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1500"><img src="images/CAS-06507.jpg" alt="eSeries E-Reader 14" title=" eSeries E-Reader 14 " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1500">eSeries E-Reader 14</a></h3><div class="listingDescription">The E-Case brand eSeries™ E-Reader 14 masters the perfect blend of full...</div></td>    <td class="productListing-data" align="right">$34.95<br /><br />Add: <input type="text" name="products_id[1500]" value="0" size="4" /><br /><br /></td>   </tr>
  <tr  class="productListing-even">    <td class="productListing-data" align="center"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1500"><img src="images/CAS-06507.jpg" alt="eSeries E-Reader 14" title=" eSeries E-Reader 14 " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1500">eSeries E-Reader 14</a></h3><div class="listingDescription">The E-Case brand eSeries™ E-Reader 14 masters the perfect blend of full...</div></td>    <td class="productListing-data" align="right">$34.95<br /><br />Add: <input type="text" name="products_id[1500]" value="0" size="4" /><br /><br /></td>   </tr>
  <tr  class="productListing-odd">    <td class="productListing-data" align="center"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1501"><img src="images/CAS-06516.jpg" alt="iPad Case" title=" iPad Case " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="http://topkayaker.com/index.php?main_page=product_info&amp;cPath=5_44&amp;products_id=1501">iPad Case</a></h3><div class="listingDescription">Whatever you want your iPad® tablet to be: an ebook at the coast, a camera in...</div></td>    <td class="productListing-data" align="right">$39.95<br /><br />Add: <input type="text" name="products_id[1501]" value="0" size="4" /><br /><br /></td>

Let me know if you'd like to look deeper.