InstantASP Community Forums / Old Forums / InstantKB.NET 1.x / Installation / Update / Unable to add/update articles / Latest PostsInstantForum.NET v4.1.4InstantASP Community Forumshttp://community.instantasp.co.uk/sales@instantasp.co.ukFri, 09 Jan 2009 10:30:23 GMT20RE: Unable to add/update articleshttp://community.instantasp.co.uk/Topic10374-25-1.aspx[quote][b]anand_n (3/15/2006)[/b][hr]Following error is displayed when I attempt to add new article or update new article. I moved from one server to another and I restored all databases. The site is working fine however. I can read articles. <P><STRONG>Error Message: Cannot insert the value NULL into column 'QuestionID', table 'DATABASENAME.DATABASEUSERNAME.InstantKB_Articles'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'QuestionID', table ' DATABASENAME.DATABASEUSERNAME.InstantKB_ArticlesTreeNodes'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated.</STRONG> </P><P>I am running InstantKB with SQL Server 2005. Is it an issue? Will the product works with SQL 2005. Please clarify. <P>Can you provide any idea as to how to fix this error?[/quote] <P>Dear anand_n, <P>Would it be possible for me to access your system remotely via Remote Desktops or similar remoting tool? If so, please pm me with the url, the username, and the password. </FONT>Wed, 15 Mar 2006 12:42:59 GMTCarlos MunizUnable to add/update articleshttp://community.instantasp.co.uk/Topic10374-25-1.aspxFollowing error is displayed when I attempt to add new article or update new article. I moved from one server to another and I restored all databases. The site is working fine however. I can read articles.<P><STRONG>Error Message: Cannot insert the value NULL into column 'QuestionID', table 'DATABASENAME.DATABASEUSERNAME.InstantKB_Articles'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'QuestionID', table ' DATABASENAME.DATABASEUSERNAME.InstantKB_ArticlesTreeNodes'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated.</STRONG> </P><P>I am running InstantKB with SQL Server 2005. Is it an issue? Will the product works with SQL 2005. Please clarify.<P>Can you provide any idea as to how to fix this error?Wed, 15 Mar 2006 05:15:07 GMTanand_n