Upgrade problem... - Business Directory

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

10/1/2010 10:42 AM

Patrick Ryan

Joined: 8/29/2010

Posts: 73

Upgrade problem...

I tried to install version 3.00 directly over top of the previous one. Here is the report it gave me.. Can you please tell me what I need to do? Thank you.

StartJob	Starting Installation
Info	Starting Installation - SmithDirectorySignup
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Created - 01.30.00.SqlDataProvider
Info	Executing 01.30.00.SqlDataProvider
Info	Start Sql execution: 01.30.00.SqlDataProvider file
Warning	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'TabModuleId'. Invalid column name 'portalid'. Invalid 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_ListCategoryNew @TabModuleId int, @PortalId int AS SELECT * FROM Smith_Category WHERE TabModuleId = @TabModuleId and portalid = @PortalId ORDER BY [SortOrder] System.Data.SqlClient.SqlException: Invalid column name 'SortOrder'. Invalid column name 'TabModuleId'. Invalid column name 'PortalID'. 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_AddCategory @CategoryName varchar(50), @SortOrder INT, @TabModuleId INT, @PortalID int AS INSERT INTO Smith_Category ([CategoryName], [SortOrder], [TabModuleId], PortalID) VALUES (@CategoryName,@SortOrder,@TabModuleId,@PortalID) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: Invalid column name 'SortOrder'. Invalid column name 'TabModuleId'. 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_UpdateCategory @CategoryID int, @CategoryName varchar(50), @SortOrder INT , @TabModuleId INT AS UPDATE Smith_Category SET [CategoryName] = @CategoryName, [SortOrder] = @SortOrder, [TabModuleId] = @TabModuleId WHERE [CategoryID] = @CategoryID
Info	End Sql execution: 01.30.00.SqlDataProvider file
Info	Finished Sql execution
Info	Component installed successfully - Script
Info	Starting Installation - Module
Info	Module registered successfully - SmithDirectorySignup
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_SignUp.ascx.14f0edd7.dll
Info	Created - bin\App_Web_SignUp.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_SignupStatus.ascx.14f0edd7.dll
Info	Created - bin\App_Web_SignupStatus.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_Payment.ascx.14f0edd7.dll
Info	Created - bin\App_Web_Payment.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_PaymentStatus.ascx.14f0edd7.dll
Info	Created - bin\App_Web_PaymentStatus.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_Settings.ascx.14f0edd7.dll
Info	Created - bin\App_Web_Settings.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_Step2.ascx.14f0edd7.dll
Info	Created - bin\App_Web_Step2.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_Confirm.ascx.14f0edd7.dll
Info	Created - bin\App_Web_Confirm.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_ConfirmStatus.ascx.14f0edd7.dll
Info	Created - bin\App_Web_ConfirmStatus.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_ManageCategories.ascx.14f0edd7.dll
Info	Created - bin\App_Web_ManageCategories.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_DynamicControls.ascx.14f0edd7.dll
Info	Created - bin\App_Web_DynamicControls.ascx.14f0edd7.dll
Info	Assembly updated - bin\smith.dll
Info	Creating backup of previous version - bin\smith.dll
Info	Created - bin\smith.dll
Info	Assembly updated - bin\App_SubCode_DynamicControls.dll
Info	Creating backup of previous version - bin\App_SubCode_DynamicControls.dll
Info	Created - bin\App_SubCode_DynamicControls.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Creating backup of previous version - SignUp.ascx
Info	Created - SignUp.ascx
Info	Creating backup of previous version - SignupStatus.ascx
Info	Created - SignupStatus.ascx
Info	Creating backup of previous version - Payment.ascx
Info	Created - Payment.ascx
Info	Creating backup of previous version - PaymentStatus.ascx
Info	Created - PaymentStatus.ascx
Info	Creating backup of previous version - Settings.ascx
Info	Created - Settings.ascx
Info	Created - Step2.ascx
Info	Created - Confirm.ascx
Info	Created - ConfirmStatus.ascx
Info	Created - ManageCategories.ascx
Info	Creating backup of previous version - DynamicControls.ascx
Info	Created - DynamicControls.ascx
Info	Created - images\search-black.png
Info	Created - images\cvv-image.gif
Info	Created - images\signupnow.gif
Info	Created - PayPal_mark_37x23.gif
Info	Created - process-payment-orange.gif
Info	Created - back.png
Info	Created - next.png
Info	Created - continue.png
Info	Created - module.css
Info	Created - OrderTemplate.htm
Info	Component installed successfully - File
Info	Installation committed
Info	Installation successful. - SmithDirectorySignup
Info	Starting Installation - SmithDirectorySearch
Info	Starting Installation - Module
Info	Module registered successfully - SmithDirectorySearch
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_SearchDirectory.ascx.14f0edd7.dll
Info	Created - bin\App_Web_SearchDirectory.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_PremiumListing.ascx.14f0edd7.dll
Info	Created - bin\App_Web_PremiumListing.ascx.14f0edd7.dll
Info	Assembly registered - bin\App_Web_NewSettings.ascx.14f0edd7.dll
Info	Created - bin\App_Web_NewSettings.ascx.14f0edd7.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Creating backup of previous version - SearchDirectory.ascx
Info	Created - SearchDirectory.ascx
Info	Creating backup of previous version - PremiumListing.ascx
Info	Created - PremiumListing.ascx
Info	Creating backup of previous version - NewSettings.ascx
Info	Created - NewSettings.ascx
Info	Component installed successfully - File
Info	Installation committed
Info	Installation successful. - SmithDirectorySearch
Info	Starting Installation - SmithDirectoryGlossary
Info	Starting Installation - Module
Info	Module registered successfully - SmithDirectoryGlossary
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_SearchGlossary.ascx.14f0edd7.dll
Info	Created - bin\App_Web_SearchGlossary.ascx.14f0edd7.dll
Info	Assembly already registered - bin\App_Web_PremiumListing.ascx.14f0edd7.dll
Info	Assembly already registered - bin\App_Web_NewSettings.ascx.14f0edd7.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Creating backup of previous version - SearchGlossary.ascx
Info	Created - SearchGlossary.ascx
Info	Creating backup of previous version - PremiumListing.ascx
Info	Created - PremiumListing.ascx
Info	Creating backup of previous version - NewSettings.ascx
Info	Created - NewSettings.ascx
Info	Component installed successfully - File
Info	Installation committed
Info	Installation successful. - SmithDirectoryGlossary
Info	Starting Installation - SmithDirectoryMyListing
Info	Starting Installation - Module
Info	Module registered successfully - SmithDirectoryMyListing
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_EditProfile.ascx.14f0edd7.dll
Info	Created - bin\App_Web_EditProfile.ascx.14f0edd7.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Creating backup of previous version - EditProfile.ascx
Info	Created - EditProfile.ascx
Info	Component installed successfully - File
Info	Installation committed
Info	Installation successful. - SmithDirectoryMyListing
Info	Starting Installation - SmithDirectoryAdminConsole
Info	Starting Installation - Module
Info	Module registered successfully - SmithDirectoryAdminConsole
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_AdminConsole.ascx.14f0edd7.dll
Info	Created - bin\App_Web_AdminConsole.ascx.14f0edd7.dll
Info	Assembly already registered - bin\App_Web_EditProfile.ascx.14f0edd7.dll
Info	Assembly already registered - bin\App_Web_PremiumListing.ascx.14f0edd7.dll
Info	Assembly already registered - bin\App_Web_NewSettings.ascx.14f0edd7.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Creating backup of previous version - AdminConsole.ascx
Info	Created - AdminConsole.ascx
Info	Creating backup of previous version - EditProfile.ascx
Info	Created - EditProfile.ascx
Info	Creating backup of previous version - PremiumListing.ascx
Info	Created - PremiumListing.ascx
Info	Component installed successfully - File
Info	Installation committed
Info	Installation successful. - SmithDirectoryAdminConsole
Info	Deleted temporary install folder
EndJob	Installation successful.

10/1/2010 5:45 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Upgrade problem...

Please try doing a clean install of the latest module:

Clean Install Instructions
-------------------------------
Delete the old module and start with a clean install of the module. Please do the following:

From the dnn->host menu uninstall all modules with a prefix of Smith. Make sure you check the delete files box when you uninstall
Confirm that all stored procs and tables with a prefix of smith in your database are deleted
Confirm that all files in /desktopmodules/smith.buynow are deleted and the folder is removed
Reset iis to release the cache
Install the latest module
Configure the cart settings
Test

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

Page 1 of 1

You have no items in your shopping cart.

You have 1 item in your shopping cart.

{{multiCartItemsStr.replace('[COUNT]', minicart.cartList.length)}}

Item(s): {{minicart.countCart().Number | number : 2}}

Questions? Contact us for answers!

Services

DNN Modules

Support

Contact Us