HomeHome Product Discus... Product Discus...SmithCartSmithCartColumn Column 'RemoveDnnRole' does not belong to table _ProductList.
Previous
 
Next
New Post
12/4/2011 10:00 AM
 
Simon Trice
No Ranking


Joined: 7/3/2011
Posts: 10

I have got the latest version of smith cart installed on my website, however once a transaction has been completed by Paypal, it returns with the following error message.

A critical error has occurred.
Column 'RemoveDnnRole' does not belong to table _ProductList.

Checking in the database and the transaction has updated to paid status, but doesn't return the customer to the confirmation page after paypal.

Please help, as i have currently the website down.
 
New Post
12/4/2011 10:14 AM
 
Simon Trice
No Ranking


Joined: 7/3/2011
Posts: 10
this is the error message within the Event Viewer of DNN

AssemblyVersion: 5.5.1
PortalID: 0
PortalName: Formula 1 Teamwear
UserID: 4
UserName: steve1
ActiveTabID: 61
ActiveTabName: Store
RawURL: /Home/Store/tabid/61/ctl/Confirm/mid/381/Default.aspx?PayPal=Success&tx=1DP50725JT428474H&st=Completed&amt=1.95&cc=GBP&cm=&item_number=
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1efcb2b1-2a41-4538-bb80-c4f9b60a40ac
InnerException: Column 'RemoveDnnRole' does not belong to table _ProductList.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.DataRow.GetDataColumn
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Column 'RemoveDnnRole' does not belong to table _ProductList. ---> System.ArgumentException: Column 'RemoveDnnRole' does not belong to table _ProductList. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at Smith.DNN.Modules.BuyNow.Confirm.AddRemoveRoles(UserInfo objUserInfo) at Smith.DNN.Modules.BuyNow.Confirm.HandlePayPalReturn() at Smith.DNN.Modules.BuyNow.Confirm.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: GENERICUK03
 
New Post
12/5/2011 12:58 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Simon,

Which version of the Cart are you currently running?

Have you configured any Roles to be removed for the product you ran the transaction with?

Thanks,
 
New Post
12/5/2011 2:09 PM
 
Simon Trice
No Ranking


Joined: 7/3/2011
Posts: 10
I am running version 4.75 and haven't changed any settings relating to roles in the system
 
New Post
12/5/2011 8:05 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Simon,

Have any Roles been configured to be removed for the product you ran the transaction with?

I just tried to re-produce this issue on my test portal and was unable to recreate the behavior you described above, but I may not have the exact same configuration as you. Can you login to our test site http://www7.smith-consulting.com/ and try to replicate the error. This will determine if the issue is with the latest version of the cart or an issue with your specific dnn portal/cart install. Please email me at kevin@smith-consulting.com if login credentials are needed.

Thanks,
 
New Post
12/6/2011 2:33 AM
 
Simon Trice
No Ranking


Joined: 7/3/2011
Posts: 10
Hi Kevin

I haven't made any changes to permissions or the roles within the module. I simply upgraded the module on Sunday night using the latest cart, and when setup to use paypal, getting this error message upon completion.

If i were to email you my log-in details to the store, would you please be able to look at the settings?
 
New Post
12/6/2011 1:06 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Simon,

I believe you may have received a pre-release version of v.4.75, please email me at kevin@smith-consulting.com and I will send you an updated version.

Thanks,
 
New Post
12/10/2011 9:18 AM
 
Simon Trice
No Ranking


Joined: 7/3/2011
Posts: 10

Hi Kevin

I have emailed you as requested, but still haven't heard anything back yet.

I have also email the support email regarding a problem with another payment gateway which they have written for me.

Getting the payment gateway is now very important, as i have had to roll back the website, from the latest version.
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartColumn Column 'RemoveDnnRole' does not belong to table _ProductList.




Questions? Contact us for answers!

Contact Us!