Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreStore Installation Failures - HELP!Store Installation Failures - HELP!
Previous
 
Next
New Post
10/3/2006 5:34 AM
 

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()

 
New Post
10/3/2006 2:43 PM
 
Well, the error message is suggesting that Store did exist in your database (Store_Orders_UpdateOrderDetails is a Store stored procedure).

Although your Portal is a new installation, did the database already exist or was that new too?
 
New Post
10/3/2006 3:05 PM
 

Thank you for your reply.  I had Northern Star Solutions load it for me on GoDaddy.com, so I can't be sure but I assume it was new as well.  Any suggestions?

 
New Post
10/3/2006 5:06 PM
 

1) Using IIS manager, select your website properties. What is the Local Path under the Virtual Directory tab?

2) Have you set permissions for this folder to machinename/ASPNET (IIS5) or Network Services (IIS6)?


Dwayne J. Baldwin
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreStore Installation Failures - HELP!Store Installation Failures - HELP!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out