URGENT: Can't add products - They disappear????

[rogerj30]

Hello,

Firstly I need to say that I'm learning as I go along. Before I started with osCommerce I'd never used PHP or SQL before.

After playing around and building most of the basic site I felt like it was time to create a test product. So I went into the catalog/admin, clicked on catagories/products, went into the first catagory (all the catagories and subcatagories were already made), then into the subcatagory. Next I clicked on 'Add product'. The new product form appeared. I filled in the necessary fields. At the bottom two buttons were visible, namely 'Preview' and 'Cancel'. As I evidently didn't want to cancel the action I pressed 'Preview'. A listing appeared in preview mode and at the top of the screen - in green - it said: " Success: File upload saved successfully."

At the bottom of this screen are three buttons: 'Back', 'Insert' and 'Cancel'. I tried both 'Back' and 'Insert' over time, it makes no difference. The product does not appear in the product list. Not in admin and not on the site. However, when I look at the site the catagory does state it's got 1 product in it, even though when you look into the catagory it will tell you there are no products to display. The testproduct also turned up in the 'what's new' box in the left column, complete with image and price, but when you click on it, it doesn't take you to the product description as it doesn't excist.

For illustration purposes I'll include this screenshot:



As you can see:
* The catagory on the left side says 1 product
* The product listing of that catagory states there are no products
* The 'What's New' box displays the image and price of the added product, but the product itself is nowhere to be found.

Oh and to make things even worse:

When I try to add the product again - it's not in the list at the end of the day I get the following error message:

1062 - Duplicate entry '0' for key 1

insert into products (products_quantity, products_ship_price, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('', '7.00', '100-10106', '49.99', null, '', '1', '0', '', '100-10106-600.jpg', now())

[TEP STOP]

Stuck between a rock and a hard place. I't not showing the products, but it's there somewhere, because it's protecting against duplicate entries....

ANd to make it more of a challange. When I create a completely new item, with never before used info it still moans about duplicate entries:

1062 - Duplicate entry '0' for key 1

insert into products (products_quantity, products_ship_price, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('', '7.00', 'Test01', '19.99', null, '', '1', '0', '', 'autocare-headerimage.gif', now())

[TEP STOP]

Did anybody have this problem before, or does anybody recognise this? I really need to know a solution for this, because obviously at the moment I can't add products to my shop.[/img][/quote]

[rogerj30]

Problem has since been solved.
I'm still stumped on one thing though. After adding products via the admin screen and then looking on the site in the catagory the products are sorted descending on product name (alphabetical). I would like that to be done on model number. Where and how do I change that?