Unable to add new products

Hello!

I stumbled upon Zen Cart and thought it would be a good addition to my personal photography website. I have a lot of pictures to sell and want to get started on making product pages for all of them, but I'm currently stuck...

Whenever I go to Categories/Products under the Catalog drop-down in the admin tools, and then click on one of the categories I've made, and then click the "New Product" button, I am taken to a generic "This page does not exist" page. I've looked everywhere on the forums and FAQs for an answer as to why this is happening, but everyone seems to be able to add products just fine...

I think I may have screwed something up by renaming the product types: they were originally "default_product" and "music_product" or something like that, and I changed those in Product Types in the Catalog drop-down.

If anyone has any ideas I would love to hear them! Until I can figure this out I'm pretty much stuck :dontgetit

Don't rename those as they are used to build the pages from the files that match the naming pattern or you do, you will be doomed ... :eek:

You can put back the original info, or if you cannot recall what the settings are for the product_types

To fix the product_types table, run this in the Tools ... Install SQL Patches ...

This will remake the table ...

DROP TABLE IF EXISTS product_types;
CREATE TABLE product_types (
  type_id int(11) NOT NULL auto_increment,
  type_name varchar(255) NOT NULL default '',
  type_handler varchar(255) NOT NULL default '',
  type_master_type int(11) NOT NULL default '1',
  allow_add_to_cart char(1) NOT NULL default 'Y',
  default_image varchar(255) NOT NULL default '',
  date_added datetime NOT NULL default '0001-01-01 00:00:00',
  last_modified datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (type_id),
  KEY idx_type_master_type_zen (type_master_type)
) TYPE=MyISAM;

Then run this to add back the default Product types ...

INSERT INTO product_types VALUES (1, 'Product - General', 'product', '1', 'Y', '', now(), now());
INSERT INTO product_types VALUES (2, 'Product - Music', 'product_music', '1', 'Y', '', now(), now());
INSERT INTO product_types VALUES (3, 'Document - General', 'document_general', '3', 'N', '', now(), now());
INSERT INTO product_types VALUES (4, 'Document - Product', 'document_product', '3', 'Y', '', now(), now());
INSERT INTO product_types VALUES (5, 'Product - Free Shipping', 'product_free_shipping', '1', 'Y', '', now(), now());

NOTE: back up your database before making changes like this ...