HomeHome Product Discus... Product Discus...SmithCartSmithCart3.01.00 Install Error3.01.00 Install Error
Previous
 
Next
New Post
8/5/2010 5:37 PM
 

We are getting the following installation error on a DNN v. 5.04.01 Portal.




Info Start Sql execution: 02.98.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Ambiguous column name 'SortOrder'. 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) CREATE PROCEDURE dbo.Smith_ListCatSubCat @TabModuleId int, @PortalId int AS SELECT c.CategoryID, c.CategoryName,c.SortOrder, c.Share, c.ParentID, c.catseourl, p.categoryname as 'parentcategoryname' FROM Smith_Category c left join Smith_Category p on c.parentid = p.categoryid WHERE ( C.TabModuleId = @TabModuleId OR C.Share = 1) and c.PortalId = @PortalId ORDER BY [SortOrder]

 
New Post
8/5/2010 7:30 PM
Accepted Answer 

Something must have gotten out of sync in your cart build and the install. I recommend you download and install the latest cart version and do the following:


Clean Install Instructions

  1. From the dnn->host menu uninstall all 6 modules; Smith.BuyNow, Smith.AffliateTracking, Smit.CategoryMenu, Smith.MiniCart, smith.featuredproducts and Smith.MyAccount. Make sure you check the delete files box when you uninstall
  2. Confirm that all stored procs and tables with a prefix of smith in your database are deleted
  3. Confirm that all files in /desktopmodules/smith.buynow are deleted and the folder is removed
  4. Install the latest module I sent you today
  5. Configure the cart settings
  6. Add one category, manufacturer and product and test

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
8/5/2010 9:06 PM
 

We did everything in the Clean Install Instructions in your above post. The install completed with no errors. Thanks for the solution

We are, however, still receiving an error upon clicking Submit Order when checking out... (I will start another thread for that issue so this can show as resolved)

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCart3.01.00 Install Error3.01.00 Install Error