Web Wiz Forums - Cannot Add New Topic or Reply

Print Page | Close Window

Cannot Add New Topic or Reply

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=30497
Printed Date: 31 March 2026 at 1:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Cannot Add New Topic or Reply

Posted By: Testin123
Subject: Cannot Add New Topic or Reply
Date Posted: 03 October 2012 at 10:13am

I am having the same error message when trying to add a new topic.

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:

Any clues?

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
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: Testin123
Date 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.

Posted By: Testin123
Date 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.

Posted By: WebWiz-Bruce
Date Posted: 03 October 2012 at 12:06pm

Have you moved the SQL Server Database or migrated the data by any chance?

-------------
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: Testin123
Date 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?

Posted By: WebWiz-Bruce
Date 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.

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