HomeHome Product Discus... Product Discus...SmithCartSmithCartDNN Error in 4.25 when accessing the Manage Orders area.DNN Error in 4.25 when accessing the Manage Orders area.
Previous
 
Next
New Post
4/7/2011 8:20 AM
 

I have been using version 4.25 all day yesterday with no issues... I tested it before pushing it live. However... now I am running into this issue:

When going into the Admin Menu then going to the Manage Orders icon... I get this error:

DotNetNuke Error


 

Error An error has occurred.
DotNetNuke.Services.Exceptions.PageLoadException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'dnnlogin'. ---> System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'dnnlogin'. at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at System.Web.UI.DataBinder.Eval(Object container, String expression) at ASP.desktopmodules_smith_buynow_manageorders1_ascx.__DataBinding__control83(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBind() at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.BaseDataList.DataBind() at Smith.DNN.Modules.BuyNow.ManageOrders1.BindData() at Smith.DNN.Modules.BuyNow.ManageOrders1.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

I do not get this anywhere else on the cart software... any idea from the error above why this is happening? I can backup the data and start over - however I would like to avoid this if at all possible. Again - this was working then all of a sudden it is not now.

Can an order have been corrupted? Thanks for any insight.

 
New Post
4/7/2011 1:22 PM
 

Another thing to keep in mind is that this error only occours on one of the sites in this instance. I have two portals that both use this store module... the one store is fine... I can access the manage orders page fine... but another throws the error... didn't know if this will help the diagnosis.

 
New Post
4/7/2011 2:30 PM
 

When you say the error only occurs on this instance do you mean "version".  The error only happens on v4.25 that you just upgraded?

 

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/7/2011 2:30 PM
 

When you say the error only occurs on this instance do you mean "version".  The error only happens on v4.25 that you just upgraded?

 

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/7/2011 2:31 PM
 
When you say the error only occurs on this instance do you mean "version". The error only happens on v4.25 that you just upgraded?

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/7/2011 2:35 PM
 
I'm sorry let me clarify: I have a 5.6.2 instance of DNN. In this instance there are 4 portals. 2 of these portals utilize the smith cart module (4.25) The error only occurs in one of the portals - not both. Because they are on the same instance of the dnn install I am con fussed as to why this error is happening, Does this clear up the concussion?
 
New Post
4/7/2011 3:18 PM
 

In SQL Mgmt Studio open the store proc "Smith_SA_ListCustomers" and add the dnnlogin field as highlighted below:

ALTER PROCEDURE [dbo].[dnn_Smith_SA_ListCustomers]
    @PortalId int
AS

select distinct c.customerid,c.firstname,c.lastname,c.email,c.Address1,c.address2,c.City,c.state,c.country,c.companyname,c.zip,c.homephone,
c.workphone,c.dnnlogin,
o.orderdate,o.status,o.trackingnumber,convert(varchar,o.taxtotal) as taxtotal,o.affiliateid,o.surcharge,o.shipmethod,
o.orderid,convert(varchar,o.shippingtotal) as shippingtotal,convert(varchar,o.handlingcharge) as handlingcharge,o.specialinstructions,
coup.couponcode,convert(varchar,o.discount) as discount, ph.billingaddress,ph.billingzip,ph.acctno,ph.exproute,convert(varchar,ph.amount) as amount,
ph.payhistid,ph.authcode,ph.notes,ph.status as paystatus,ph.billingname,ph.billingcity,ph.billingstate,ph.billingcountry, ph.transid,
o.ShipDate,o.shipaddress2

from dnn_smith_storeorders o
join dnn_smith_customer c on
o.customerid = c.customerid
left outer join dnn_smith_payhist ph on
o.payhistid = ph.payhistid  
left outer join dnn_smith_coupons coup on
o.couponid = coup.couponid
where o.portalid = @PortalId   
order by o.orderid desc

 

Then click run to update the store proc and it will fix the issue.  This fix will be be realeased in cart v4.26 shortly.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
4/8/2011 6:35 AM
 

That did it! Thank you very much for the information. Much appreciated.

 
New Post
4/8/2011 6:56 AM
 

That fixed it for me, too.  That change needs to be in the latest build.

 

 

 
New Post
4/8/2011 10:16 AM
 
It's in the latest build v4.26 on the downloads page.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDNN Error in 4.25 when accessing the Manage Orders area.DNN Error in 4.25 when accessing the Manage Orders area.