Zen Cart Logo
Forums / Basic Configuration / options_name_manager.php Error when trying to setup product attributes

options_name_manager.php Error when trying to setup product attributes

Views: 1,571

Results 1 to 8 of 8
6 Oct 2012, 12:26 PM
#1
pickman avatar

pickman

New Zenner

Join Date:
Oct 2012
Posts:
28
Plugin Contributions:
0

options_name_manager.php Error when trying to setup product attributes

I am using version 1.5.1, I setup my store and everything was working with the example products installed. I decided to delete all of the products in the database through phpmyadmin, but I may have been a bit too thorough. I can create new categories and products, but when I click on "Attributes Controller" I get the error "WARNING: An Error occurred, please refresh the page and try again." Im wondering if there is a way to restore the entire mysql database to its original empty state without reinstalling the whole system. The attributes controller page was working before I deleted the products in phpmyadmin. The command I used was:

DELETE FROM zen_customers;
DELETE FROM zen_customers_info;
DELETE FROM categories;
DELETE FROM categories_description;
DELETE FROM group_pricing;
DELETE FROM manufacturers;
DELETE FROM manufacturers_info;
DELETE FROM products;
DELETE FROM products_attributes;
DELETE FROM products_attributes_download;
DELETE FROM products_description;
DELETE FROM products_discount_quantity;
DELETE FROM products_options;
DELETE FROM products_options_values;
DELETE FROM products_options_values_to_products_options;
DELETE FROM products_to_categories;

Many thanks in advance.

6 Oct 2012, 3:43 PM
#3
pickman avatar

pickman

New Zenner

Join Date:
Oct 2012
Posts:
28
Plugin Contributions:
0

Re: options_name_manager.php Error when trying to setup product attributes

I made those changes and it has made no difference. I think I will just reinstall the whole thing and not include the sample products this time.

6 Oct 2012, 3:44 PM
#4
pickman avatar

pickman

New Zenner

Join Date:
Oct 2012
Posts:
28
Plugin Contributions:
0

Re: options_name_manager.php Error when trying to setup product attributes

Unless there is a way to reset the mysql database, I am fairly confident this is the problem.

6 Oct 2012, 7:03 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: options_name_manager.php Error when trying to setup product attributes

I am surprised that this did not fix the problem for those 3 files ...

There is a safety test on the missing TEXT option value in those three files that would cause the issue that you are having ... if this is a clean install, then you can start over without any lose of data ...

But, otherwise check that you applied those changes correctly to see if you made them right the first time around ...

6 Oct 2012, 7:28 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: options_name_manager.php Error when trying to setup product attributes

Pickman:

I think I will just reinstall the whole thing and not include the sample products this time.
That would be the best solution.

6 Oct 2012, 9:38 PM
#7
pickman avatar

pickman

New Zenner

Join Date:
Oct 2012
Posts:
28
Plugin Contributions:
0

Re: options_name_manager.php Error when trying to setup product attributes

Well I have reinstalled and the problem is has gone, if it comes back I will have to investigate in more detail. I have a html and sql backup now though so reinstalling wont take quite so long.

6 Oct 2012, 10:45 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: options_name_manager.php Error when trying to setup product attributes

Should you try to do this mass delete, do not delete from the table:
products_options_values

the record for the products_options_values for:
products_options_values_name

for the:
TEXT