SQL Error
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22395
Printed Date: 07 April 2026 at 11:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Error
Posted By: __n3o__
Subject: SQL Error
Date Posted: 12 January 2007 at 7:03am
|
Wonder if anyone might be able to point me in the right direction? I have just uploaded the latest version of WWF onto a new server. I am using SQL 2005 Express... It works find until I try to post.. Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp Error details:- Microsoft OLE DB Provider for SQL Server Cannot insert the value NULL into column 'Thread_ID', table 'tblThread'; column does not allow nulls. INSERT fails. I am sure I have given read and write permission to users on the SQL Db? |
Replies:
Posted By: __n3o__
Date Posted: 12 January 2007 at 8:54am
| Seems I can update posts and settings... I just can't insert? Any ideas why its not getting the thread_ID? |
Posted By: WebWiz-Bruce
Date Posted: 12 January 2007 at 9:57am
|
It looks like you database is not setup correctly. SQL Server should use an identity seed to automatically create a number for the Thread_ID. Make sure that the default values for your database have been setup. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: __n3o__
Date Posted: 12 January 2007 at 12:56pm
|
Hi Bruce... Unfortunately this is a long story... This is a SQLDb thats been exported to access and upsized to SQL  ... (Its a long story!)Where should I look to find what the default values should be?? Thanks |
Posted By: __n3o__
Date Posted: 12 January 2007 at 7:37pm
|
Dam.... It seems the whole thing is playing up Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Forum_ID', table 'tblForum'; column does not allow nulls. INSERT fails. /forum/admin_forum_details.asp, line 213 Think I had better have a look at the DB in detail... or start again |
Posted By: nomadtx
Date Posted: 11 March 2007 at 5:55am
| i am getting the same error. how did you fix this? |