|
Joined: 8/8/2006
Posts: 14
|
|
|
Hi! I (for some unknown reason) did not have the store module when I uploaded DNN 4.3.4 (no upgrade, clean install). So, I downloaded it, uploaded it to my site and received the following two error messages - can you please help me decipher what this means and what I need to do to get it uploaded properly?
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.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) 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 |
StartJob |
Registering DesktopModule |
Info |
Registering Definitions |
Info |
Registering Controls |
EndJob |
Registering finished |
|
Failure |
ExceptionSystem.UnauthorizedAccessException: Access to the path 'd:\hosting\sjortegon\web.config' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize) at System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle) at System.IO.File.SetLastWriteTimeUtc(String path, DateTime lastWriteTimeUtc) at System.IO.File.SetLastWriteTime(String path, DateTime lastWriteTime) at DotNetNuke.Common.Utilities.Config.Touch() at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstaller_V3.UpgradeModule(DesktopModuleInfo ModuleInfo) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.RegisterModules(PaFolder Folder, ArrayList Modules, ArrayList Controls) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install() |
|
|
|
|