Cannot Add New Topic or Reply

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Testin123 Members Profile Find Members Posts Newbie Joined: 16 May 2007 Status: Offline Points: 11	Post Options Post Reply Quote Testin123 Report Post Thanks(0) Quote Reply Topic: Cannot Add New Topic or Reply Posted: 03 October 2012 at 10:13am
	I am having the same error message when trying to add a new topic. Server Error in Forum Application An error has occurred while writing to the database. Please contact the Forum Administrator. Support Error Code:- err_SQLServer_save_new_topic_data File Name:- new_post.asp Forum Version:- 10.12 The forum has been idle for some time so this may not be a new error. It was upgraded from 9.x quite recently. It is on the same database server as before - SQL 2008 R2 (Standard or Enterprise). Also happens when replying to a thread: Server Error in Forum Application An error has occurred while writing to the database. Please contact the Forum Administrator. Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp Forum Version:- 10.12 Any clues?

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: 03 October 2012 at 10:27am
	Try enabling 'Detailed Error Reporting' from the 'Web Wiz Forums General Settings' page in the admin area. This should then give a more detailed error message which will hopefully tell us what the issue is.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Testin123 Members Profile Find Members Posts Newbie Joined: 16 May 2007 Status: Offline Points: 11	Post Options Post Reply Quote Testin123 Report Post Thanks(0) Quote Reply Posted: 03 October 2012 at 11:20am
	Did that and I have: Server Error in Forum Application An error has occurred while writing to the database. Please contact the Forum Administrator. Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp Forum Version:- 10.12 Error details:- Microsoft OLE DB Provider for SQL Server Cannot insert the value NULL into column 'Thanks', table 'Forum.dbo.tblThread'; column does not allow nulls. INSERT fails.

Testin123 Members Profile Find Members Posts Newbie Joined: 16 May 2007 Status: Offline Points: 11	Post Options Post Reply Quote Testin123 Report Post Thanks(0) Quote Reply Posted: 03 October 2012 at 11:20am
	And when add new topic: Server Error in Forum Application An error has occurred while writing to the database. Please contact the Forum Administrator. Support Error Code:- err_SQLServer_save_new_topic_data File Name:- new_post.asp Forum Version:- 10.12 Error details:- Microsoft OLE DB Provider for SQL Server Cannot insert the value NULL into column 'Rating_Votes', table 'Forum.dbo.tblTopic'; column does not allow nulls. INSERT fails.

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: 03 October 2012 at 12:06pm
	Have you moved the SQL Server Database or migrated the data by any chance?
	Web Wiz Forums Hosting ASP.NET Web Hosting

Testin123 Members Profile Find Members Posts Newbie Joined: 16 May 2007 Status: Offline Points: 11	Post Options Post Reply Quote Testin123 Report Post Thanks(0) Quote Reply Posted: 03 October 2012 at 12:46pm
	Not as far as I know, no. The forum has been idle for a couple of years. I read the note that the databases have to be backed-up and then restored. If the schema is somehow corrupt I can start again with an empty database - unless there is an easy fix for this?

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: 03 October 2012 at 1:08pm
	Judging by the error messages I would say that the database has lost the default values, this usually happens when someone uses the SQL Server migration tools to move or replicate the database, as these reconstruct the table and data and not the primary keys, foreign keys and default values.
	Web Wiz Forums Hosting ASP.NET Web Hosting

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