InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


Error Message: Operator is not... Expand / Collapse
Author
Message
Posted 18/10/2005 16:02:13


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 20/10/2005 15:11:50
Posts: 1, Visits: 6
When trying to do an artical serch from the admin login, I receive this error. As far as I know nothing has changed on the system and it used to work ok. All other functions appear ok. Below is the latest contents of the exceptions.config file which the error says to send to support to debug this.

Any suggestions?

Thanks!

<Exception>
    <Message>Operator is not valid for type 'DBNull' and string "0".</Message>
    <Source>Microsoft.VisualBasic</Source>
    <StackTrace>   at Microsoft.VisualBasic.CompilerServices.ObjectType.ThrowNoValidOperator(Object obj1, Object obj2)
   at Microsoft.VisualBasic.CompilerServices.ObjectType.ObjTst(Object o1, Object o2, Boolean TextCompare)
   at InstantKB.InstantKB_AdminUpdate.ArticleGrid_ItemDataBound(Object Sender, DataGridItemEventArgs e)
   at System.Web.UI.WebControls.DataGrid.OnItemDataBound(DataGridItemEventArgs e)
   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 InstantKB.InstantKB_AdminUpdate.BindQuestionData()</StackTrace>
    <AppPath>http://wenco3/instantkb13/</AppPath>
    <URI>/instantkb13/admin/update.aspx</URI>
    <DateTime>10/18/2005 11:48:41 AM</DateTime>
  </Exception>
</ExceptionLog>

Post #8862
Posted 28/10/2005 09:38:43


Support Supremo

Support SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport Supremo

Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568, Visits: 2,507
Dear Graber,

It seems that some rows in the InstantKb_Articles table has null in the ArticleType column. Could you please run the following command on your database? 

Update InstantKB_Articles Set ArticleType = 'INFO: ' where ArticleType is Null.

Post #8944
« Prev Topic | Next Topic »

Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ryan Healey, Mark Christianson, James Trott

Permissions Expand / Collapse

All times are GMT, Time now is 2:23am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 9 queries. Compression Disabled.
Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.