Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Items shown duplicated in listings if linked to multiple categories?


eth72

Recommended Posts

Posted

Hi Everyone,

I just moved an osc site built years ago to a new server. Not sure if it was just discovered, or if this way all along, but if I set a product up and then copied (via "Copy To") that product to another category (or more), it shows up multiple times when selecting a particular category. In the database and back end, the product is correctly listed once. The site I built was www.thecopperhouse.com - if I click on "arts & crafts lights", the first product that shown is listed twice because that item is also linked to "arts and crafts lights". Both items listed link to the same exact item, same URL. Unfortunately I've installed so many addons, SEO features, etc., I can't tell what might be causing it. I would hope some kind of "distinct" select statement would prevent these duplicates from listing... If I do a query for the same item through the search function, it only shows up as once, just the way it should... Thinking the problem is in the index or categories.php file... I hope this all makes sense. I've seen others report the same issue, but can't find any solution... Pic of listing is attached...post-92808-0-09165000-1321246381_thumb.jpg Any advice is appreciated!

Tx,

Scott

Posted

Guess I should have mentioned that! 2.2-MS2

Tx,Scott

Server OS: Linux 2.6.18-274.3.1.el5 Database: MySQL 5.1.56 Server Date: 11/14/2011 13:25:43 Datebase Date: 11/14/2011 13:25:43 Server Up Time: 13:25:43 up 44 days, 21:54, 3 users, load average: 2.49, 2.44, 2.34 pixel_trans.gifHTTP Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 PHP Version: 5.3.8 (Zend: 2.3.0)

osCommerce 2.2-MS2

Posted

did you actually link them or copy them, as you said in your post?

 

check your database, or hover over the items in the listing.

are the products_ids different?

 

did you ever change the listing selection to show items from several categories?

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted

I believe I "copied to". The product_ids are exactly the same-shouldn't the SQL query prevent duplicate product_ids? Going into the back end under certain areas (specials categories), they're showing up as duplicates as well. A few other things to note-we've used the SEO plugin and virtually every item is a "special" at 15% off, not sure if some inner/outer join is producing duplicates. I'm really stumped. Any other input is appreciated!

Scott

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...