Stumped. Showing non-existent products

[Daddyslipdisk]

Ok. I'm stumped. I've been touching up this store I've been working on and for some reason, the Home Page of the store at http://www.globechemicalcompany.com/catalog/index.php is showing broken images and pricing of $0.00 on products that don't exist. For instance, if you go to the following URL at http://www.globechemicalcompany.com/catalog/index.php, you'll see that in the section that says "New Products For August", it shows a full row of products priced at $0.00 and broken images above the pricing. When you hover the mouse over the links, it, the links point to product_id's 3298, 3299, 3300, and 3301. First off, I have no idea how to locate where these products are coming from, but it's pretty obvious that it's pulling the last entered products from the database. Secondly, there are no products with a price of $0.00. And lastly, ALL of the products (AND categories) in the store have images associated with them. Is there some line that needs to force a refresh or are there steps I need to go through to have it recalculate the product selections? I've cleared the cache files, but I have NO idea what's going on or where this is coming from. Any help would be greatly appreciated.

[Daddyslipdisk]

Allright. Once again it appears that I have been able to fixx this issue on my own. But I DO NOT suggest you try it if you're scared of MySQL or PHPMyAdmin. This problem occurs when OSC basically looks at the last product rows in the product_id database and posts those as "New Products" because they were the last ones entered.

 

Here's how I fixed it, but again, be very careful. PLEASE ALWAYS BACKUP BEFORE YOU TINKER IN HERE. Go to your store's home page and put your mouse cursor over the problem product link. Look down in the status bar window and make a note as to which product id number it is (the number at the end of the URL). Log onto your server. Go into PHPMyAdmin and select your database. On the left hand side menu, click "products". On the right hand side click the "Browse" tab. You'll then be taken to the table that has a list of all of your products that are in your store. In this case, use the drop down Page Number box at the bottom of the page and scroll down to the last page. This will take you to the last page of the table. The product you're looking for may not be on that last page, so scroll through the pages to find the product id you're having problems with. Find the product id number and click the red X at the beginning of that row. That will delete the offending product. Problem fixed.

 

PLEASE ALWAYS BACKUP BEFORE YOU TINKER IN HERE.