Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Cannot Delete Default Products and Categories


Guest

Recommended Posts

After a clean install because of the same problem, I still cannot delete the default product categories or products from the store. What is going on? I click on the product category "hardware" and then hit the delete button. It then asks me if I'm sure I want to delete it and i click delete again, but then the categories reset and it's still there! Any help would be greatly appreciated.

 

I setup the store to write to a database rather than files during installation if that makes any difference. Thanks.

The whole installation went smoothly, so I don't know where the problem is. This all happened after I installed an SSL certificate on the site. The store worked fine before the SSL and clean install.

 

-Aberrant

Link to comment
Share on other sites

Before you can delete a category you have to delete all products and sub categories first

 

Robr

 

 

Tried that. When i go into a category and select a sub category to delete that has no products linked to it, I hit the delete button, the page refreshes, but it stays there and in the online store as well.

 

I have re-installed 3 times and nothing is working.

 

 

-A

Link to comment
Share on other sites

perhaps your mysql account does not have delete rights...

make sure you can delete records using the mysql account set in your /catalog/admin/includes/configure.php file

 

Ok, well here is my config file code. I added 'mysql' at the bottom and it didn't help. I believe this is a SSL issue, because everything worked fine before i setup the SSL on my server.

 

 

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://anancybooks.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://anancybooks.com');

define('HTTPS_CATALOG_SERVER', 'https://www.anancybooks.com');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/kunden/homepages/40/d174341887/htdocs/catalog/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/kunden/homepages/40/d174341887/htdocs/catalog/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/catalog/'); // absolute path required

define('DIR_FS_CATALOG', '/kunden/homepages/40/d174341887/htdocs/catalog/'); // absolute path required

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

define('DB_SERVER', '########'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', '######');

define('DB_SERVER_PASSWORD', '#####');

define('DB_DATABASE', '#######');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

Link to comment
Share on other sites

Ok, so what i've found out is that if i delete my .htaccess file in my home directory outside of the catalog directory, my store goes back to being http:// rather than https:// and i can delete products and categories. The .htaccess file I have on my server is so that the site is only accessible through https:// . It is essentially a redirect and I'm not sure why this would be causing the problem. I want to have the site only accessible through https:// however so how do I get around this? Is there some code I can place into the .htaccess file in my home directory? I hope all that makes sense...

 

Here is the code for the .htaccess file:

 

RewriteEngine On

RewriteCond %{SERVER_PORT} !^443$

RewriteRule ^(.*)$ https://www.anancybooks.com/$1 [R]

 

I have hosting through 1and1 if that makes any difference or if anybody has had similar issues working with them.

 

 

-A

Link to comment
Share on other sites

Anybody have any suggestions? I don't know where else to find this information and don't want my question to be lost in this sea of questions.

 

Thanks.

 

-A

Link to comment
Share on other sites

  • 3 months later...
After a clean install because of the same problem, I still cannot delete the default product categories or products from the store. What is going on? I click on the product category "hardware" and then hit the delete button. It then asks me if I'm sure I want to delete it and i click delete again, but then the categories reset and it's still there! Any help would be greatly appreciated.

 

I setup the store to write to a database rather than files during installation if that makes any difference. Thanks.

The whole installation went smoothly, so I don't know where the problem is. This all happened after I installed an SSL certificate on the site. The store worked fine before the SSL and clean install.

 

-Aberrant

 

I know this post is from a year ago, but I had recently asked about the same problem on this forum. The problem apparently has to do with the categories.php file. I have a really good hosting company (IVC Hosting) who have worked hard to resolve this issue for me, and they had to re-write the categories.php file to make it work with their server. If someone can tell me how to upload the edited file, I'd be glad to share it with you. Chances are it might work for you, but I can't guarantee it as it was custom edited to work with my hosting company.

 

Best regards,

Elli

Link to comment
Share on other sites

Ok, so what i've found out is that if i delete my .htaccess file in my home directory outside of the catalog directory, my store goes back to being http:// rather than https:// and i can delete products and categories. The .htaccess file I have on my server is so that the site is only accessible through https:// . It is essentially a redirect and I'm not sure why this would be causing the problem. I want to have the site only accessible through https:// however so how do I get around this? Is there some code I can place into the .htaccess file in my home directory? I hope all that makes sense...

You should not be using an htaccess file to make your store available over an https:// connection and you certainly shouldn't be doing any redirection to make this happen. Why do you want your store to be only availalbe over https:// anyway?? This has an adverse affect on performance and is totally unneccasary. The only sections that need https:// are the account and checkout pages. This is acheived by setting ENABLE_SSL in your config files to TRUE.

 

Set your configure.php files (the store one and the admin one) to use SSL properly, remove the .htaccess and your problem will be solved.

Link to comment
Share on other sites

The only sections that need https:// are the account and checkout pages.

 

just a comment about it. When the customer is logged in, it is not wise to allow him going into non-SSL pages. Because certain session variables can be transmitted in non-ssl pages related with the customer account (so no encryption there). So once the customer logs-in you should maintain SSL till he logs out. Not just the checkout pages.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...