Problem is items that i can't delete

http://ad-discountperformance.com/index.php?main_page=product_info&cPath=649&products_id=2590

http://ad-discountperformance.com/index.php?main_page=product_info&cPath=649&products_id=5483

http://ad-discountperformance.com/index.php?main_page=product_info&products_id=5466:78757d621885ec1e46491e0109f41bde

These 3 items can't be found in our admin. i need to delete them and i don't know how.

Thanks

Dashizna:

... These 3 items can't be found in our admin. ...
It appears someone may have "deleted" or "disabled" the category which contains the products listed (category 649). If the category was deleted, "browsing" the catalog in the administrative interface may not show the products (because there is no category for them).

On the administrative interface for the catalog, have you tried searching for the product_id (for example 2590)?

lhungil:

It appears someone may have "deleted" or "disabled" the category which contains the products listed (category 649). If the category was deleted, "browsing" the catalog in the administrative interface may not show the products (because there is no category for them).

On the administrative interface for the catalog, have you tried searching for the product_id (for example 2590)?

in the admin section there is no category turned off and I turned off all of them to see if the products would show up but nothing did

Dashizna:

in the admin section there is no category turned off and I turned off all of them to see if the products would show up but nothing did

lhungil:

On the administrative interface for the catalog, have you tried searching for the product_id (for example 2590)?

Have you tried typing 2590 into the search box in the admin as suggested?

yes nothing shows up

Go to phpMyAdmin and search the tables:
categories
categories_description

for the categories_id 649 ... Do you find anything?

yes it did show up can I just hit delete there?

Was your site upgraded from Zen Cart < 1.5?

yes from 1.3.9h to 1.5.1

Zen Cart 1.5.1

Database Patch Level: 1.5.1
v1.5.1 [2012-10-11 10:13:50] (Version Update 1.5.0->1.5.1)
v1.5.1 [2012-10-11 10:13:25] (Version Update 1.5.0->1.5.1)
v1.5.0 [2012-10-11 10:13:25] (Version Update 1.3.9->1.5.0)
v1.3.9h [2012-10-11 10:13:24] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-11-11 21:22:52] (Version Update 1.3.7->1.3.8)
v1.3.7 [2007-09-14 09:46:09] (Version Update 1.3.6->1.3.7)
v1.3.6 [2006-12-11 16:15:48] (Version Update 1.3.5->1.3.6)
v1.3.5 [2006-12-11 15:40:49] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2006-12-11 15:40:45] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2006-07-19 15:43:21] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2006-07-19 14:22:03] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-03-06 12:04:22] (Fresh Installation)

Dashizna:

yes it did show up can I just hit delete there?

In the categories table, what is the parent_id?

If it is not 0, do you have a Category in both the tables:
categories
categories_description

for that parent_id category?

here is the info I have

Could you search the two tables:
categories
categories_description

and see if you have a categories_id 1032 and if so, what its parent_id is ...

Dashizna:

...
v1.5.1 [2012-10-11 10:13:50] (Version Update 1.5.0->1.5.1)
v1.5.1 [2012-10-11 10:13:25] (Version Update 1.5.0->1.5.1)
v1.5.0 [2012-10-11 10:13:25] (Version Update 1.3.9->1.5.0)
v1.3.9h [2012-10-11 10:13:24] (Version Update 1.3.8->1.3.9h)
...
So this was an upgrade from Zen Cart 1.3.8 to 1.5.1...
Did the problems start recently or is this the first time you've tried to find / delete products?
Are there any Zen Cart "debug" logs? PHP error logs? Server error logs?

It may be worth going through the instructions here to determine how your site differs from a stock installation of Zen Cart 1.5.1... You might also try copying a "clean" copy (no modifications) of the Zen Cart admin folder to your site, edit / create the "/admin/includes/configure.php" file (can copy dist-configure.php and edit), rename to something like "Hy4erEd61", and then see if the issue persists when using the newly uploaded "clean" copy of the admin folder.

It is almost always better to fix the actual cause, rather then just applying quick patches... Going through the above and checking the items Ajeh recommends are good ways to help narrow down the actual cause of certain products and categories not appearing in the Zen Cart administrative interface (so it can be fixed).

But if you really need a quick patch, you can manually disable the products using phpmyadmin. With the stock code and settings for Zen Cart 1.5, this will cause the product to no longer be displayed... And then you can continue to look into what on your site has been modified and is causing the issues you are experiencing.

UPDATE `products` SET `products_status`='0' WHERE `products_id`='2590';

NOTE 1: Make sure your Zen Cart "admin" folder uses a unique name (not the one supplied here as an example). This "helps" improve security (slightly - by obscurity). There are some additional security recommendations in the Zen Cart documentation, manual, and wiki.

NOTE 2: Unrelated to the issue at hand, but thought I'd let you know... I personally would not shop your site as you are using "infolink ads"... I dislike how they add "links" into the existing text of a page (very similar appearance as some malware in the past)... I find these annoying, distracting, not useful, and sometimes even misleading... But just my opinion...

Could you also check the two files, on the server, for:
/includes/configure.php
/your_secret_admin/includes/configure.php

and ensure that they are both using the same database and paths?

NOTE: be sure to check the files on the server for your site ...