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

Notification

Icon
Error

toasty0621
#1 Posted : Monday, September 23, 2013 12:48:54 PM(UTC)
toasty0621

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?
Aaron
#2 Posted : Monday, September 23, 2013 4:29:39 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
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.
toasty0621
#3 Posted : Monday, September 23, 2013 5:05:06 PM(UTC)
toasty0621

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!
4e0p39s
#4 Posted : Friday, March 7, 2014 8:06:36 AM(UTC)
Rank: Guest


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.

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