Web Wiz Forums - Updated forum from v.9.69 2 v.10.01

Print Page | Close Window

Updated forum from v.9.69 2 v.10.01 - have a probl

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=29650
Printed Date: 01 April 2026 at 3:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Updated forum from v.9.69 2 v.10.01 - have a probl

Posted By: haq
Subject: Updated forum from v.9.69 2 v.10.01 - have a probl
Date Posted: 12 August 2011 at 4:53pm

Friends, hello!

I've updated the forum from version 9.69 to 10.01, using this statement http://www.webwiz.net/web-wiz-forums/kb/sql--upgrade.хтм - http://www.webwiz.net/web-wiz-forums/kb/sql--upgrade.хтм

Forum was updated and now working.
BUT now when I try create a new topic or reply to an existing topic, I see only this error:

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

What do you think about this?

Thank you in advance for your answers!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 August 2011 at 8:22pm

Could be that your database is full but without seeing a complete error it would be hard to say.

-------------
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: haq
Date Posted: 13 August 2011 at 12:04am

No size limit. FULLY error indicated above.

What else can cause this error?

Posted By: WebWiz-Bruce
Date Posted: 13 August 2011 at 8:38am

Turn the the full error message from the admin area of your forum as the short error message is not telling 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: haq
Date Posted: 13 August 2011 at 5:11pm

Of course.

If I create 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.01

Error details:-
Microsoft OLE DB Provider for SQL Server
Cannot insert the value NULL into column 'Topic_ID', table 'g-class1.dbo.tblTopic'; column does not allow nulls. INSERT fails.

If I reply in existing 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_post_data
File Name:- new_post.asp
Forum Version:- 10.01

Error details:-
Microsoft OLE DB Provider for SQL Server
Cannot insert the value NULL into column 'Thread_ID', table 'g-class1.dbo.tblThread'; column does not allow nulls. INSERT fails.

Posted By: haq
Date Posted: 13 August 2011 at 11:10pm

UP.
Well so do? It seems that the forum does not give data to the database.
Why? Have ideas?

Remark, may be useful: in the coding forum i set win-1251

Posted By: WebWiz-Bruce
Date Posted: 15 August 2011 at 9:18am

The error means that your database is corrupted and missing it's default values. In this case the tblTopic.Topic_ID should be set to populate this field with an incremental value.

The most common reason for the database loosing it's default values is if the database is exported/imported from another source for example moving servers.

To correctly move an SQL Server Database you need to create a backup of the database (.bak file) which can then be restored on the new server.

-------------
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: haq
Date Posted: 22 August 2011 at 7:24am

All the same there. Now everything works. Thank you!