Product images:" no_picture.gif"

[Tswift42]

Crazy -


Before I ran the query I did a backup...


Ran query and it is set to No Image Picture

Still the same...

Ok did a test...

I let the no image section under admin/images "Product Image - No Image picture" left it blank.

What I determined is when I do a product upload and leave the v_products_image
blank in my cvs file it will do it correctly and not display the no_picture.gif.

Thats great and all but, I need to remove the no_picture.gif reference to all the other 3000+ products that I have already uploaded.

any ideas?

THank for your help

Tom

[Tswift42]

My problem is when I upload my products I did not specify a pic during the up unless there was a picture associated with the product the I would add the file name to my cvs file.

Everything works great. With the exception that the files that have no picture Zen would by default attach "no_picture.gif" on all images that I did not attach a picture in my products.

So to solve this problem is to go to the admin\configuration\images, the 22nd to the last option is (Product Image - No Image Picture) you click on this and edit and take out no_picture.gif in the edit field..Right..Perfect..

Well this function does not work for me. But what it does do is when I upload another cvs file that has no image it does it's job and puts no image in the product list. Great.

But I have 1200 product that are now associated with no_picture.gif, and to save my life I can't get it removed.

I have tried reloading the cvs file with again no image association and the no_picture is showing up under that product.

So to PhPadmin I go, and found the location to the product files. But to remove all this in PhP I would have to do it by hand...

So question, is this a BUG...

And can some one assist me creating a query that would remove everything associated with no-picture.gif...

I would appriciate it very much...


FYI deleting the no_picture.gif from the images folder does not fix the problem. The file association is still there, and it seems hard coded...

TOm

[DrByte]

So ... if there's no picture associated, what do you want Zen Cart to do?
Keep in mind that product images are used in many places:
- product listings
- sideboxes
- product-detail pages
- shopping cart
- etc

If there's no picture, what do you want instead?

[wizardman]

Why not replace the no-picture.gif file with a blank gif file with the same name that matches with your background color?

[DrByte]

If you're saying that many of your products have "no_picture.gif" IN THE DATABASE as the contents of the products_image field, then you could wipe that out by running the following SQL query via phpMyAdmin:

update products set products_image='' where products_image='no_picture.gif';

Note: that '' is two single quotes...

[Ajeh]

After following DrByte's fix to the products_image field ...

Also set the setting in the Images to not use the no_picture.gif when nothing is set:

Product Image - No Image Status
Use automatic No Image when none is added to product
0= off
1= On

[Tswift42]

If you're saying that many of your products have "no_picture.gif" IN THE DATABASE as the contents of the products_image field, then you could wipe that out by running the following SQL query via phpMyAdmin:

update products set products_image='' where products_image='no_picture.gif';

Note: that '' is two single quotes...

Byte, in PhpAdmin, I do a search for no_picture.gif and I find the location of the association to products. And in this search it finds the 1200 products that have no_picture.gif.

Now when I run your script will it remove only that information where the no_picture.gif is attached to those products?

Thanks
Tom

[DrByte]

Now when I run your script will it remove only that information where the no_picture.gif is attached to those products?

That's the plan.

As always, make a backup first.

[Tswift42]

That's the plan.

As always, make a backup first.

Thanks for your help, I was able to remove all reference to no_picture.gif with your script ideas...

Thanks to everyone for the quick response

Tom