Upgrade to 5.4 - General Support

Welcome Guest! To enable all features please Login or Register.

Notification

Error

BV Commerce Forum » BV Commerce Support » General Support » Upgrade to 5.4

Upgrade to 5.4

Options

Previous Topic Next Topic

xotj123		#1 Posted : Friday, November 14, 2008 6:50:07 PM(UTC)
Rank: Member Joined: 10/19/2005(UTC) Posts: 53		Not sure that I understand the directions on how to upgrade my current BVC 5.3 store to 5.4, can anyone assist me with this? Thanks, TJ Havens


User Profile View All Posts by User View Thanks

IceCactus		#2 Posted : Friday, November 14, 2008 10:19:35 PM(UTC)
Rank: Member Joined: 2/6/2008(UTC) Posts: 55		I was slightly confused as well. But its actually pretty simple and was pretty painless. I had a slight issue with permissions. Just make sure the ASP.NET or Network Service (win2k3) account has read/write permissions on the BvAdmin/Versions folder. Extract, run the CreateNewStore util, and one of the buttons says Patch. Click it, fill in the values, then browse to your store and a page will come up asking you to upgrade the DB. :)


User Profile View All Posts by User View Thanks

xotj123		#3 Posted : Sunday, November 23, 2008 6:05:39 PM(UTC)
Rank: Member Joined: 10/19/2005(UTC) Posts: 53		I did what you said, and even made sure the READ/WRITE permissions are right. I am gett ing the following error: <H1>Server Error in '/' Application. <HR width="100%" color=silver SIZE=1> </H1> <H2>Access to the path 'C:\HostingSpaces\BIZPEN\new.BizPen.com\\bvadmin\versioning\sql\' is denied. </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> <B>[color=#ffffcc> [tr ][td ]<CODE> [UnauthorizedAccessException:] System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +651 System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity) +2759940 System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity) +150 BVSoftware.Bvc5.Core.Utilities.VersionHelper.WritePatchVersionFile(Versions version) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:57 BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:41 SqlPatch.StartButton_Click(Object sender, EventArgs e) in C:\HostingSpaces\BIZPEN\new.BizPen.com\SqlPatch.aspx.vb:9 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746 </PRE>[/code][/td][/tr]</TABLE> <HR width="100%" color=silver][1] <FONT face=Verdana>Version Information:[/color] Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 Thanks, TJ Havens[/1][/color]<!-- [UnauthorizedAccessException]: Access to the path 'C:\HostingSpaces\BIZPEN\new.BizPen.com\\bvadmin\versioning\sql\' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity) at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity) at BVSoftware.Bvc5.Core.Utilities.VersionHelper.WritePatchVersionFile(Versions version) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:line 57 at BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:line 41 at SqlPatch.StartButton_Click(Object sender, EventArgs e) in C:\HostingSpaces\BIZPEN\new.BizPen.com\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) -->


User Profile View All Posts by User View Thanks

Andy Miller		#4 Posted : Sunday, November 23, 2008 7:45:55 PM(UTC)
Rank: Member Joined: 11/5/2003(UTC) Posts: 2,136 Was thanked: 1 time(s) in 1 post(s)		Why do you claim that the permissions are right when Windows is telling you they are wrong? That makes no sense. Find out which windows identity is used to run your website (it is not your username). Make sure that identity has access to the path in the error message. If you get the error again, then you are making a mistake along the way....you do not have the permissions right.
		Andy Miller Structured Solutions Shipper 3 - High Velocity Shipment Processing


User Profile View All Posts by User View Thanks

IceCactus		#5 Posted : Monday, November 24, 2008 3:00:28 PM(UTC)
Rank: Member Joined: 2/6/2008(UTC) Posts: 55		Its the permissions... If website is on Windows 2003 you need to Grant "NETWORK SERVICE" write permission. (or use full control) if website is on XP you need to grant "ASP.NET" write permission (or use full control). Im assuming this is a public website that anyone can browse right? cuase if you have impersonate identity set on, for a private website on a network, then you would have to give permissions to that identity.


User Profile View All Posts by User View Thanks

