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


Unable to add/update articles Expand / Collapse
Author
Message
Posted 15/03/2006 05:15:07
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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?

Post #10374
Posted 15/03/2006 12:42:59


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
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. 

Post #10386
« 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 6:54pm

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