Upgrade script for ProductTemplate

Hi,

Description
Nop 2.0, Sql Server 2008 Enterprise
I just ran the latest version of the upgrade script from 2.0 to 2.1 (I'm up to date with change set 7f2d1feebff7).

Experienced behavior
I got an error because it tries to add a NULL column to a table that contain entries (Product).

IF NOT EXISTS (SELECT 1 FROM syscolumns WHERE id=object_id('[dbo].[Product]') and NAME='ProductTemplateId')
BEGIN
  ALTER TABLE [dbo].[Product] 
  ADD [ProductTemplateId] int NOT NULL
END
GO

Expected behavior
I think it should add the column to allow NULL values, run the update to set the value to 1 and then modify the column to NOT NULL.

You're right. Thanks

Hello,

Upgrading with SQL script from 2.0 to 2.1

I've got the "An unknown error has occured. Please try again."

Someone can tel me what is the mistake?

Thank's