My main reason for upgrading was to attempt to solve problems with the search feature in 3.01. The search bar doesn't know what to do with symbols... which is a big problem. I had successfully upgraded from 3.01 to 3.05, but when trying the search, it have me an error:

"Object reference not set to an instance of an object. "

So I went to your downloads page and saw that you had already released a new version. This is what happened:

Package Installation Report See below for the results of the package installation

Error loading files from temporary folder - see below StartJob Starting Installation Info Starting Installation - Smith.BuyNow Info Starting Installation - Script Info Begin Sql execution Info Created - 03.07.00.SqlDataProvider Info Executing 03.07.00.SqlDataProvider Info Start Sql execution: 03.07.00.SqlDataProvider file Info End Sql execution: 03.07.00.SqlDataProvider file Info Created - 03.08.00.SqlDataProvider Info Executing 03.08.00.SqlDataProvider Info Start Sql execution: 03.08.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: 'DNN5_JOIN' is not a recognized join option. Incorrect syntax near ')'. 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.DNN5_Smith_GetCatDiscountProductByPID @ProductID int AS WITH t(CategoryID, Parent) as ( SELECT c.CategoryID, c.ParentID FROM DNN5_Smith_Category c INNER JOIN DNN5_Smith_CategoryProduct cp ON c.CategoryID = cp.CategoryID LEFT OUTER DNN5_JOIN Smith_Products p ON cp.ProductID = p.ProductID WHERE (p.ProductID = @ProductID) UNION ALL SELECT c.CategoryID, c.ParentID FROM DNN5_Smith_Category c INNER JOIN DNN5_Smith_CategoryProduct cp ON c.CategoryID = cp.CategoryID JOIN t ON t.Parent=c.CategoryID) SELECT DISTINCT * FROM t ORDER BY Parent Info End Sql execution: 03.08.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - Smith.BuyNow Info Starting Installation - Smith.AffiliateTracking Info Starting Installation - Module Info Module registered successfully - Smith.AffiliateTracking Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly updated - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll Info Creating backup of previous version - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll Info Created - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll Info Assembly updated - bin\App_Web_trackaffiliateid.ascx.9167e184.dll Info Creating backup of previous version - bin\App_Web_trackaffiliateid.ascx.9167e184.dll Info Created - bin\App_Web_trackaffiliateid.ascx.9167e184.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Creating backup of previous version - AffiliateTrackingSettings.ascx Info Created - AffiliateTrackingSettings.ascx Info Creating backup of previous version - TrackAffiliateId.ascx Info Created - TrackAffiliateId.ascx Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.AffiliateTracking Info Starting Installation - Smith.CategoryMenu Info Starting Installation - Module Info Module registered successfully - Smith.CategoryMenu Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly updated - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll Info Creating backup of previous version - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll Info Created - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll Info Assembly updated - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll Info Creating backup of previous version - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll Info Created - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Creating backup of previous version - CategoryMenu.ascx Info Created - CategoryMenu.ascx Info Creating backup of previous version - CategoryMenu.css Info Created - CategoryMenu.css Info Creating backup of previous version - CatMenuSettings.ascx Info Created - CatMenuSettings.ascx Info Creating backup of previous version - tv_collapser.gif Info Created - tv_collapser.gif Info Creating backup of previous version - tv_expander.gif Info Created - tv_expander.gif Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.CategoryMenu Info Starting Installation - Smith.FeaturedProducts Info Starting Installation - Module Info Module registered successfully - Smith.FeaturedProducts Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly updated - bin\App_Web_featuredproducts.ascx.338729a9.dll Info Creating backup of previous version - bin\App_Web_featuredproducts.ascx.338729a9.dll Info Created - bin\App_Web_featuredproducts.ascx.338729a9.dll Info Assembly updated - bin\App_Web_featuredsettings.ascx.338729a9.dll Info Creating backup of previous version - bin\App_Web_featuredsettings.ascx.338729a9.dll Info Created - bin\App_Web_featuredsettings.ascx.338729a9.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Creating backup of previous version - FeaturedProducts.ascx Info Created - FeaturedProducts.ascx Info Creating backup of previous version - FeaturedProducts.css Info Created - FeaturedProducts.css Info Creating backup of previous version - FeaturedSettings.ascx Info Created - FeaturedSettings.ascx Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.FeaturedProducts Info Starting Installation - Smith.MiniCart Info Starting Installation - Module Info Module registered successfully - Smith.MiniCart Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly updated - bin\App_Web_minicart.ascx.d1cb3a5.dll Info Creating backup of previous version - bin\App_Web_minicart.ascx.d1cb3a5.dll Info Created - bin\App_Web_minicart.ascx.d1cb3a5.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Creating backup of previous version - checkout.gif Info Created - checkout.gif Info Creating backup of previous version - MiniCart.ascx Info Created - MiniCart.ascx Info Creating backup of previous version - minicart.css Info Created - minicart.css Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.MiniCart Info Starting Installation - Smith.MyAccount Info Starting Installation - Module Info Module registered successfully - Smith.MyAccount Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly updated - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll Info Creating backup of previous version - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll Info Created - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll Info Assembly updated - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll Info Creating backup of previous version - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll Info Created - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll Info Assembly updated - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll Info Creating backup of previous version - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll Info Created - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Creating backup of previous version - myaccount.css Info Created - myaccount.css Info Creating backup of previous version - MyAccountInvoice.ascx Info Created - MyAccountInvoice.ascx Info Creating backup of previous version - MyAccountManageOrders.ascx Info Created - MyAccountManageOrders.ascx Info Creating backup of previous version - MyAccountSettings.ascx Info Created - MyAccountSettings.ascx Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.MyAccount Info Starting Installation - Smith.QuickOrderEntry Info Starting Installation - Module Info Module registered successfully - Smith.QuickOrderEntry Info Component installed successfully - Module Info Starting Installation - Assembly Info Assembly registered - bin\App_Web_QuickOrderEntry.ascx.fa850494.dll Info Created - bin\App_Web_QuickOrderEntry.ascx.fa850494.dll Info Component installed successfully - Assembly Info Starting Installation - File Info Folder Created - \\fs1-n01\stor1wc1dfw1\388491\www.greenchoicehydro.com\web\content\DesktopModules\Smith.QuickOrderEntry\ Info Created - QuickOrderEntry.ascx Info Created - QuickOrderEntry.css Info Component installed successfully - File Failure Package Installation aborted Info Installation Failed - Smith.QuickOrderEntry Info Deleted temporary install folder EndJob Installation Failed

