_SupportTicketTypes.aspx not Accessible

Posted By shulemj Thu 30 Mar 2017
Add to Favorites1
Author Message
shulemj
 Posted Thu 30 Mar 2017
Supreme Being

Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
I cannot reach the backend page _SupportTicketTypes.aspx, as it throws a Oops! error.

This is the log entry:
-----------------------------------------------------------------------------
>> Version:2.9005
>> URL:http://www.malchutjudaica.com/Admin/_SupportTicketTypes.aspx
>> Page:
-----------------------------------------------------------------------------
>> 3/29/2017 5:41:23 PM
>> 47.16.211.251
>> DESCRIPTION:
System.InvalidCastException: Operator '=' is not defined for type 'DBNull' and string "s".
at Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(Object Left, Object Right, Boolean TextCompare)
at ASP.admin__supporttickettypes_aspx.__DataBinding__control14(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 Admin_SupportTicketTypes.LoadSupportTicketTypes()
at Admin_SupportTicketTypes.Page_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Any help would be greatly appreciated.
Paul
 Posted Wed 5 Jul 2017
große Käse

große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)große Käse - (509,258 reputation)

Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807, Visits: 2,748
Try this... open up the /Admin/_SupportTicketTypes.aspx file (not the .vb one) and find this:

Visible='<%# Eval("STT_Level") = "s" %>

change to

Visible='<%# CkartrisDataManipulation.FixNullFromDB(Eval("STT_Level")) = "s" %>

(basically, we just call our FixNullFromDB function to turn Null values to zero length strings and stop the error).

It's happening because you have a null value in the STT_Level field of a record (or more than one record) in the tblKartrisSupportTicketTypes table. If you open that up, you could fix by just putting an 's' in there.

Basically the s or p was a distinction we put into Kartris to distinguish between support types available to premium/paid (p) customers or those that were sales/standard (s).


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
shulemj
 Posted Wed 5 Jul 2017
Supreme Being

Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)Supreme Being - (58,887 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
Thanks, Paul.

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top