nopCommerce Product Images

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 年 前
Just trying to understand the nop picture layout...

Media.Images.StoreInDB = true by default

I upload a single picture for product id 485. Display order is left at 1.
This picture is 400x267 when uploaded.
This upload creates a record in the nop_Picture table:
PictureID: 185  <Binary data>  image/jpeg  False
Followed by a record in the nop_ProductPicture table:
PorductPictureID: 119  ProductID: 485  PictureID: 185  DisplayOrder: 1

This upload adds the following image to the images\thumbs folder:
0000185.jpeg 400x267 - original image
For each page load that needs a different version of the original, the following images are created in images\thumbs:
0000185_80.jpeg 80x53 - thumbnail image used in cart
0000185_125.jpeg 125x83 - Used in category listing
0000185_300.jpeg 300x200 - Used when viewing product details

If I then change Media.Images.StoreInDB = false

No images show up for product id 485 in the frontend
The db still has the following records as expected:
nop_Picture: PictureID: 185  <Binary data>  image/jpeg  False
nop_ProductPicture: PorductPictureID: 119  ProductID: 485  PictureID: 185  DisplayOrder: 1

When viewing this product in the backend the image shows up as no image.
I delete the old image and records and re-upload the original image and it creates the nop_Picture and nop_ProductPicture records with new ids along with the different img sizes when viewed.
As additional images are added for a product, they will have a 000xxx_70.img created in the thumbs folder which is used on the details page as thumbnails.

Does not all of the above occur whether i have StoreInDB set as true or false?
The only difference being that when StoreInDB is true, the Original image is stored in the db?
I plan on using nop with StoreInDB set to false unless i am missing something else in how the picture layout works. Who prefers to use the DB to store there images?
thanks...jeff
13 年 前
Please take a look at this:

https://www.nopcommerce.com/boards/t/5558/the-same-bug-with-images-stored-in-db-in-v17.aspx

Hope it helps...
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.