• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

cdakz
#1 Posted : Friday, March 6, 2009 7:17:44 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

I have an original BVC5 store (version 5.0.0.947) that I need to upgrade to the latest SP.


So, I ran the 5.4 CreateStore.exe utility, and selected the "Upgrade 5.x Store" option, which seemed to succeed.



Then, when I browse the Default.aspx page, and attempt to update the database, I receive the following error:


[color=red><I>Column] [/color]


Is this because the Upgrade option can't upgrade from ver 5.0 (I looked through the documentation and didn't see any minimum version requirement)? Or is something else likely wrong?
cdakz
#2 Posted : Monday, March 9, 2009 10:48:55 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

Oh, if the problem is that I need to first upgrade ver 5.0x to other milestones (e.g. 5.3.2?), where I can download those upgrades? I logged into my account and went to the Downloads section, and don't see anything that old that's downloadable.
Aaron
#3 Posted : Tuesday, March 10, 2009 10:28:57 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
You may need to run the service pack SQL scripts in the \BVAdmin\BVSql folder first. Run them sequentially (SP2, SP3, SP3.1, etc -- don't run the Full scripts since this is not a new installation).
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Aaron
#4 Posted : Tuesday, March 10, 2009 10:30:11 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
It probably goes without saying, but I'll say it anyway, make sure you make a backup copy of your database before you run these scripts just in case something gets hosed up.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Marcus
#5 Posted : Tuesday, March 10, 2009 10:37:29 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Here are the patches to go from

5.0 to 5.0.1

Then 5.0.1 to SP1

The SP1 to SP2
File Attachment(s):
BVC501ToSp1.zip (939kb) downloaded 210 time(s).

You cannot view/download attachments. Try to login or register.
cdakz
#6 Posted : Tuesday, March 10, 2009 5:06:33 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

Thanks Marcus and Aaron!



So, once I've upgraded the site to SP2, then I'll be able to run the SP5.4 Upgrade function?
Marcus
#7 Posted : Tuesday, March 10, 2009 7:57:14 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Yes.
cdakz
#8 Posted : Friday, March 20, 2009 12:39:28 AM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

Hmmm... is there a patch that should be run prior to 5.0.1?



When I run the 566-621 Schema Update.SQL query from the BVC_501_Patch.zip patch, I get a series of errors. Here's a snippet:


<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_Product]<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Msg 3728, Level 16, State 1, Line 1<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">'FK_bvc_Product_bvc_Product' is not a constraint.<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Msg 3727, Level 16, State 0, Line 1<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Could not drop constraint. See previous errors.<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes"><o:p> </o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">(1 row(s) affected)<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_ProductChoiceCombinations]<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_ProductInventory]<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_ProductPropertyValue]<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_ProductXCategory]<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 8pt; mso-no-proof: yes">Dropping foreign keys from [dbo].[bvc_Sale]<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Msg 3728, Level 16, State 1, Line 1<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">'FK_bvc_Sale_bvc_Sale' is not a constraint.<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Msg 3727, Level 16, State 0, Line 1<o:p></o:p>

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">Could not drop constraint. See previous errors.

<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #ff6600; FONT-SIZE: 8pt; mso-no-proof: yes">

Help!

cdakz
#9 Posted : Monday, March 23, 2009 5:55:48 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

More conflicting info. I just noticed that this post says we don't have to do any interim upgrades, but rather that the SP5.4 upgrade will work on any prior 5.x version: http://forums.bvcommerce...spx?f=88&amp;m=59115

My client's getting a little antsy about this. In light of my post above (where the 5.0.1 patch isn't working), is there a cumulative upgrade method (from 5.0.0 to the latest RTM code)? And if not, what do I need to do for the 5.0.1 upgrade that's failing due to missing constraints in 5.0.0?

Thanks in advance...
cdakz
#10 Posted : Friday, March 27, 2009 12:27:02 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

Does anybody have any suggestions at all? When I just checked, this post had 166 views, so I can't be the the only one who's interested.



We have not made any changes to the database, so I'm wondering if there's an interim patch prio to 5.0.1 that needs to be applied.



Or perhaps the problem is that the site was originally created via an conversion/upgrade/import of a another ecommerce product 5 site. Perhaps the conversion/import tools didn't set up all the constraints that a fresh BVC 5.0.0 install would've created?
cdakz
#11 Posted : Monday, March 30, 2009 1:47:15 PM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

This has become fairly urgent, and so I've looked at where to submit a support ticket for it (like we've done in the past), but the support ticket system seems to be shut down.


How do we submit a support ticket these days (even if we have to pay for it)?
[email protected]
#12 Posted : Monday, March 30, 2009 5:43:54 PM(UTC)
gdelorey@mitcs.com

Rank: Member

Joined: 10/11/2006(UTC)
Posts: 162

Thanks: 1 times
Just go to the contact section on BV's site and I think they have a dropdown where you can select 'support' or something similar.

: Greg
cdakz
#13 Posted : Tuesday, March 31, 2009 9:29:29 AM(UTC)
cdakz

Rank: Member

Joined: 5/2/2005(UTC)
Posts: 259

Yeah, I did that on Friday, but haven't received a reply yet.


That's why I was wondering if there was a different location where we specifically ask for paid support.
hugogmg
#14 Posted : Monday, July 13, 2009 3:03:54 PM(UTC)
hugogmg

Rank: Member

Joined: 7/10/2009(UTC)
Posts: 2

Has anyone resolved this issue? I have the same problem. Please help! Thanks in advance. :smile:
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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012