xotj123		#6 Posted : Tuesday, November 25, 2008 10:18:29 AM(UTC)
Rank: Member Joined: 10/19/2005(UTC) Posts: 53		Hello, Fixed permissions. Now I get the following error: <H1>Server Error in '/' Application. <HR width="100%" color=silver SIZE=1> </H1> <H2>Column 'GiftWrapPrice' does not belong to table Table. </H2> [color=#ffffcc> [tr ][td ]<CODE> Line]Line 23: If i < 10 Then [color=red>Line 24: Dim p As Catalog.Product = Catalog.InternalProduct.FindByBvin(mydatarow.Item(0).ToString) [/color]Line 25: If p.ParentId = String.Empty Then Line 26: If p.IsVisible Then</PRE>[/code][/td][/tr]</TABLE> <B>[color=#ffffcc> [tr ][td ]<CODE> [ArgumentException:] System.Data.DataRow.GetDataColumn(String columnName) +1962843 System.Data.DataRow.IsNull(String columnName) +10 BVSoftware.Bvc5.Core.Catalog.Mapper.ConvertDataRow(DataRow dr) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:2262 BVSoftware.Bvc5.Core.Catalog.Mapper.FindByBvin(String bvin, Boolean ignoreCache) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:1986 BVSoftware.Bvc5.Core.Catalog.InternalProduct.FindByBvin(String bvin, Boolean ignoreCache, Boolean Clone) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:1794 BVSoftware.Bvc5.Core.Catalog.InternalProduct.FindByBvin(String bvin) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:1783 BVModules_ContentBlocks_Top_10_Products_view.LoadProducts() in C:\HostingSpaces\BIZPEN\new.BizPen.com\BVModules\ContentBlocks\Top 10 Products\view.ascx.vb:24 BVModules_ContentBlocks_Top_10_Products_view.Page_Load(Object sender, EventArgs e) in C:\HostingSpaces\BIZPEN\new.BizPen.com\BVModules\ContentBlocks\Top 10 Products\view.ascx.vb:9 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436 </PRE>[/code][/td][/tr]</TABLE> <HR width="100%" color=silver][1] <FONT face=Verdana>Version Information:[/color] Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 Thanks, TJ Havens[/1][/color]<!-- [ArgumentException]: Column 'GiftWrapPrice' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.IsNull(String columnName) at BVSoftware.Bvc5.Core.Catalog.InternalProduct.Mapper.ConvertDataRow(DataRow dr) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:line 2262 at BVSoftware.Bvc5.Core.Catalog.InternalProduct.Mapper.FindByBvin(String bvin, Boolean ignoreCache) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:line 1986 at BVSoftware.Bvc5.Core.Catalog.InternalProduct.FindByBvin(String bvin, Boolean ignoreCache, Boolean Clone) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:line 1794 at BVSoftware.Bvc5.Core.Catalog.InternalProduct.FindByBvin(String bvin) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Catalog\InternalProduct.vb:line 1783 at BVModules_ContentBlocks_Top_10_Products_view.LoadProducts() in C:\HostingSpaces\BIZPEN\new.BizPen.com\BVModules\ContentBlocks\Top 10 Products\view.ascx.vb:line 24 at BVModules_ContentBlocks_Top_10_Products_view.Page_Load(Object sender, EventArgs e) in C:\HostingSpaces\BIZPEN\new.BizPen.com\BVModules\ContentBlocks\Top 10 Products\view.ascx.vb:line 9 at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() 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.default_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->


User Profile View All Posts by User View Thanks

xotj123		#7 Posted : Tuesday, November 25, 2008 10:30:03 AM(UTC)
Rank: Member Joined: 10/19/2005(UTC) Posts: 53		Hello, One other thing, the screen where I enter the DB Connection String in order to update the DB never appeared after fixing the permissions issue. Thanks, TJ Havens


User Profile View All Posts by User View Thanks

IceCactus		#8 Posted : Tuesday, November 25, 2008 12:46:52 PM(UTC)
Rank: Member Joined: 2/6/2008(UTC) Posts: 55		I never got a screen that would allow me to enter a sql connection string. I just assumed that it was reading the string from the web.config. Try, rerunning the CreateNewStore utility and hit upgrade so it resets all the files. I believe i got this same error after properrly setting my permissions. Rerunning the CreateNewStore solved the issue.


User Profile View All Posts by User View Thanks

xotj123		#9 Posted : Tuesday, November 25, 2008 3:32:40 PM(UTC)
Rank: Member Joined: 10/19/2005(UTC) Posts: 53		Hello, It appears that worked perfectly. Very easy. Thanks - TJ


User Profile View All Posts by User View Thanks

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.