Server Error

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
10/10/2013 9:20:52 AM
Gravatar
Total Posts 3

Server Error

I purchased Site Membership Pro and Form Wizard Pro. I am getting a "server error" when I click on the links to view Order History or when I do an order search. Also, I get the same error when I try to edit any form from Form Wizard Pro. What the heck is going on?

This is the error message:

"We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page."

Thanks for any help on this.

10/10/2013 9:33:30 AM
Gravatar
Total Posts 18439

Re: Server Error

Hi,

First make sure you are running compatible versions, the product pages for those products indicate the system requirements, ie the required version of mojoPortal. You can find your current versions under Administration > System Info

If needed upgrade to the latest version of mojoPortal to be compatible with the latest version of the products.

If that doesn't solve the problem then start with Basic Troubleshooting to find out the error details.

Hope that helps,

Joe

10/10/2013 11:28:06 PM
Gravatar
Total Posts 3

Re: Server Error

Hi Joe; thanks for getting back to me. I had version 2.3.9.8, which the form builder did not like. That issue is now resolved. I have upgraded to the newest version, but I am still getting an error when I click on the link to either view "Order History" or if I do an order search from the Manage page. I copied the log details below. I am not sure exactly what this means, but I think it may have something to do with null values in a date field.(?)

LOG DETAILS:

2013-10-10 21:17:59,370 ERROR 107.219.156.132 - en-US - /smp/OrderSearch.aspx?pageid=11&mid=28 - mojoPortal.Web.Global -  Referrer(http://www.nlapart.net/smp/OrderSearch.aspx?pageid=11&mid=28) useragent Mozilla/5.0 (Windows NT 5.1; rv:24.0) Gecko/20100101 Firefox/24.0
System.InvalidCastException: Object cannot be cast from DBNull to other types.
   at System.DBNull.System.IConvertible.ToDateTime(IFormatProvider provider)
   at System.Convert.ToDateTime(Object value)
   at ASP.smp_ordersearch_aspx.__DataBind__control12(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.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   at System.Web.UI.WebControls.GridView.DataBind()
   at sts.SiteMembership.Web.OrderSearchPage.BindGrid()
   at sts.SiteMembership.Web.OrderSearchPage.btnSearch_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

Thanks for your help,

Matt

10/11/2013 11:10:09 AM
Gravatar
Total Posts 18439

Re: Server Error

Hi Matt,

I'm trying to reproduce this problem. Can you confirm which database platform you are using, MSSQL or MySql?

Thanks,

Joe

10/11/2013 11:54:07 AM
Gravatar
Total Posts 3

Re: Server Error

Good morning, Joe; I am using MSSQL. I'm not sure if this is helpful or not, but I did not have my SMTP settings configured when I registered the first user profile. I approved the user registration as an admin, thus bypassing email confirmation since no email went out. Then I purchased membership content from that profile to make sure PayPal integration was working. I'm not sure if maybe that left a null in a date field somewhere. I'm not the doctor so I hope this info is helpful.

Thanks again for your help and have a great Friday,

-Matt

10/11/2013 1:42:24 PM
Gravatar
Total Posts 18439

Re: Server Error

Hi Matt,

With PayPal there are 2 ways that the site can get notified of the transaction, PDT and IPN both of which have to configured at PayPal. IPN is most important to configure because PDT only happens if the user clicks the link to go back to the merchant site after paying. With IPN you configure an the url and PayPal does a server to server post. If either an IPN post or a PDT post happens then it should process the order and the begin and end dates of the membership are calculated and set (confirmation email would also be sent). But it sounds like those fields must be null in a order row in sts_MembershipTicket table. It is expected that those fields would be null on a cart row in the same table. The only difference between a cart row and an order are the OrderStatusGuid, it sounds like somehow you got a row with a status of order but the begin and end dates were never calculated and are null. I'm going to create that condition and make it tolerant so it doesn't crash the page but still need to figure out what went wrong and how that happened to ensure that future orders work correctly.

Do you know if IPN and PDT are configured in your PayPal?

Were there any errors in the log that looks like they are from paypal posting to the site?

Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.