I have created a testing website to perform an upgrade from SP2 to 5.7.3. I had my host copy the database, I copied the files from my live site to the test site, and everything was working fine so I proceeded with performing the upgrade to 5.7.3. When I pulled the site up in my browser I received the issue with the PasswordLastSet, but after changing my user dates in the database, that issue went away. Now when I pull up the site in my browser it begins to execute the database update script and I now receive the following. Any suggestions would be appreciated.
thanks
Rene'
<H1>Server Error in '/' Application.
<HR color=silver SIZE=1 width="100%">
</H1>
<H2>There is already an object named 'bvc_ProductXChoice' in the database. </H2>[color=#ffffcc>
[tr ][td ]<CODE>
Line]Line 8: If Utilities.VersionHelper.SqlPatchNeeded() Then
[color=red>Line 9: Utilities.VersionHelper.RunSqlPatch()
[/color]Line 10:
Line 11: 'Load all items</PRE>[/code][/td][/tr]</TABLE>
[color=#ffffcc>
[tr ][td ]<CODE>
[SqlException] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1949258
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4845243
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:533
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String script<b>File, String& ErrorMessage) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:21
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:38
SqlPatch.StartButton_Click(Object sender, EventArgs e) in c:\domains\examreviewstore.com\wwwroot\SqlPatch.aspx.vb:9
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
</PRE>[/code][/td][/tr]</TABLE>
<HR color=silver][1]<FONT face=Verdana>Version Information:[/color] Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614 [/1][/color]<!--
[SqlException]: There is already an object named 'bvc_ProductXChoice' 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 BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 545
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 533
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String& ErrorMessage) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 510
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 524
at BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:line 21
at BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:line 38
at SqlPatch.StartButton_Click(Object sender, EventArgs e) in c:\domains\examreviewstore.com\wwwroot\SqlPatch.aspx.vb:line 9
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
[HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.sqlpatch_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--><!--
This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->