Hi, I installed the store module twice.
First attemp:
- I deleted the container-modules on the pages.
- In Host->module definitions, I deleted the modules from the list
- In the filemanager I synchronized the database system.
- In Host->module definition I uploaded the new store zip file.
- The following was mentioned in red
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Store_Orders_UpdateOrderDetails' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- New procedure CREATE PROCEDURE dbo.Store_Orders_UpdateOrderDetails @OrderID int, @CartID nvarchar(50) AS SET NOCOUNT ON -- Remove the current order details from the order DELETE FROM dbo.Store_OrderDetails WHERE OrderId = @OrderID -- Insert the new order details from the specified cart INSERT INTO dbo.Store_OrderDetails (OrderID, ProductID, Quantity, UnitCost) SELECT @OrderID, ci.ProductID, Quantity, UnitCost FROM dbo.Store_CartItems ci, dbo.Store_Products pr WHERE ci.ProductID = pr.ProductID AND CartID = @CartID -- Return the updated Order SELECT o.OrderID, o.UserID as CustomerID, Cast(sum(od.Quantity*od.UnitCost) as money) as OrderTotal, o.OrderNumber, o.OrderDate, o.ShipDate, o.ShippingAddressID, o.BillingAddressID FROM dbo.Store_Orders o, dbo.Store_OrderDetails od WHERE o.OrderID = od.OrderID AND o.OrderID = @OrderID GROUP BY UserID, o.OrderID, o.OrderNumber, o.OrderDate, o.ShipDate, o.ShippingAddressID, o.BillingAddressID HAVING o.OrderID = @OrderID
The store admin showed an error sign after installing.
Second attemp
- Performing the steps mentioned in the first attemp
- Deleted the complete store directory on the server.
- Synchronized the database system
- Uploading again the store sip file
- The following was mentioned in red
StartJob Start Sql execution: 01.00.01.sqldataprovider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Store_Orders_UpdateOrderDetails' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- New procedure CREATE PROCEDURE dbo.Store_Orders_UpdateOrderDetails @OrderID int, @CartID nvarchar(50) AS SET NOCOUNT ON -- Remove the current order details from the order DELETE FROM dbo.Store_OrderDetails WHERE OrderId = @OrderID -- Insert the new order details from the specified cart INSERT INTO dbo.Store_OrderDetails (OrderID, ProductID, Quantity, UnitCost) SELECT @OrderID, ci.ProductID, Quantity, UnitCost FROM dbo.Store_CartItems ci, dbo.Store_Products pr WHERE ci.ProductID = pr.ProductID AND CartID = @CartID -- Return the updated Order SELECT o.OrderID, o.UserID as CustomerID, Cast(sum(od.Quantity*od.UnitCost) as money) as OrderTotal, o.OrderNumber, o.OrderDate, o.ShipDate, o.ShippingAddressID, o.BillingAddressID FROM dbo.Store_Orders o, dbo.Store_OrderDetails od WHERE o.OrderID = od.OrderID AND o.OrderID = @OrderID GROUP BY UserID, o.OrderID, o.OrderNumber, o.OrderDate, o.ShipDate, o.ShippingAddressID, o.BillingAddressID HAVING o.OrderID = @OrderID
EndJob End Sql execution: 01.00.01.sqldataprovider file
Now the module works fine !!!
There is only an issue with the use of euro's
Is this due this problem or is this because it is not possible to pay in euro's
If so is ther an solution for this problem?