Hi this problem seems your upgradation is not successfully.
Actually in nopCommerce 4.10, they created separate table for picture binary and remove binaries from Picture table.
So just follow below steps and it will work.
1. Check PictureBinary table is available or not in your upgraded database.2. if binary table is available then folow below steps. otherwise ignor this step as now and follow to step 3.
2.1 Execute below script
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FK_PictureBinary_Picture_PictureId') AND parent_object_id = OBJECT_ID(N'PictureBinary'))
ALTER TABLE [PictureBinary] DROP CONSTRAINT [FK_PictureBinary_Picture_PictureId]
GO
2.2 check total number of record in PictureBinary table.
select count(*) from PictureBinary
2.3 If there few records or not available any record in table, then execute below script
If you have few records in Picture table then do this.
--copy existing data
INSERT INTO [dbo].[PictureBinary](PictureId, BinaryData)
SELECT [Id], [PictureBinary] FROM [dbo].[Picture]
If you have lots of records in Picture table then execute this SQL script
This will prevent duplicate record in table.
INSERT INTO [dbo].[PictureBinary](PictureId, BinaryData)
SELECT top 1 [Id], [PictureBinary] FROM [dbo].[Picture] where Id NOT IN (select PictureId from [PictureBinary])
2.4 Once done this chck total number of records in PictureBinary table. (its same as Picture table's total record)
3. If table PictureBinary is not available then follow below steps.
3.1 Create table via below script
CREATE TABLE [dbo].[PictureBinary]
(
[Id] int IDENTITY(1,1) NOT NULL,
[PictureId] int NOT NULL,
[BinaryData] [varbinary](max) NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
3.2 Now follow step 2
4. Once done above steps it means your binaries are copied to PictureBinary table.
Now drop column from Picture TABLE
ALTER TABLE dbo.Picture DROP COLUMN [PictureBinary]')
5. Now execute below SQL script
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FK_PictureBinary_Picture_PictureId') AND parent_object_id = OBJECT_ID(N'PictureBinary'))
ALTER TABLE [PictureBinary] DROP CONSTRAINT [FK_PictureBinary_Picture_PictureId]
GO
ALTER TABLE [dbo].[PictureBinary] WITH CHECK ADD CONSTRAINT [FK_PictureBinary_Picture_PictureId] FOREIGN KEY(PictureId)
REFERENCES [dbo].[Picture] ([Id])
ON DELETE CASCADE
GO
6. It's done
you can get this scripts from upgrade script.