Hi Nop-Templates Support,

We encountered a database schema issue with SevenSpikes Product Ribbons after upgrading our nopCommerce installation from 4.50 to 5.00.

Environment:
- nopCommerce: 5.00
- Previous version: 4.50
- Database: Azure SQL Database
- Hosting: Azure App Service (Windows)
- .NET: 10
- Plugin: SevenSpikes.Nop.Plugins.ProductRibbons

The error occurs when opening/loading the Product Ribbons administration page.

Error:

Microsoft.Data.SqlClient.SqlException (0x80131904):
Invalid column name 'ImageAltText'.

Error Number: 207
State: 1
Class: 16

The relevant stack trace points to:

SevenSpikes.Nop.Plugins.ProductRibbons.Services.ProductRibbonService
    .GetCategoryPageRibbonByProductRibbonIdAsync(Int32 productRibbonId)

SevenSpikes.Nop.Plugins.ProductRibbons.Areas.Admin.Factories.ProductRibbonModelFactory
    .PrepareListModelAsync()

SevenSpikes.Nop.Plugins.ProductRibbons.Areas.Admin.Controllers.ProductRibbonsAdminController
    .ListCommand(...)

LinqToDB eventually sends a query that references the ImageAltText column, but the corresponding Product Ribbons database table in our upgraded database does not contain this column.

This appears to indicate that the nopCommerce 5.00 version of Product Ribbons expects a newer database schema, while the required Product Ribbons database migration may not have been applied during the 4.50 -> 5.00 upgrade.

Could you please confirm:

1. Which Product Ribbons table should contain the ImageAltText column in the nopCommerce 5.00 version?
2. What are the expected SQL data type, length, nullability and default value for ImageAltText?
3. Is there a SevenSpikes migration that should add this column when upgrading from nopCommerce 4.50 to 5.00?
4. Are there any other Product Ribbons schema changes required for the 4.50 -> 5.00 upgrade?
5. Is there an official migration/reinstallation procedure we should run to bring the existing Product Ribbons database schema up to the 5.00 version without losing the existing ribbons/configuration?

We have not manually added the ImageAltText column yet because we would prefer to apply the official SevenSpikes migration and make sure that no other schema changes are missing.

The application itself is running on nopCommerce 5.00. The exception is specifically generated when ProductRibbonService.GetCategoryPageRibbonByProductRibbonIdAsync() attempts to load Product Ribbons data.

Please let us know the recommended upgrade/migration procedure.

Thank you.