Dear all,
If you login as host and run the next SQL scripts with the checkbox on your problem will be solved without having to install the module again. Please take care that you still have to run the fix of the DNN team when they release it. The SP will not delete any data in case you might worry what they are ment for. Namely I do not know if this are the correct stored procedures. It works fine for me.
It seems that the next columns are missing. So run next script once:
STEP 1 - adding missing columns
Run this code only once. If you run twice it will give errors.
ALTER TABLE {databaseOwner}{objectQualifier}Store_Administration ADD [DefaultShippingFee] money NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Store_Administration ADD [DefaultTaxRates] ntext NULL
GO
STEP 2 - adding stored procedures that failed.
Clear the textbox and copy the next code into the SQL box. It will never return errors.
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Store_Administration_GetShippingFee]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}Store_Administration_GetShippingFee]
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Store_Administration_GetShippingFee
@PortalID int
AS
SET NOCOUNT ON
SELECT isnull(DefaultShippingFee, 0) Fee
FROM {databaseOwner}{objectQualifier}Store_Administration
WHERE PortalID = @PortalID
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Store_Administration_UpdateShippingFee]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}Store_Administration_UpdateShippingFee]
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Store_Administration_UpdateShippingFee
@PortalID int,
@Fee money
AS
SET NOCOUNT ON
UPDATE {databaseOwner}{objectQualifier}Store_Administration
SET DefaultShippingFee = @Fee
WHERE PortalID = @PortalID
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Store_Administration_GetTaxRates]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}Store_Administration_GetTaxRates]
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Store_Administration_GetTaxRates
@PortalID int
AS
SET NOCOUNT ON
SELECT isnull(DefaultTaxRates, ' ') DefaultTaxRates
FROM {databaseOwner}{objectQualifier}Store_Administration
WHERE PortalID = @PortalID
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}Store_Administration_UpdateTaxRates]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}Store_Administration_UpdateTaxRates]
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Store_Administration_UpdateTaxRates
@PortalID int,
@Rates ntext
AS
SET NOCOUNT ON
UPDATE {databaseOwner}{objectQualifier}Store_Administration
SET DefaultTaxRates = @Rates
WHERE PortalID = @PortalID
STEP 3 - wait till there is a final fix and rerun all SQL scripts.
Since I have seen more SQL install scripts with same version number I do not know for sure which one have the recent stored procedures in them. I took the sql script from the source (1.0.0.1). Make sure you will rerun the scripts
Hope this will help you out for the moment.
Jelle