BV Commerce Forum
»
BV Commerce Support
»
Tools & Downloads
»
Need help! (3 weeks now!) 5.0.0 to 5.0.1 patch fails: "Could not drop constraint" errors i
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?
|
|
|
|
|
|
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.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "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 |
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "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 |
|
|
|
|
|
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.
|
|
|
|
|
|
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?
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
|
|
|
|
|
|
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!
|
|
|
|
|
|
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&m=59115My 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...
|
|
|
|
|
|
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?
|
|
|
|
|
|
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)?
|
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.