Click on Product gives 404 Error

[apster]

Hello.

Ok, so I've slipped up somewhere and really need your help now.

Everything was going beautifully, setting up the shop, http://www.a-p-s.org.au/join

Then, for some reason now when I click on a Product it comes up with a 404 error page and doesn't show the description of the Product.

Could someone please lead me in the right direction.

Thanks, loads.

Mel

[Ajeh]

You appear to have changed, deleted or otherwise altered the product_types table so that it does not know what file is associated with the product ...

First, browse your database table for products via phpMyAdmin ... do you have products_type set with values? (defaults would be 1 thru 5)

Next, browse your database table for the product_types ... there should be 5 listed for:

type_id type_name type_handler type_master_type allow_add_to_cart default_image
1 Product - General product 1 Y
2 Product - Music product_music 1 Y
3 Document - General document_general 3 N
4 Document - Product document_product 3 Y
5 Product - Free Shipping product_free_shipping 1 Y

Are these in there? Did you change anything?

[apster]

Hi Ajeh
Thank you for helping.

I checked out PhpMyAdmin.

Does this answer your query about the product_type values?

Host: localhost
Database: apsorgau_zc1
Generation Time: May 26, 2007 at 11:31 AM
Generated by: phpMyAdmin 2.10.0.2 / MySQL 5.0.27-standard
SQL query:
SELECT COUNT( * ) AS `Rows` , `products_type` FROM `zen_products` GROUP BY `products_type`
ORDER BY `products_type` LIMIT 0, 30 ;
Rows: 1
Rows products_type
11 1

And I have attached a pdf of the the products_type.

Sorry, but not really sure about PhpMyAdmin.

Thanks again, Ajeh.

Mel

[Ajeh]

Browse the table:
product_types

What do you see?

[apster]

Hi Ajeh

Looks like I don't have products_type but I do have product_types

The table product_types has:

1 0 0 1 Y
2 Product - Music product_music 1 N
3 Document - General document_general 3 N
4 Document - Product document_product 3 N 2
5 Product - Free Shipping product_free_shipping 1 N

Mel

[Ajeh]

You broke it ...

You removed, or deleted all the information on Product General from the products_type table ...

To fix this, you can run the following commands in the Tools ... Insert SQL Patches ...

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;

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()); 

What this will do is fix all of the Product Types back to the default settings so that they can work ...

First, backup your database just incase you moof up ...

Then run that command to remake the product_types table with the original settings so your site can run ...

Unless you know why you are changing this table and its settings ... leave it set to its defaults ...