I am on Nop 3.8, and I have it set to store pictures in the file system.
When I look at the Picture Table, I see that there is a PictureBinary column name and the value for each picture is <Binary Data>.
However, I am storing my pictures in on the file server.
What is stored in the PictureBinary column?
I created a Picture Upload page using classic ASP and I can successfully upload the picture, insert a row in the Picture table, set the MimeType according to the File extension, and set IsNew to 'False'. And PictureBinary is automatically set to NULL.
The picture doesn't display on the website, and I suspect it's because Picture Binary is NULL.
Basically, my question is what should I insert for the PictureBinary column from the web form?
Thanks in advance to anyone who replies!
-Fred
Picture Table, PictureBinary, and <Binary Data>
- 157
- 1488
- 2/12/2013
- India
fsr76 wrote:
Hi Fred,
nopCommerce is storing image in either file system OR database (as binary format).
PictureBinary is used to store binary image when database is selected in media storage option.
We can set media setting to file system/database from admin panel (see link below)
http://admin-demo.nopcommerce.com/Admin/Setting/Media
Here you mentioned that you are uploading images using classic ASP pages.
Just do one thing, upload image for some product using nopCommerce admin panel and notice the values in
Picture and Product_Picture_Mapping mapping tables. You can get exact idea how nopCommerce is storing images and correct anything is you missed in classic ASP uploading code.
Hope this helps!
I am on Nop 3.8, and I have it set to store pictures in the file system.
When I look at the Picture Table, I see that there is a PictureBinary column name and the value for each picture is <Binary Data>.
However, I am storing my pictures in on the file server.
What is stored in the PictureBinary column?
I created a Picture Upload page using classic ASP and I can successfully upload the picture, insert a row in the Picture table, set the MimeType according to the File extension, and set IsNew to 'False'. And PictureBinary is automatically set to NULL.
The picture doesn't display on the website, and I suspect it's because Picture Binary is NULL.
Basically, my question is what should I insert for the PictureBinary column from the web form?
Thanks in advance to anyone who replies!
-Fred
When I look at the Picture Table, I see that there is a PictureBinary column name and the value for each picture is <Binary Data>.
However, I am storing my pictures in on the file server.
What is stored in the PictureBinary column?
I created a Picture Upload page using classic ASP and I can successfully upload the picture, insert a row in the Picture table, set the MimeType according to the File extension, and set IsNew to 'False'. And PictureBinary is automatically set to NULL.
The picture doesn't display on the website, and I suspect it's because Picture Binary is NULL.
Basically, my question is what should I insert for the PictureBinary column from the web form?
Thanks in advance to anyone who replies!
-Fred
Hi Fred,
nopCommerce is storing image in either file system OR database (as binary format).
PictureBinary is used to store binary image when database is selected in media storage option.
We can set media setting to file system/database from admin panel (see link below)
http://admin-demo.nopcommerce.com/Admin/Setting/Media
Here you mentioned that you are uploading images using classic ASP pages.
Just do one thing, upload image for some product using nopCommerce admin panel and notice the values in
Picture and Product_Picture_Mapping mapping tables. You can get exact idea how nopCommerce is storing images and correct anything is you missed in classic ASP uploading code.
Hope this helps!