Rank: Member
Joined: 5/18/2005(UTC)
Posts: 36
Thanks: 3 times
|
Wondering if anyone had issues while updating from 5.6 to 2013 throws error "Subqueries are not allowed in this context. Only scalar expressions are allowed"
Line 543: cmd.Connection = c
Line 544: cmd.CommandText = statement
Line 545: Dim sqlResult As Integer = cmd.ExecuteNonQuery()
Line 546: Return True
Line 547: End Function
in SqlDataHelper.vb
(line 510, using VS 2012 if that helps)
Store builds fine with fresh database just errors out on upgrade.
Thoughts?
|
|
|
|
|
|
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)
|
I think we already solved this through the support ticket that you submitted, but for anyone else experiencing this problem, it occurs when upgrading to BV Commerce 2013 with SQL Server 2005. We have a new update script that works on SQL Server 2005, so if you need this please submit a support ticket. Thanks! |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
 1 user thanked Aaron for this useful post.
|
|
|
|
Rank: Member
Joined: 5/18/2005(UTC)
Posts: 36
Thanks: 3 times
|
Yes thank you for the fast response Aaron. Have a great rest of your week!
|
|
|
|
|
|
|
|
Message was deleted by a Moderator. | Reason: Not specified
|
|
|
|
|
|
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.