Error 404 - Adding New Product

Let's try again ...

The table called product_types when you browse it looks something like this:

type_id type_name type_handler type_master_type allow_add_to_cart default_image date_added last_modified
1 Product - General product 1 Y 2006-09-20 22:32:57 2006-09-20 22:32:57
2 Product - Music product_music 1 Y 2006-09-20 22:32:57 2006-09-20 22:32:57
3 Document - General document_general 3 N 2006-09-20 22:32:57 2006-09-20 22:32:57
4 Document - Product document_product 3 N 2006-09-20 22:32:57 2006-09-21 17:02:52
5 Product - Free Shipping product_free_shipping 1 Y

What do you see when you browse your product_types table?

INSERT INTO success_product_types VALUES (1, 'E-Books', 'E-Books', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:31');
INSERT INTO success_product_types VALUES (2, 'Paperback Books', 'Paperback Books', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:37');
INSERT INTO success_product_types VALUES (3, 'Hardbound Books', 'Hardbound Books', 3, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:44');
INSERT INTO success_product_types VALUES (4, 'CD''s', 'CD''s', 3, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:05:19');
INSERT INTO success_product_types VALUES (5, 'Video - VHS', 'Video - VHS', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:05:26');

There, thanks for the clarification of what you needed. I am still learning....of course, that never stops....hopefully...~V

And you wrote all of the code to go with those Product Types so that your Admin and Catalog both can work?

Ajeh:

And you wrote all of the code to go with those Product Types so that your Admin and Catalog both can work?

I didn't write any code. this is exactly what I downloaded and uploaded from the patch.

Let's try another approach ...

What patch is it that you added? I am assuming you are referring to some type of add-on?

Sorry my wording is bad...

This was a manual install with no add-ons. It was from the get Zen Cart link above.

V

Where did you get those Product Types from?

They do not come with Zen Cart and you cannot just haphazardly make up your own without designing them ...

Ajeh:

Where did you get those Product Types from?

They do not come with Zen Cart and you cannot just haphazardly make up your own without designing them ...

I went and changed these through the admin panel, not via the database itself.

Those records in the product_types table build the base building blocks to the filenames, configuration keys, variables, constants, etc.

You cannot just pick them out of a hat unless you have written the code for the Catalog and Admin to work with them ...

Then there is the associated tables that go with these Product types ...

Is this a clean installation of Zen Cart v1.3.5 or an upgrade or what?

Ajeh:

Those records in the product_types table build the base building blocks to the filenames, configuration keys, variables, constants, etc.

You cannot just pick them out of a hat unless you have written the code for the Catalog and Admin to work with them ...

Then there is the associated tables that go with these Product types ...

Is this a clean installation of Zen Cart v1.3.5 or an upgrade or what?

I never personally did anything to the "tables." I do not know enough of mysql to even attempt that. The data that is there is similar to what I used in the admin -> catalog -> product types that I made to reflect the product types that will be listed in the cart.

Yes, this was a clean manual install following the directions to the t.

If you made no changes, then what is this?

INSERT INTO success_product_types VALUES (1, 'E-Books', 'E-Books', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:31');
INSERT INTO success_product_types VALUES (2, 'Paperback Books', 'Paperback Books', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:37');
INSERT INTO success_product_types VALUES (3, 'Hardbound Books', 'Hardbound Books', 3, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:04:44');
INSERT INTO success_product_types VALUES (4, 'CD''s', 'CD''s', 3, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:05:19');
INSERT INTO success_product_types VALUES (5, 'Video - VHS', 'Video - VHS', 1, 'Y', '', '2006-09-26 10:32:20', '2006-10-02 01:05:26');

Ajeh:

If you made no changes, then what is this?

I dont think you read my last post correctly. I made customized adjustments through the ADMIN area. If I am understanding you correctly you I am not supposed to make changes AT ALL to that area even though it allows it through the Admin area? If that is the case, why is that option available? I thoroughly confused and feel like I customization changes that I made through a viable area (and not directly to the database) shouldn't have put me in this position.

SO...if the Product-Types table is screwy then is there a recommended way to put it back to it's default ?