I'm not getting that error on my test site running 2.54. Can you try the module I emailed you on a clean dnn build to determine if its an upgrade issue on your site.

I get the following Warning on installation:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'SpecialInstructions'. 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_UpdateStoreOrders @OrderID int, @CustomerID int, @OrderDate datetime, @PayHistID int, @ShippingTotal money, @TaxTotal money, @HandlingCharge money, @ShipFirstName nvarchar(50), @ShipLastName nvarchar(50), @ShipAddress1 varchar(200), @ShipAddress2 varchar(200), @ShipCity varchar(60), @ShipState varchar(60), @ShipZipcode varchar(25), @ShipCountry varchar(50), @Status varchar(20), @ShipMethod nvarchar(50), @AffiliateId varchar(20) , @CouponId int , @Discount money , @MemberDiscount Money, @MemberRole nvarchar(50), @TrackingNumber nvarchar(50), @SpecialInstructions nvarchar(500) AS UPDATE Smith_StoreOrders SET [CustomerID] = @CustomerID, [OrderDate] = @OrderDate, [PayHistID] = @PayHistID, [ShippingTotal]=@ShippingTotal, [TaxTotal] = @TaxTotal , [HandlingCharge]=@HandlingCharge, ShipFirstName =@ShipFirstName, ShipLastName =@ShipLastName, [ShipAddress1]=@ShipAddress1, [ShipAddress2]=@ShipAddress2, [ShipCity]=@ShipCity, [ShipState]=@ShipState, [ShipZipcode]=@ShipZipcode, [ShipCountry] = @ShipCountry, [Status]=@Status, [ShipMethod]=@ShipMethod, [AffiliateId] = @AffiliateId , [CouponId] = @CouponId , [Discount] = @Discount , [MemberDiscount] = @MemberDiscount , [MemberRole] = @MemberRole, [TrackingNumber] = @TrackingNumber, [SpecialInstructions] = @SpecialInstructions WHERE [OrderID] = @OrderID

There are a couple options to fix this issue. For both of these options you should backup your database first:

1. This is probably the easiest option. Copy the tables to a test/backup database in sql server. See these 2 forum posts for more info.

http://www.smith-consulting.com/forums/forumid/1/threadid/357/scope/posts.aspx
http://www.smith-consulting.com/forums/forumid/1/threadid/300/scope/posts.aspx

Instructions to install a clean cart build
---------------------------------------------

1. From the dnn->host menu uninstall all 5 modules; Smith.BuyNow, Smith.AffliateTracking, Smit.CategoryMenu, Smith.MiniCart 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 cart module
5. Configure the cart settings
6. Add one category, manufacturer and product and test



2. Apply the stored procedures and dlls manually. Copy all the dlls from the zip file to your \bin folder. Run the stored procs from the sqlprovider files in the zip in a query window in sql server. Before you run the stored procs you will have to to a search and replace the {databaseOwner}[{objectQualifier} with your object qualifier you entered when you installed dnn

---

At your service,
Dave Smith

Next time you try to install an upgrade on the cart try resetting iis on your server and restarting sql server before you install the module. By resetting iis and sql server it will release the cache and lock on files this may be the issue.

---

At your service,
Dave Smith