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

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
haq Members Profile Find Members Posts Newbie Joined: 06 January 2008 Location: Russia, Moscow Status: Offline Points: 22	Post Options Post Reply Quote haq Report Post Thanks(0) Quote Reply Topic: Updated forum from v.9.69 2 v.10.01 - have a probl 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!

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 August 2011 at 8:22pm
	Could be that your database is full but without seeing a complete error it would be hard to say.
	Web Wiz Forums Hosting ASP.NET Web Hosting

haq Members Profile Find Members Posts Newbie Joined: 06 January 2008 Location: Russia, Moscow Status: Offline Points: 22	Post Options Post Reply Quote haq Report Post Thanks(0) Quote Reply Posted: 13 August 2011 at 12:04am
	No size limit. FULLY error indicated above. What else can cause this error?

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: 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

haq Members Profile Find Members Posts Newbie Joined: 06 January 2008 Location: Russia, Moscow Status: Offline Points: 22	Post Options Post Reply Quote haq Report Post Thanks(0) Quote Reply 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.

haq Members Profile Find Members Posts Newbie Joined: 06 January 2008 Location: Russia, Moscow Status: Offline Points: 22	Post Options Post Reply Quote haq Report Post Thanks(0) Quote Reply 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 Edited by haq - 13 August 2011 at 11:15pm

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(1) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

haq Members Profile Find Members Posts Newbie Joined: 06 January 2008 Location: Russia, Moscow Status: Offline Points: 22	Post Options Post Reply Quote haq Report Post Thanks(0) Quote Reply Posted: 22 August 2011 at 7:24am
	All the same there. Now everything works. Thank you!

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