Did little digging - if you do not have time to wait for AC to fix this, open \Admin\Orders\PaymentManager.aspx
Look for: DefaultSortExpression="OrderId"
and change it to: DefaultSortExpression="ac_orders.OrderId"
Worked for me...
Search found 2 matches
- Thu Sep 08, 2011 9:46 am
- Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
- Topic: BUG - Ambiguous column name 'OrderId'.
- Replies: 3
- Views: 20000
- Thu Sep 08, 2011 9:17 am
- Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
- Topic: BUG - Ambiguous column name 'OrderId'.
- Replies: 3
- Views: 20000
Re: BUG - Ambiguous column name 'OrderId'.
I am getting same error. My AC build is VERSION: 7.0.7.14600 This is the query that bombs out: exec sp_executesql N'SELECT TOP 20 ac_Payments.PaymentId,ac_Payments.OrderId,ac_Payments.SubscriptionId,ac_Payments.PaymentMethodId,ac_Payments.PaymentMethodName,ac_Payments.ReferenceNumber,ac_Payments.Amo...