HomeHome Product Discus... Product Discus...SmithCartSmithCartInvalid column name Invalid column name 'portalid' at upgrade
Previous
 
Next
New Post
7/24/2012 11:25 AM
 
Tony Taylor
No Ranking


Joined: 4/20/2011
Posts: 8
Hello,

We are running DNN 06.02.01, SQL 2008R2, Smith Cart 4.92. When I run the upgrade to any of the following (4.93, 4.99, 5) I get the same error on install:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'portalid'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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_GetCompanyLogo @myUserID varchar(50), @PortalID int AS SELECT fileupload from Smith_RegCustomer where companyname in (select companyname from Smith_RegCustomer where dnnlogin = @myUserID) and fileupload is not null and portalid = @PortalID

Have gone through settings and templates to resave before upgrade but same error everytime. Thanks for any help.
 
New Post
7/25/2012 2:55 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Tony,

Sounds like your initial upgrade may have been incomplete, one possibility which may have caused the incomplete upgrade is a timeout.

Before reinstalling the Cart, try increasing the maxRequestLength, requestLengthDiskThreshold and executionTimeout values of the httpRuntime node in your application Web.config file.

I recommend using the instructions found in the following Article to perform a clean installation of the Cart. If you have a live site and need retain your customer, order and product data before doing a clean installation please see the pdf attached to the Article which explains how to export and import so you can retain your data when doing a clean installation: https://www.smith-consulting.com/Foru...

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartInvalid column name Invalid column name 'portalid' at upgrade




Questions? Contact us for answers!

Contact Us!