I am experiencing a similar problem with DNN 5.1. I had installed successfully on 4.9 with SQL 2000 database without any errors. I have upgraded the DNN site to 5.1 for skinning reasons. I have started a clean DNN install v5.1.4, SQL 2000 (v8.0.2039) and Smith Cart v3.88. When installing the cart to the fresh site I get the message below and cannot use any modules. Please help!

Thanks,

Melissa

Executing 03.08.00.SqlDataProvider
Info Start Sql execution: 03.08.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WITH'. 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_GetCatDiscountProductByPID @ProductID int AS WITH t(CategoryID, Parent) as ( SELECT c.CategoryID, c.ParentID FROM Smith_Category c INNER JOIN Smith_CategoryProduct cp ON c.CategoryID = cp.CategoryID LEFT OUTER JOIN Smith_Products p ON cp.ProductID = p.ProductID WHERE (p.ProductID = @ProductID) UNION ALL SELECT c.CategoryID, c.ParentID FROM Smith_Category c INNER JOIN Smith_CategoryProduct cp ON c.CategoryID = cp.CategoryID JOIN t ON t.Parent=c.CategoryID) SELECT DISTINCT * FROM t ORDER BY Parent
Info End Sql execution: 03.08.00.SqlDataProvider file
Info Finished Sql execution

Per our phone conversation this is fixed now. For the benefit of others reading this thread the issue was she was running sql 2000 and the cart requires sql 2005. There are only 2 stored procs that require 2005 and she commented them out and installed fine.

---

At your service,
Dave Smith