Web Wiz Support and Community Forums : SQL Error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 23:39:02 +0000 Sun, 11 Mar 2007 05:55:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22395 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Error : i am getting the same error. how...]]> https://forums.webwiz.net/sql-error_topic22395_post121182.html#121182 Author: nomadtx
Subject: 22395
Posted: 11 March 2007 at 5:55am

i am getting the same error.  how did you fix this?]]> Sun, 11 Mar 2007 05:55:19 +0000 https://forums.webwiz.net/sql-error_topic22395_post121182.html#121182 <![CDATA[SQL Error : Dam.... It seems the whole thing...]]> https://forums.webwiz.net/sql-error_topic22395_post119333.html#119333 Author: __n3o__
Subject: 22395
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 Cry
]]> Fri, 12 Jan 2007 19:37:57 +0000 https://forums.webwiz.net/sql-error_topic22395_post119333.html#119333 <![CDATA[SQL Error : Hi Bruce...Unfortunately this...]]> https://forums.webwiz.net/sql-error_topic22395_post119322.html#119322 Author: __n3o__
Subject: 22395
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 Angry...  (Its a long story!)

Where should I look to find what the default values should be??  Thanks
]]> Fri, 12 Jan 2007 12:56:04 +0000 https://forums.webwiz.net/sql-error_topic22395_post119322.html#119322 <![CDATA[SQL Error : It looks like you database is...]]> https://forums.webwiz.net/sql-error_topic22395_post119319.html#119319 Author: WebWiz-Bruce
Subject: 22395
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.
]]> Fri, 12 Jan 2007 09:57:00 +0000 https://forums.webwiz.net/sql-error_topic22395_post119319.html#119319 <![CDATA[SQL Error : Seems I can update posts and settings......]]> https://forums.webwiz.net/sql-error_topic22395_post119317.html#119317 Author: __n3o__
Subject: 22395
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?]]> Fri, 12 Jan 2007 08:54:38 +0000 https://forums.webwiz.net/sql-error_topic22395_post119317.html#119317 <![CDATA[SQL Error : Wonder if anyone might be able...]]> https://forums.webwiz.net/sql-error_topic22395_post119313.html#119313 Author: __n3o__
Subject: 22395
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
Cannotinsert 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?
]]> Fri, 12 Jan 2007 07:03:30 +0000 https://forums.webwiz.net/sql-error_topic22395_post119313.html#119313