I installed smith cart version 2.99 when i started to develope my site with dotnetnuke version 5.2. I finished the site and the modules was working perfect apart from the shipping, when i tried to add 'shipping by order amount' all i got is TBD instead of the amount that should of been added.

I was told i need to upgrade to the latest version so i upgraded to v3.90 of smith cart, which was a pain but fair enougth it had to be done. This upgrade fixed the shipping issues and i was able to set what shipping rates i wanted, but instead i got 2 different issues, one of them disabled the buy now button on the product page, i came back and was told to upgrade my version of dotnetnuke, which i upgraded to version 5.60. This fixed the buy now button on the product page but reverted theshipping back to saying TBD, i've gone full circle, although i did need to upgrade anyway.

I was then told to clean install dotnetnuke, so i followed the clean install instructions of unistalling modules with the delete button checked, removing all tables from the database prefixed with smith, removing all remaining files from the desktop modules folder and reseting my IIS. I've tried reinstalled version 3.92 and also version 3.90 again after following the same instructions but i get the following error. I know it's saying that there is a table called Smith_AddVMatrixDetail but i have been throught the clean install process 5 times and i have made sure there is no table called that in the database.

I haven't got a clue what to do now, the smith cart has not worked for me since i have installed it and i have never changed any of the code, only the shopping carts styles, i'm at a loss, i tried contact support but haven't received an email back as of yet.

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	Folder created
Info	Created
Info	Executing 01.00.00.SqlDataProvider
Info	Start SQL execution: 01.00.00.SqlDataProvider file
Info	End SQL execution: 01.00.00.SqlDataProvider file
Info	Created
Info	Executing 01.00.01.SqlDataProvider
Info	Start SQL execution: 01.00.01.SqlDataProvider file
Info	End SQL execution: 01.00.01.SqlDataProvider file
Info	Created
Info	Executing 01.00.02.SqlDataProvider
Info	Start SQL execution: 01.00.02.SqlDataProvider file
Info	End SQL execution: 01.00.02.SqlDataProvider file
Info	Created
Info	Executing 01.00.03.SqlDataProvider
Info	Start SQL execution: 01.00.03.SqlDataProvider file
Info	End SQL execution: 01.00.03.SqlDataProvider file
Info	Created
Info	Executing 01.00.04.SqlDataProvider
Info	Start SQL execution: 01.00.04.SqlDataProvider file
Info	End SQL execution: 01.00.04.SqlDataProvider file
Info	Created
Info	Executing 02.78.00.SqlDataProvider
Info	Start SQL execution: 02.78.00.SqlDataProvider file
Info	End SQL execution: 02.78.00.SqlDataProvider file
Info	Created
Info	Executing 02.80.00.SqlDataProvider
Info	Start SQL execution: 02.80.00.SqlDataProvider file
Info	End SQL execution: 02.80.00.SqlDataProvider file
Info	Created
Info	Executing 02.82.00.SqlDataProvider
Info	Start SQL execution: 02.82.00.SqlDataProvider file
Info	End SQL execution: 02.82.00.SqlDataProvider file
Info	Created
Info	Executing 02.85.00.SqlDataProvider
Info	Start SQL execution: 02.85.00.SqlDataProvider file
Info	End SQL execution: 02.85.00.SqlDataProvider file
Info	Created
Info	Executing 02.86.00.SqlDataProvider
Info	Start SQL execution: 02.86.00.SqlDataProvider file
Info	End SQL execution: 02.86.00.SqlDataProvider file
Info	Created
Info	Executing 02.87.00.SqlDataProvider
Info	Start SQL execution: 02.87.00.SqlDataProvider file
Info	End SQL execution: 02.87.00.SqlDataProvider file
Info	Created
Info	Executing 02.88.00.SqlDataProvider
Info	Start SQL execution: 02.88.00.SqlDataProvider file
Info	End SQL execution: 02.88.00.SqlDataProvider file
Info	Created
Info	Executing 02.91.00.SqlDataProvider
Info	Start SQL execution: 02.91.00.SqlDataProvider file
Info	End SQL execution: 02.91.00.SqlDataProvider file
Info	Created
Info	Executing 02.93.00.SqlDataProvider
Info	Start SQL execution: 02.93.00.SqlDataProvider file
Info	End SQL execution: 02.93.00.SqlDataProvider file
Info	Created
Info	Executing 02.94.00.SqlDataProvider
Info	Start SQL execution: 02.94.00.SqlDataProvider file
Info	End SQL execution: 02.94.00.SqlDataProvider file
Info	Created
Info	Executing 02.95.00.SqlDataProvider
Info	Start SQL execution: 02.95.00.SqlDataProvider file
Info	End SQL execution: 02.95.00.SqlDataProvider file
Info	Created
Info	Executing 02.96.00.SqlDataProvider
Info	Start SQL execution: 02.96.00.SqlDataProvider file
Info	End SQL execution: 02.96.00.SqlDataProvider file
Info	Created
Info	Executing 02.97.00.SqlDataProvider
Info	Start SQL execution: 02.97.00.SqlDataProvider file
Info	End SQL execution: 02.97.00.SqlDataProvider file
Info	Created
Info	Executing 02.98.00.SqlDataProvider
Info	Start SQL execution: 02.98.00.SqlDataProvider file
Info	End SQL execution: 02.98.00.SqlDataProvider file
Info	Created
Info	Executing 02.99.00.SqlDataProvider
Info	Start SQL execution: 02.99.00.SqlDataProvider file
Info	End SQL execution: 02.99.00.SqlDataProvider file
Info	Created
Info	Executing 03.00.00.SqlDataProvider
Info	Start SQL execution: 03.00.00.SqlDataProvider file
Info	End SQL execution: 03.00.00.SqlDataProvider file
Info	Created
Info	Executing 03.01.00.SqlDataProvider
Info	Start SQL execution: 03.01.00.SqlDataProvider file
Info	End SQL execution: 03.01.00.SqlDataProvider file
Info	Created
Info	Executing 03.02.00.SqlDataProvider
Info	Start SQL execution: 03.02.00.SqlDataProvider file
Failure	SQL execution resulted in following exceptions: System.Data.SqlClient.SqlException: There is already an object named 'Smith_AddVMatrixDetail' 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) CREATE PROCEDURE dbo.Smith_AddVMatrixDetail @ProductID int, @YAxisTitle varchar(50), @MatrixItemID1 int, @MatrixItemID2 int, @MatrixItemID3 int, @MatrixItemID4 int, @MatrixItemID5 int, @MatrixItemID6 int, @MatrixItemID7 int, @MatrixItemID8 int, @MatrixItemID9 int, @MatrixItemID10 int AS INSERT INTO Smith_VariantMatrixDetail (ProductID, YAxisTitle, MatrixItemID1,MatrixItemID2,MatrixItemID3,MatrixItemID4,MatrixItemID5,MatrixItemID6,MatrixItemID7, MatrixItemID8,MatrixItemID9, MatrixItemID10) VALUES (@ProductID,@YAxisTitle, @MatrixItemID1,@MatrixItemID2,@MatrixItemID3,@MatrixItemID4,@MatrixItemID5,@MatrixItemID6,@MatrixItemID7, @MatrixItemID8,@MatrixItemID9,@MatrixItemID10) SELECT SCOPE_IDENTITY()
Info	End SQL execution: 03.02.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 registered - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info	Created
Info	Assembly registered - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
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 registered - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info	Created
Info	Assembly registered - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
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 registered - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info	Created
Info	Assembly registered - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
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 registered - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info	Created
Info	Assembly registered - bin\App_Web_minicartSettings.ascx.d1cb3a5.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
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 registered - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info	Created
Info	Assembly registered - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info	Created
Info	Assembly registered - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
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
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
Info	Installation Failed - Smith.QuickOrderEntry
Info	Starting Installation - Smith.ProductDetail
Info	Starting Installation - Module
Info	Module registered successfully - Smith.ProductDetail
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\App_Web_ProductDetails.ascx.2f4527b6.dll
Info	Created
Info	Assembly registered - bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dll
Info	Created
Info	Assembly registered - bin\App_Web_WriteReviews.ascx.2f4527b6.dll
Info	Created
Info	Component installed successfully - Assembly
Failure	Install aborted - new version older than installed version
Info	Installation Failed - Smith.ProductDetail
Info	Deleted temporary install folder
EndJob	Installation Failed

Smith_AddVMatrixDetail is not a table it is a stored procedure.

In Sql Server Management Studio (SSMS) select Database|Programmability|Stored Procedures

From DotNetNuke select Host|SQL you can paste this script and click execute

--list smith cart stored procs
select name from dbo.sysobjects where xtype='P' and name like'%smith%'

Or paste this to check tables

--list smith cart tables
select name from dbo.sysobjects where xtype='U' and name like'%smith%'

I hope this is of some help to you.