SQL Error

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply Topic: SQL Error 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?

__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply 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

__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply 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

nomadtx Members Profile Find Members Posts Newbie Joined: 24 December 2006 Location: United States Status: Offline Points: 19	Post Options Post Reply Quote nomadtx Report Post Thanks(0) Quote Reply Posted: 11 March 2007 at 5:55am
	i am getting the same error. how did you fix this?

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.