|
|
Posted 15/03/2006 05:15:07 |
|
|
Forum Newbie
      
Group: Forum Members
Last Login: 15/03/2006 21:19:41
Posts: 1,
Visits: 3
|
|
| 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. 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. I am running InstantKB with SQL Server 2005. Is it an issue? Will the product works with SQL 2005. Please clarify. Can you provide any idea as to how to fix this error?
|
|
|
|
Posted 15/03/2006 12:42:59 |
|
|
Support Supremo
      
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
anand_n (3/15/2006)
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. 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. I am running InstantKB with SQL Server 2005. Is it an issue? Will the product works with SQL 2005. Please clarify. Can you provide any idea as to how to fix this error? Dear anand_n, 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.
|
|
|
|