Web Wiz Forums - Error when creating event

Print Page | Close Window

Error when creating event

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

Topic: Error when creating event

Posted By: Jesper
Subject: Error when creating event
Date Posted: 01 April 2006 at 11:19pm

I get the following error when I try to create an event (in v8 rc1.1):

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_save_new_topic_data
File Name:- new_post.asp

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

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 April 2006 at 10:31am

The only thing I can think is that your SQL Server database is not setup correctly.

The Topic_ID column in the tblTopic table needs to be set to IDENTITY with a SEED of 1 so that an ID number is automatically set by the database.

Could you please give details on how you created the database, if you modified the database, and if it is an upgrade.

Posted By: Jesper
Date Posted: 10 April 2006 at 9:19pm

This problem has now re-occured after I upgraded the 7.x to 8.0RC1.

I moved the database to SQL2k5 and then ran the migration script.

Posted By: Jesper
Date Posted: 10 April 2006 at 9:20pm

oh... the sql server is (and was) a standard installation - nothing fancy, nothing changed. Just standard 'next.. next.. finish).

Posted By: WebWiz-Bruce
Date Posted: 11 April 2006 at 11:49am

It likes like when you moved the database to another server it wasn't successful and therefore the default values for some of the columns wasn't carried across.