According to the help and support page (http://help.ablecommerce.com/index.htm#t=upgrades%2FAC9_CMS%2FUpgrade_to_AbleCommerce_9.htm) our store version (7.0.7) could be upgraded directly to the latest version, but it fails. Am I missing something?

Upgrade AbleCommerce Database
The errors listed below occurred while upgrading the database:

SQL: -- ENFORCE UNIQUE ORDER NUMBERS IF (SELECT COUNT(*) AS NumRows FROM sysindexes WHERE id = (SELECT OBJECT_ID('ac_Orders')) AND Name = 'ac_Orders_IXOrderNumber') = 0 BEGIN CREATE UNIQUE INDEX ac_Orders_IXOrderNumber ON ac_Orders (OrderNumber) END
Error: Cannot find the object "ac_Orders" because it does not exist or you do not have permissions.
SQL: if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Orders' AND COLUMN_NAME = 'IsSubscriptionGenerated') = 0 BEGIN ALTER TABLE ac_Orders ADD IsSubscriptionGenerated BIT DEFAULT 0 NOT NULL END
Error: Cannot find the object "ac_Orders" because it does not exist or you do not have permissions.
SQL: IF (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_SubscriptionOrders') = 0 BEGIN CREATE TABLE [ac_SubscriptionOrders] ([SubscriptionOrderId] [int] IDENTITY(1,1) NOT NULL, [SubscriptionId] [int] NOT NULL, [OrderId] [int] NOT NULL, [IsPrimary] [BIT] DEFAULT 0 NOT NULL, [OrderDueDate] [DATETIME] NOT NULL, [PaymentAlertDate] [DATETIME] NULL, PRIMARY KEY(SubscriptionOrderId)) END -- check for foreignkey relationships if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_SubscriptionOrders' AND CONSTRAINT_NAME = 'FK_ac_SubscriptionOrders_ac_Subscriptions') = 0 BEGIN ALTER TABLE ac_SubscriptionOrders ADD CONSTRAINT FK_ac_SubscriptionOrders_ac_Subscriptions FOREIGN KEY (SubscriptionId) REFERENCES ac_Subscriptions (SubscriptionId) ON UPDATE NO ACTION ON DELETE CASCADE END if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_SubscriptionOrders' AND CONSTRAINT_NAME = 'FK_ac_SubscriptionOrders_ac_Orders') = 0 BEGIN ALTER TABLE ac_SubscriptionOrders ADD CONSTRAINT FK_ac_SubscriptionOrders_ac_Orders FOREIGN KEY (OrderId) REFERENCES ac_Orders (OrderId) ON UPDATE NO ACTION ON DELETE CASCADE END IF (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_GatewayPaymentProfiles') = 0 BEGIN CREATE TABLE [ac_GatewayPaymentProfiles] ([GatewayPaymentProfileId] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NOT NULL, [NameOnCard] [nvarchar](255) NULL, [GatewayIdentifier] [nvarchar](255) NULL, [CustomerProfileId] [nvarchar](255) NULL, [PaymentProfileId] [nvarchar](255) NULL, [ReferenceNumber] [nvarchar](255) NULL, [InstrumentTypeId] [SMALLINT] NOT NULL DEFAULT 0, [Expiry] [DATETIME] NULL, PRIMARY KEY(GatewayPaymentProfileId)) END -- check for foreignkey relationships if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_GatewayPaymentProfiles' AND CONSTRAINT_NAME = 'FK_ac_GatewayPaymentProfiles_ac_Users') = 0 BEGIN ALTER TABLE ac_GatewayPaymentProfiles ADD CONSTRAINT FK_ac_GatewayPaymentProfiles_ac_Users FOREIGN KEY (UserId) REFERENCES ac_Users (UserId) ON UPDATE NO ACTION ON DELETE CASCADE END if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_Subscriptions' AND CONSTRAINT_NAME = 'ac_PaymentMethods_ac_Subscriptions_FK1') = 0 BEGIN ALTER TABLE ac_Subscriptions ADD CONSTRAINT ac_PaymentMethods_ac_Subscriptions_FK1 FOREIGN KEY (PaymentMethodId) REFERENCES ac_PaymentMethods (PaymentMethodId) ON UPDATE NO ACTION ON DELETE SET NULL END if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_Subscriptions' AND CONSTRAINT_NAME = 'ac_GatewayPaymentProfiles_ac_Subscriptions_FK1') = 0 BEGIN ALTER TABLE ac_Subscriptions ADD CONSTRAINT ac_GatewayPaymentProfiles_ac_Subscriptions_FK1 FOREIGN KEY (GatewayPaymentProfileId) REFERENCES ac_GatewayPaymentProfiles (GatewayPaymentProfileId) ON UPDATE NO ACTION ON DELETE NO ACTION END if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_Subscriptions' AND CONSTRAINT_NAME = 'ac_TaxCodes_ac_Subscriptions_FK1') = 0 BEGIN ALTER TABLE ac_Subscriptions ADD CONSTRAINT ac_TaxCodes_ac_Subscriptions_FK1 FOREIGN KEY (BaseTaxCodeId) REFERENCES ac_TaxCodes (TaxCodeId) ON UPDATE NO ACTION ON DELETE SET NULL END if (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_Subscriptions' AND CONSTRAINT_NAME = 'ac_TaxCodes_ac_Subscriptions_FK2') = 0 BEGIN ALTER TABLE ac_Subscriptions ADD CONSTRAINT ac_TaxCodes_ac_Subscriptions_FK2 FOREIGN KEY (RecurringTaxCodeId) REFERENCES ac_TaxCodes (TaxCodeId) ON UPDATE NO ACTION ON DELETE NO ACTION END -- add new email templates if (SELECT COUNT(*) FROM ac_EmailTemplates WHERE Name = 'Subscription Payment Reminder' AND StoreId = 1) = 0 BEGIN DECLARE @templateId int INSERT INTO [ac_EmailTemplates] ([StoreId], [Name], [ToAddress], [FromAddress], [ReplyToAddress], [CCList], [BCCList], [Subject], [ContentFileName], [IsHTML]) VALUES ( 1, 'Subscription Payment Reminder', 'customer', 'merchant', NULL, NULL, NULL, 'Subscription Pending Payment Reminder', 'Subscription Payment Reminder.html', 1 ); SET @templateId = Scope_Identity() if (@templateId > 0) BEGIN if (SELECT COUNT(*) FROM ac_StoreSettings WHERE FieldName = 'ROPaymentReminderEmailTemplateId' AND StoreId = 1) > 0 BEGIN UPDATE [ac_StoreSettings] SET [FieldValue] = @templateId WHERE [FieldName] = 'ROPaymentReminderEmailTemplateId' END else BEGIN INSERT INTO [ac_StoreSettings] ([StoreId], [FieldName], [FieldValue]) VALUES ( 1, 'ROPaymentReminderEmailTemplateId', @templateId) END END END
Error: Foreign key 'FK_ac_SubscriptionOrders_ac_Orders' references invalid table 'ac_Orders'. Could not create constraint or index. See previous errors.
SQL: DECLARE @sql nvarchar(max); SET @sql = ''; SELECT @sql = @sql + 'IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N''[' + tab.[name] + ']'') AND name = N''IX_' + cols.[name] + ''') ' + 'CREATE NONCLUSTERED INDEX [IX_' + cols.[name] + '] ON [' + tab.[name] + ']( [' + cols.[name] + '] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY];' FROM sys.foreign_keys keys INNER JOIN sys.foreign_key_columns keyCols ON keys.object_id = keyCols.constraint_object_id INNER JOIN sys.columns cols ON keyCols.parent_object_id = cols.object_id AND keyCols.parent_column_id = cols.column_id INNER JOIN sys.tables tab ON keyCols.parent_object_id = tab.object_id WHERE tab.[name] LIKE 'ac_%' AND tab.[name] + '.' + cols.[name] NOT IN ('ac_PageViews.StoreId', 'ac_Orders.StoreId', 'ac_Orders.UserId', 'ac_OrderItems.OrderId', 'ac_OrderNotes.OrderId', 'ac_OrderShipments.OrderId', 'ac_Payments.OrderId', 'ac_Products.StoreId', 'ac_Products.ManufacturerId') ORDER BY tab.[name], cols.[name] exec sp_executesql @sql
Error: Cannot find the object "ac_CustomUrls" because it does not exist or you do not have permissions.

Edited by user Friday, November 11, 2022 10:31:29 AM(UTC)  | Reason: Not specified

Make sure the schema owner for your tables is dbo. I ran into that issue on a couple of sites where they were controlled by Plesk control panel.

I managed to change the schema. Upgrading is working fine, with minor things to fix.

Hi, Ray.

No, I'd like to do it on the hosting server, because I've been there with phrases like "works on my computer, don't know why isn't working in the production", better do it on the "real" thing. Right now, I'm dealing with the "dynamic compilation" issue, GoDaddy blocks it, probably it needs to be precompiled.

Hey, Ray, my hat off to you. Very well explained and right to the point and I can definitely "see" that's the way we should moving forward in the long run. Dedicated server is the way to go, no question about it, since we also run REST APIs on the server as well. May I ask you which company to go for dedicated servers in terms of price and support.

Warm regards.

I have the error bellow which is probably caused by the dynamic compilation being blocked by GoDaddy in a Windows shared account. Is there a way to go around or a dedicated server is indeed needed?

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1056: Unexpected character '$'

Source Error:


Line 76: @foreach (var image in Model.AdditionalImages)
Line 77: {
Line 78: imgAttributes["id"] = $"miImage{image.Id}";
Line 79: imgAttributes["alt"] = image.ImageAltText;
Line 80: imgAttributes["title"] = image.Moniker;

Source File: g:\PleskVhosts\xyz.com\httpdocs\testingstore\Views\Product\_ProductImage.cshtml Line: 78

Edited by user Monday, November 14, 2022 8:47:03 AM(UTC)  | Reason: Not specified