We can not write post anymore
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=31428
Printed Date: 29 March 2026 at 12:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: We can not write post anymore
Posted By: Flyman30
Subject: We can not write post anymore
Date Posted: 27 November 2016 at 4:24pm
After installing a backup of the database Sqlserver we can read the posts of the forums but we can no longer write a new post.
The error message is:
Support Error Code:- err_SQLServer_save_new_topic_data
File Name:- new_post.asp
Forum Version:- 11.03
Error details:-
Microsoft OLE DB Provider for SQL Server
Cannot
insert the value NULL into column 'Thanks', table
'web_ass_1525com_6480_heb788_.dbo.tblThread'; column does not allow
nulls. INSERT fails.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 28 November 2016 at 12:01pm
Did you restore from a full SQL Server Database backup (a .bak file)?
If not and you used the import/export tools is SQL Server Management Studio then it is likely that while the data was restored the full database schema including default values, primary keys, foreign keys, indexes, and other parts of the database schema have not been restored.
If you have a full full SQL Server Database backup (a .bak file) you should restore the database from that so that it retains the full database schema.
If not then you will have the long laborious task of creating a new database of Web Wiz Forums and then comparing it with the restored one to re-create all the missing parts of the database schema.
-------------
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: Flyman30
Date Posted: 30 November 2016 at 7:26am
We are on a shared hosting
that uses Plesk I did not have a lot of possible actions on the BDD, the
host had a faulty or incomplete backup.
So I deleted
the BDD and reinstalled with the latest version of the forum, so we lost
all of our members and history messages ...
This is a private forum to our association so it is not a too serious loss.
|
|