The 5th annual nopCommerce conference will take place in India on the 10th-11th of October. Please find more about this event here

1.4 upgrade script

Posted: December 08, 2009 at 5:30 PM Quote #7750
So I'm trying to do a manual upgrade to 1.4 from 1.3 and have run into some issues with the upgrade script.

IF EXISTS (
    SELECT 1 FROM syscolumns WHERE id=object_id('[dbo].[Nop_ProductVariant]') and NAME='RequiresTextOption')
BEGIN
  ALTER TABLE [dbo].[Nop_ProductVariant]
  DROP COLUMN RequiresTextOption
END
GO

IF EXISTS (
    SELECT 1 FROM syscolumns WHERE id=object_id('[dbo].[Nop_ProductVariant]') and NAME='TextOptionPrompt')
BEGIN
  ALTER TABLE [dbo].[Nop_ProductVariant]
  DROP COLUMN TextOptionPrompt
END
GO

But further up the script these columns are referenced in the Nop_ProductVariantInsert and Nop_ProductVariantUpdate sprocs...

    INSERT
    INTO [Nop_ProductVariant]
    (
     ...
        RequiresTextOption,
     ...

  UPDATE [Nop_ProductVariant]
  SET
                ...
    [email protected],
                ...


WTH??
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: December 08, 2009 at 5:38 PM Quote #7751
This seems to be all kinds of sprocs in the upgrade script... how has anyone upgraded successfully??
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: December 08, 2009 at 5:45 PM Quote #7752
The SPs "Nop_ProductVariantInsert" and "Nop_ProductVariantUpdate" are redefined at the end of the (1.30 -> 1.40) script "nopCommerce_upgrade.sql" without references to the "RequiresTextOption" and "TextOptionPrompt" fields.

.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more